ToolGenie

JSON to CSV

Turn a JSON array into a CSV table.

Loading tool…

How to use JSON to CSV

  1. Paste a JSON array of objects, or drop a .json file into the editor.

  2. Choose the separator you need: comma, semicolon, tab or pipe.

  3. Review the preview table, then copy the CSV or download the .csv file.

Frequently Asked Questions

What happens to nested objects and arrays?

They are flattened into dotted column names, so {"user":{"id":7}} becomes a column called user.id. Every row keeps the same header, with empty cells where a key is missing.

Will the CSV open correctly in Excel?

Yes. Values containing quotes, line breaks or your separator are quoted following RFC 4180. If Excel puts every row in one column, pick the semicolon separator instead.

Does my data leave the browser?

Never. The conversion is plain JavaScript running on your device, which is why exports of production data are safe to run here.

Related tools

CSV to JSONTurn CSV rows into a JSON array.JSON FormatterBeautify, validate and minify JSON.JSON to YAMLConvert JSON into readable YAML.PDF to ExcelExtract PDF tables into XLSX spreadsheets.Excel to PDFConvert XLSX spreadsheets to PDF.

Looking for something else? Browse all developer tools.