Free tool

JSON to CSV and Excel Converter

Paste a JSON array of objects; preview and download it as CSV, or get an Excel (.xlsx) file directly. Nested objects become columns such as customer.city.

Your data never leaves your computer: everything runs in your browser.

How to use it

  1. Paste JSON or choose a .json file. It can be an array of objects, a single object or a list of values.
  2. Pick the CSV delimiter. Use semicolon (;) if the file will be opened in Excel with a European locale, where the comma is the decimal mark.
  3. Press Convert to CSV to preview, copy or download it. Download Excel gives you an .xlsx file directly.
  4. Nested objects are flattened into a.b columns and arrays stay as JSON text in one cell. The columns are the union of the fields across all rows.

Example

Two orders with a nested customer field, comma-separated:

Input

[
  {
    "id": 1042,
    "customer": {
      "name": "Jane Doe",
      "city": "Boston"
    },
    "total": 249.9,
    "paid": true
  },
  {
    "id": 1043,
    "customer": {
      "name": "John Smith",
      "city": "Austin"
    },
    "total": 89.5,
    "paid": false,
    "note": "Express shipping"
  }
]

Output

id,customer.name,customer.city,total,paid,note
1042,Jane Doe,Boston,249.9,true,
1043,John Smith,Austin,89.5,false,Express shipping

Need more?

Run ForLab Formatter on Apify to do the same conversions every day, automated and validated.

  • Call it from the API or on a schedule: files convert inside your workflow, not by hand.
  • In: CSV/TSV, Excel, JSON, NDJSON, XML, YAML and HTML tables; merge up to 10 files or Apify datasets.
  • Clean in the same run: dedupe, filter, sort, flatten nested JSON, select and rename columns, repair broken JSON; Turkish encodings and ; delimiters are detected.
  • Out: JSON, CSV, Excel, SQL INSERT, Markdown, HTML and JSON Schema; every row is validated against one example object.
  • Pay only for valid rows: $0.0001 each (1,000 rows ≈ $0.10), plus $0.001 per run.

Frequently asked questions

How is nested JSON flattened?

Each nested object is joined to its parent's name: {"customer": {"city": "Boston"}} becomes a customer.city column. Arrays stay in one cell as JSON text, so no data is lost.

Will special characters break when I open the CSV in Excel?

No. The downloaded CSV starts with a byte order mark so Excel reads it as UTF-8. In locales where Excel expects semicolons, pick the semicolon delimiter or download the .xlsx file instead.

What if rows have different fields?

The columns are the union of the fields across all rows, in the order they first appear. A field missing from a row leaves its cell empty.

Are numbers stored as numbers in the Excel file?

Yes. In the .xlsx file numbers are written as numbers and true/false as booleans, ready for formulas. Text stays text.

Is my data sent to a server?

No. The CSV and Excel files are built in your browser and download straight to your computer.

Other free tools