JSON to CSV Converter
JSON to CSV Converter turns a JSON array of objects into comma-separated values that open cleanly in Excel, Google Sheets or any spreadsheet program. It collects every key across your objects to build the header row, then escapes commas, quotes and line breaks correctly.
Conversion runs in your browser, so even sensitive exports stay on your machine.
How to use JSON to CSV Converter
- 1
Paste a JSON array
Provide an array of objects, e.g. [{"name":"Ada"},{"name":"Linus"}].
- 2
Convert
Click Convert to CSV. The header row is built from the union of all object keys.
- 3
Copy or import
Copy the CSV and paste it into your spreadsheet, or save it as a .csv file.
How JSON maps to CSV
Each object in the array becomes one row, and each unique key becomes a column. If some objects are missing a key, that cell is left blank so the columns stay aligned.
Values that contain commas, double quotes or line breaks are wrapped in quotes and escaped according to the CSV convention, ensuring spreadsheets parse them correctly. Nested objects and arrays are serialized as JSON text within the cell.
JSON to CSV vs JSON to Excel
CSV is a universal, plain-text format that every spreadsheet application can import, including Microsoft Excel. To get an .xlsx file, convert to CSV here and then use your spreadsheet's Import or Open feature — Excel will recognize the columns automatically.
Because CSV is text-only, it does not carry formatting, formulas or multiple sheets. For pure tabular data, that simplicity is an advantage.
Frequently asked questions
- What JSON shape does it expect?
- An array of flat objects works best. A single object is also accepted and produces one data row.
- How are commas inside values handled?
- Values containing commas, quotes or newlines are automatically quoted and escaped so spreadsheets read them correctly.
- Can I open the result in Excel?
- Yes. CSV opens directly in Excel and Google Sheets, mapping each column automatically.
Last updated: