JSON to CSV Converter

Flatten JSON arrays into downloadable CSV spreadsheets.

— or —

Nested objects are flattened into dotted columns (address.city), simple arrays are joined with semicolons.

What Does the JSON to CSV Converter Do?

This converter flattens a JSON array of objects into a CSV table you can open in Excel or Google Sheets. Nested objects become dotted columns (address.city), simple arrays are joined with semicolons, booleans become true/false, and objects with different key sets are merged into a unified column set — missing values simply come out empty. Fields containing commas or quotes are escaped per the CSV standard, and downloads include a BOM so Excel opens accented characters correctly.

How to Convert JSON to CSV

  1. Paste your JSON (an array of objects works best) or upload a .json file.
  2. Click Convert to CSV.
  3. Review the output and row count, copy it, or download data.csv ready for Excel.

Typical Conversions

  • API exports to spreadsheets — turn a REST response into something a manager can filter and pivot.
  • Log analysis — JSON event exports become sortable tables.
  • E-commerce data — order or product feeds from platform APIs, reshaped for accounting.
  • Database migrations — NoSQL document dumps prepared for relational imports.

If your JSON is an object wrapping the array — like {"results": [...]} — the converter finds and uses the inner array automatically.

Frequently Asked Questions

How is nested JSON represented in a flat CSV?

With dotted column names: {"user": {"name": "Ann"}} becomes a column user.name. Arrays of plain values are joined with semicolons in a single cell; arrays of objects are flattened with numeric indices.

My objects have different keys — what happens?

The converter builds the union of all keys, in first-seen order, as the header row. Rows missing a key just leave that cell empty — nothing errors out.

Why does the downloaded CSV open correctly in Excel but the copied one doesn't?

The download includes a UTF-8 BOM marker that tells Excel the encoding, so accents and symbols display correctly. If pasting instead, use "Data → From Text" and choose UTF-8.

Can I convert a single JSON object (not an array)?

Yes — a lone object becomes a one-row CSV. Wrappers like {"data": [...]} are also unwrapped automatically to find the main array.