JSON to CSV
JSON to CSV turns a JSON array of records into rows for a spreadsheet, with nested fields flattened into columns like address.city. It is free and runs in your browser.
Paste JSON to convert.
What is the JSON to CSV?
JSON to CSV is a free converter that turns structured JSON records into a table you can use in Excel, Google Sheets or another data tool. Each object becomes a row, with field names used as column headers and values placed in cells. Developers use it to inspect API responses, while analysts and students use it to prepare exports for reports. Start with a flat array of objects that share the same keys. JSON can contain nested structures that CSV cannot represent directly, so decide how those should become columns or rows before converting. Processing happens in your browser, with no subscriptions.
Who it is for: JSON to CSV is for developers, API users, data analysts, students and researchers preparing spreadsheet data.
How to use the JSON to CSV
- Tap Try with sample data to see the expected JSON structure.
- Replace the sample with your JSON array of flat objects, using the same keys in each record.
- Run the conversion and check the CSV headers and rows against your original records.
- Press Download .csv, or Copy CSV, and open it in your spreadsheet.
Why use it
- Move records into a spreadsheetConvert a JSON array into rows and columns for inspection, filtering or reporting.
- Keep conversion localYour JSON is processed in your browser rather than uploaded for conversion.
- Skip manual cell entryTurn repeated fields into a table instead of copying each value into a spreadsheet.
- Work offlineOnce the tool is available offline, you can convert data without an internet connection.
At a glance
- What you put in
- A JSON array of objects, or an object that contains one
- What you get
- CSV with a header row; comma, semicolon or tab separated; downloadable .csv
- Limits
- Nested objects become dotted columns; arrays inside records stay as JSON text
- Privacy
- Runs in your browser. Nothing you enter is uploaded or stored.
- Price
- Free for everyone. No subscriptions, no payments, no watermark.
- Works offline
- Yes, once the page has loaded
- Last checked
- by AK Shine
Worked example
[{"item":"Notebook","quantity":3,"unit_price":4.5},{"item":"Pen","quantity":10,"unit_price":1.2}]item,quantity,unit_price Notebook,3,4.5 Pen,10,1.2
Two JSON objects become two data rows; numeric values do not retain display-only trailing zeros.
When to use something else
- For deeply nested objects, arrays within records or inconsistent keys, use a script or data preparation tool to define the columns and missing-value rules first.
- For very large files or recurring jobs, use a streaming converter, database or automated script instead of relying on browser memory.
- CSV does not preserve JSON types or structure, and quoting does not prevent spreadsheet formulas from running; inspect untrusted values before opening the result.
Questions people ask
How do I convert a JSON file to CSV for free?
Open the file in a text editor, paste its contents here and press Download .csv. The download includes a byte order mark so Excel reads accents and non-English letters correctly.
Can I convert a JSON array of objects to CSV?
Yes, a flat array of objects is the clearest input: each object represents one row. Use consistent field names across records so the intended columns are clear.
How do I convert nested JSON or choose an array inside an API response?
Nested objects are flattened into columns such as address.city, and if your JSON is an object holding an array, the first array is used. Arrays inside a record stay as JSON text in one cell.
Can I convert JSON Lines or NDJSON to CSV?
JSON Lines contains separate JSON values on separate lines, not one JSON array. Prepare it as an array with commas between records, or use a dedicated JSON Lines converter for large files.
Is my JSON uploaded to a server?
No, conversion runs in your browser, and your input is not uploaded for processing. On a shared device, still take care with clipboard contents and any CSV files you save.
Why are some fields missing from my CSV?
Check whether the records use different keys or whether the fields sit inside nested objects. Normalize the records to one shared set of flat keys before converting, and compare the result with the source.
Why does Excel remove leading zeros or change long IDs?
Excel can interpret CSV cells as numbers or dates, removing leading zeros or changing long identifiers. Import those columns as text instead of opening the file directly; CSV quoting alone does not preserve their type.
Why does my CSV open in one column or show broken characters?
Use your spreadsheet's import option and select comma as the delimiter and UTF-8 as the text encoding. Regional defaults may expect a different separator, so opening the file directly can give the wrong result.