Premium tools, free for everyone. Most run right in your browser.

OpenMultiURL

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.

  • Free, no subscriptions
  • Runs in your browser
  • Checked by AK Shine
See how it works before you use your own.

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

  1. Tap Try with sample data to see the expected JSON structure.
  2. Replace the sample with your JSON array of flat objects, using the same keys in each record.
  3. Run the conversion and check the CSV headers and rows against your original records.
  4. 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

Input
[{"item":"Notebook","quantity":3,"unit_price":4.5},{"item":"Pen","quantity":10,"unit_price":1.2}]
Result
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.

Next, you might need