JSON ↔ CSV Converter
Convert JSON arrays to CSV and CSV back to JSON.
About JSON ↔ CSV Converter
Convert a JSON array of objects into CSV format for spreadsheets, or parse CSV data back into JSON. Handles quoted fields and commas correctly, all in your browser.
What Is This Tool?
Convert a JSON array of objects into CSV format for use in spreadsheets, or parse CSV data back into JSON for use in code. Correctly handles quoted fields, commas, and mismatched keys between rows.
How to Use
- Paste a JSON array (or a single JSON object) into the input box, then click JSON → CSV.
- Or paste CSV data with a header row, then click CSV → JSON.
- Click Copy to copy the converted output to your clipboard.
Common Use Cases
- Exporting API response data into a spreadsheet-friendly format
- Converting a CSV export from a spreadsheet tool into JSON for an application
- Preparing data for import into another system that requires a specific format
Tips & Tricks
- If your JSON objects have different keys, the CSV output includes every key found across all rows as a column.
- Fields containing commas or quotes are automatically wrapped and escaped per standard CSV rules.
Frequently Asked Questions
What happens if some JSON objects are missing certain keys?
The CSV output includes every key found across all objects as a column header. Rows missing a particular key simply get an empty cell in that column.
How does the converter handle commas or quotes inside a field value?
Fields containing commas, quotes, or line breaks are automatically wrapped in double quotes and escaped according to standard CSV rules, so the output opens correctly in Excel or Google Sheets.
Can I convert a single JSON object, not just an array?
Yes. A single object is treated as one row, producing a CSV with a header row and one data row.
Does converting CSV back to JSON require a header row?
Yes. The first row of your CSV is used as the property names for the resulting JSON objects, so make sure your data includes a header row before running CSV → JSON.
Is my data uploaded to a server during conversion?
No. Both JSON → CSV and CSV → JSON conversions run entirely in your browser — your data is never transmitted anywhere.
Convert JSON arrays to CSV and CSV files back to JSON instantly in your browser. Free, fast, and handles quoted fields correctly.