JSON to CSV

Convert a JSON array of objects into a CSV file that opens in Excel or Google Sheets. Nested fields are flattened.

  • Free, no sign-up
  • Files stay on your device
  • Works on mobile
Loading tool…

JSON to CSV flattens an array of JSON objects into rows and columns that open in Excel, Google Sheets or Numbers. Each object becomes a row, each key becomes a column, and nested fields are flattened into dotted names like address.city, so you can sort and filter data that was locked inside an API response.

Analysts turn API exports into spreadsheets, store owners open order data from a platform's JSON export, and developers share data with colleagues who don't read JSON. If some objects have keys others lack, the tool includes every key as a column and leaves blanks where a value is missing.

How to use JSON to CSV

  1. Paste a JSON array or choose or drop a .json file into the main area.
  2. In the settings panel on the right, choose the delimiter (comma, semicolon or tab) and how nested fields are flattened.
  3. Press Convert to CSV.
  4. Download the .csv file or copy the result.

Features

  • Runs in your browser; exported data stays on your device.
  • Nested objects are flattened into dot-separated column names.
  • Every key found in any object becomes a column, with blanks for missing values.
  • Values containing commas, quotes or line breaks are quoted correctly.
  • Arrays inside objects are written as text in a single cell rather than expanded into extra rows.

When to use it

  • Opening a JSON export of online store orders in Excel to total sales by month.
  • Sharing API results with a manager who works only in Google Sheets.
  • Converting a list of form submissions saved as JSON into a CSV for a mailing tool.

Frequently asked questions

What JSON shape does it expect?

An array of objects, such as [{"id":1,"name":"A"}, ...]. A single object is treated as one row.

How are nested fields handled?

They are flattened, so {"user":{"email":"a@b.com"}} becomes a column named user.email.

Why do accented characters look wrong in Excel?

Some Excel versions assume a non-UTF-8 encoding when opening CSV. Use Data > From Text/CSV and choose UTF-8, or convert with CSV to Excel.

Can I convert the CSV back to JSON?

Yes, with CSV to JSON, though flattened column names will stay as dotted keys rather than nested objects.

Does it work with very large JSON files?

Yes, within your browser's memory. Files of a few megabytes convert quickly; files of hundreds of megabytes may be slow.