Getting your tools ready…

176 free tools · PDF, images, calculators & more
{/* Tool-first layout (2026-11-14): slim hero — kicker + H1 only. The lead, author byline, published line and pills moved below the tool; nothing sits between the H1 and the tool fields. */}

DOCUMENT & SPREADSHEET FLAGSHIP

JSON To CSV

{/* Tool prominence (54.97.52): the shell tool section is wrapped in the same distinct card as the React surface — soft tint, visible border, soft shadow — so the served HTML shows the card before hydration. */}

At a glance

JSON to CSV — Convert an array of JSON objects into a CSV file, with the column set built from the union of every key in the data.

Free for the core workflow, no account required. Files are processed in the browser for these workflows and are not intentionally uploaded by the tool.

About JSON to CSV

Convert an array of JSON objects into a CSV file, with the column set built from the union of every key in the data.

JSON is a convenient shape for programs and an awkward one for spreadsheets, which is why this conversion exists: take an array of objects and lay it out as a flat table. The converter has exactly one structural decision to make, and it makes it for you: the column set is the union of every key that appears in any object, in the order the keys are first seen. No field is ever dropped silently, which is the guarantee that matters most when the objects do not all have the same shape. Worked example — three people with different fields. The input is an array of three objects: the first has name Ava, age 29, and city Lahore; the second has name Marco and age 34; the third has name Priya, city Multan, and role Support. The union of keys, in first-seen order, is name, age, city, role, and that becomes the header row: name,age,city,role. The output rows are Ava,29,Lahore, then Marco,34,,, then Priya,,Multan,Support. Marco has no city and no role, so his row ends with two empty cells, and Priya has no age, so her row has an empty cell in the second column. The two ages present, 29 and 34, add to 63, which is the check that the rows landed in the right columns: if a value had slipped one cell sideways, the total would be wrong or a name would appear under age. Table — how special values are written into the CSV: a nested object becomes a JSON string inside the cell, for example {"city": "Lahore"}; an array becomes a JSON string such as ["a","b"]; a null becomes an empty cell; a boolean becomes the word true or false; a number is written plainly; a string containing a comma or a double quote is wrapped in quotes with the quotes doubled, exactly as RFC 4180 requires. Before / after — before: three objects with different keys, readable only by a program; after: a four-column table with a header row that any spreadsheet or database import can read, where the empty cells honestly show which fields each record lacked. The shape to watch for is the sparse one. When the union of keys runs to dozens of columns and most cells are empty, the data was never really tabular, and the CSV will be hard to use. Flatten or filter the JSON first so the objects share a small, consistent set of keys, and the output becomes a table a person can actually work with. A document rarely needs just one pass. The CSV to TSV converts comma-separated CSV data into a tab-separated file for databases, mainframe feeds, and command-line tools that prefer tabs, while the TSV to CSV converts tab-separated values into a standard comma-separated CSV file, with quoting handled correctly on the way over. The CSV Column Extractor pulls one column out of a CSV file by its header name and returns a clean text list of its values as well. Sources: RFC 4180, Common Format and MIME Type for Comma-Separated Values (CSV) Files (2005); ECMA-404, The JSON Data Interchange Syntax (2017); RFC 8259, The JavaScript Object Notation (JSON) Data Interchange Format (2017). Content last reviewed: November 2026. The converter builds the union of all keys across objects as the column set, so no field is lost even when objects have different shapes. Values containing commas or quotes are properly escaped per CSV rules.

Primary objective: Convert an array of JSON objects into a CSV file with a combined column set.

Privacy assurance: Files are processed in the browser for these workflows and are not intentionally uploaded by the tool.

How to Use JSON to CSV

  1. Paste your JSON array into the converter or drop the JSON file onto it.
  2. Confirm the top level is an array of objects; a single object or a nested document will not lay out as a table.
  3. Review the preview header row and check that the column set covers every key you need.
  4. Run the conversion and download the CSV file.
  5. Open the CSV in a spreadsheet and confirm the row count matches the number of objects, then check one sparse row against its source object.

Key Use Cases & Applications

  • Exporting API logs to CSV for analysis in Excel.
  • Creating an import file for a system that only accepts CSV.
  • Turning a JSON contact list into a spreadsheet for a mail merge.
  • Preparing structured records for a database bulk import.

Frequently Asked Questions

Why does my CSV have empty cells in the middle of rows?

An empty cell means that object had no value for that column. The column set is the union of all keys, so any object missing a key leaves a blank in exactly that position, and the blanks keep every other value in its correct column.

How do I stop the column list from growing with every object?

You cannot cap it in the converter, because dropping a key would silently lose data. Reshape the JSON first so every object carries the same small set of keys, then convert.

What happens to a value that contains a newline?

The field is wrapped in quotes and the newline is preserved inside it, which is valid CSV. A few strict import tools reject multi-line fields, so replace newlines with spaces first when the destination is picky.

Can I export only some fields?

There is no column picker in this tool. Reshape the JSON before converting, keeping only the keys you want, and the CSV will contain exactly those columns.

By Shehzad Hussain — owner and editor of ExpTool, based in Multan, Pakistan. He builds and tests every tool on this site himself.

Last updated: 2026-11-04