JSON to CSV Converter

About JSON to CSV converter

The JSON to CSV converter turns an array of objects into spreadsheet-ready rows. It flattens nested objects and arrays into their own columns, quotes values correctly, and lets you choose the delimiter and whether to include a header row. The page opens with a sample so you can see the flattening before you paste your own data.

How to use it

1. Replace the sample in the JSON box with your array of objects. A single object is treated as one row.
2. Pick a Delimiter: comma, semicolon, tab, pipe, or Custom with up to four characters.
3. Switch Include header row and Flatten nested objects on or off to suit your target.
4. Watch the CSV output box update, with badges for the row and column counts.
5. Press Copy or Download CSV, which saves a file named data.csv.

Nested address and tag list flattened into columns

[{"id":1,"name":"Ada Lovelace","address":{"city":"London"},"tags":["math","code"]},{"id":2,"name":"Grace Hopper","address":{"city":"New York"},"tags":["navy"]}]

id,name,address.city,tags[0],tags[1]
1,Ada Lovelace,London,math,code
2,Grace Hopper,New York,navy,

When to use it

• Opening an API's JSON response in Excel or Google Sheets for filtering and charts.
• Preparing a data import for a system that only accepts CSV uploads.
• Producing a tab-separated file for a tool that expects TSV.
• Sharing query results with a colleague who does not work with JSON.

Questions about JSON to CSV converter

How are the column names chosen?

From the union of every key found in any row, in the order first seen. If a row lacks a key its cell is left empty, so uneven records still line up under the right header.

What does the Flatten switch do?

With it on, nested objects become dotted columns like address.city, and arrays become indexed ones like tags[0]. With it off, each nested value is written as JSON text inside a single quoted cell.

When are cells wrapped in quotes?

When a value contains the delimiter, a double quote or a line break. Embedded quotes are doubled, which is the RFC 4180 convention that spreadsheet programs expect.

Why does the row badge look too high?

It counts lines in the output, so a cell containing line breaks adds to the total even though it is still one record. The CSV text itself remains correct.

Will Excel read accented characters properly?

The file is UTF-8 without a byte order mark, which some Excel versions misread on a plain double-click. Import it through the Data tab and choose UTF-8 if characters look garbled.

Related tools

• CSV to JSON converterConvert CSV text into JSON with delimiter auto-detection, header-row and type-coercion toggles.
• Env to JSON converterConvert .env files to JSON and back, with quoting, comment and multiline support.
• JSON validator & beautifierValidate JSON content and make it looks good.
• Markdown to HTMLConvert markdown snippets to raw HTML code.
• JSON viewerExplore and search JSON data in a collapsible tree view.
• JSON to TypeScript converterGenerate TypeScript interfaces from a JSON sample, including nested objects, arrays and optional keys.