1. Home
  2. Spreadsheets & Data
  3. JSON to CSV Converter

JSON to CSV Converter

Convert JSON arrays to CSV and CSV back to JSON, flattening nested fields.

Runs in your browser · No upload

Loading the converter…

Your data is converted in this browser and never uploaded.

How to use

  1. Choose JSON → CSV or CSV → JSON.
  2. Paste your data; the result appears instantly. JSON is usually an array of objects like [{...}, {...}], but a single object or a wrapper such as {"items": [...]} works too.
  3. Pick the delimiter (comma, semicolon, tab or pipe) and whether there’s a header row. When reading CSV, the delimiter is detected automatically.
  4. Copy or download the result. Use result as input flips the direction so you can convert it straight back.

Conversion rules

Case JSON → CSV CSV → JSON
Nested object {"customer": {"name": "Jane"}} Column customer.name Turn on “Nest dotted keys” to rebuild the object
Array {"items": ["T-shirt", "Cap"]} Columns items.0, items.1 (or one JSON cell) items.0, items.1 become an array again
Objects with different keys Every key becomes a column in first-seen order; missing cells are empty -
Values with commas, quotes, line breaks Wrapped in double quotes, " doubled to "" (RFC 4180) Read with the same rules
Values that look numeric Written as-is 31 → number; 02134 (leading zero), phone numbers and integers past 2^53 stay strings

Opening CSV in Excel

Excel for Windows only recognizes a CSV as UTF-8 when it starts with a byte order mark (bytes EF BB BF); otherwise it uses the system’s legacy code page, and accented or non-Latin characters turn into mojibake like José. “Add UTF-8 BOM for Excel” is on by default, so the downloaded file opens correctly with a double-click. The BOM goes into the file only, not into copied text. Semicolon-separated files are common in European locales where the comma is the decimal separator.

Things to watch out for

  • CSV formula injection: cells beginning with =, + or @ can run as formulas in Excel. If the data comes from outside sources, turn on “Block Excel formulas” | such values get a leading ' so they display as text. Plain negative numbers like -3 are left alone.
  • CSV has no data types. After JSON → CSV → JSON, numbers and true/false come back when “Convert numbers” is on, but null and empty strings both become empty cells and return as empty strings.
  • If your JSON won’t parse, the JSON Formatter shows the exact line and column of the error.

FAQ

Can I get an .xlsx file?

A CSV opens directly in Excel; use “Save As” there to get .xlsx. Going the other way, copy a range in Excel and paste it here | it’s read as tab-separated CSV.

Is my data uploaded?

No. Conversion runs in your browser with the papaparse library, so customer lists and other sensitive data never leave your machine.

Can't find the tool you need?

Tell us what you want to do. We build the most requested tools first.