JSON to CSV Converter
Paste a JSON array of objects and convert it to a CSV file — free, instant, browser-based.
JSON Input
How to convert JSON to CSV
- Paste your JSON array into the input box, or upload a .json file.
- Make sure your JSON is an array of objects — each object becomes a row.
- Click Convert to CSV to process the data.
- Copy the result or click Download to save as a .csv file.
When to convert JSON to CSV
JSON is the native format for APIs and JavaScript applications, but many business tools — spreadsheets, CRMs, BI dashboards — expect CSV. Converting JSON to CSV makes your data portable and ready to import into Excel, Google Sheets, or any data pipeline.
How JSON becomes spreadsheet rows and columns
This converter expects a JSON array of objects. The keys of the first object become the CSV header row, and every object in the array becomes a data row in the same column order. Fields that contain commas, quotes, or line breaks are automatically wrapped in double quotes (with inner quotes doubled) so the CSV stays valid. The result opens directly in Excel, Google Sheets, LibreOffice, or Apple Numbers. Want a real spreadsheet file instead of CSV? Use JSON to XLSX.
Nested JSON, arrays, and missing fields
Because headers come from the first object, give your objects a consistent shape for the cleanest output. If a later object is missing a key, that cell is left blank, and keys that appear only in later objects are not added as new columns. Nested objects and arrays are written in their text form rather than expanded into separate columns, so flatten deeply nested data first if you need every value in its own cell. Need to inspect the JSON beforehand? Use the JSON Formatter or JSON Validator.
Privacy — your data stays local
This tool runs entirely in your browser using JavaScript. Your CSV or JSON data is never sent to any server. Everything is processed locally on your device, making it safe for sensitive records, financial exports, or personal data — though you should always follow your organisation's data policies before using any online tool with confidential files.
Frequently Asked Questions
What JSON structure does this tool expect?
It expects a JSON array of objects — each object becomes a row, and the keys of the first object become the CSV column headers. A single bare object or a primitive value is not accepted; wrap a single record in an array first.
What happens to nested objects and arrays?
Nested objects and arrays are written in their text form rather than expanded into separate columns. If you need every value in its own column, flatten the JSON before converting.
Are missing properties left blank?
Yes. Columns come from the first object's keys; if a later object is missing one of those keys, that cell is left empty. Keys that appear only in later objects are not added as new columns.
Can I open the CSV in Excel or Google Sheets?
Yes. The output is standard CSV that imports directly into Microsoft Excel, Google Sheets, LibreOffice Calc, and Apple Numbers.
Can I copy or download the result?
Yes — copy the output to your clipboard, or download it as a file with one click.
Is this tool completely free?
Yes — free with no account and no subscription. There is no fixed row cap; the practical limit is your browser's available memory, so very large files may process more slowly.
Will my data be uploaded anywhere?
No. All processing happens locally in your browser. Nothing is sent to a server.