JSON tools
Paste an object or object array. The preview updates automatically as you adjust fields and output options.
Processed in this browser. Your input is not uploaded or stored.
Convert to preview rows.
Fields are discovered on conversion. Paths use JSON Pointer. Changing input or structure resets selection; other options keep it.
Changes detected. Updating the result…
An API response often contains fields that appear only in the last record. JSON to CSV should collect those fields before you select the columns; copying the first object’s keys is not enough.
This JSON to CSV converter scans all records and retains numeric spelling. Compare the table with the original document before handing an export to a spreadsheet user.
For nested JSON to CSV, /user/name identifies a nested value while /user.name identifies a literal dotted key. JSON Pointer also escapes slash and tilde, so flattening does not silently merge those columns.
The JSON to CSV tool keeps arrays as compact JSON in a single cell by default. Indexed mode gives each position its own column. Both modes preserve the number of parent records; neither multiplies rows.
The first conversion builds a union of fields from every record. Uncheck columns and use the arrows to order them. Changing the JSON or its flattening strategy resets that selection so old paths cannot silently filter new data.
Auto-convert is on by default. After you stop editing for 400 ms, input, options and column changes refresh the result. Turn it off to use Convert or Ctrl/Cmd + Enter. Copy and download stay disabled until the result is current.
Table preview starts with 50 rows and can reveal another 50 at a time. Copy and download include all rows, not just those visible. BOM is added only to the downloaded file; the clipboard contains plain CSV text.
Columns follow first appearance across the whole input. A missing field and an explicit null become empty cells; false and zero remain visible values. A single root object is treated as one record.
A delimiter, double quote or line break triggers double-quoted output, and internal quotes are doubled. Empty cells are quoted as well. Force quotes when a downstream importer expects every cell enclosed.
Choose comma, semicolon, tab or pipe. Records use CRLF line endings. Tab selects a .tsv download; other separators produce .csv. Optional UTF-8 BOM helps spreadsheet programs recognize the encoding.
The parser keeps large integers, exponent notation and decimal spelling without converting them through JavaScript numbers. Strings such as 007 also stay intact in the export, although a spreadsheet may reinterpret them on import.
Enable object flattening. Each leaf receives a JSON Pointer header such as /address/city. Disable it to keep that object as compact JSON text. Empty containers remain visible as {} or [].
Yes. Choose indexed columns for paths such as /tags/0 and /tags/1. JSON to CSV does not duplicate parent rows. Leave the default mode selected to retain each array in one cell instead.
The converter discovers the union of keys across every record in first-seen order. Later fields appear in the column list; earlier records receive empty cells for fields they do not contain.
Missing values and explicit null become empty cells, as do empty strings. Zero and false are preserved. This is why CSV cannot fully recover the original JSON types.
The exported digits are preserved, but Excel may infer a number, drop leading zeros or round long IDs. Import those columns as text instead of opening the CSV with automatic type detection.
Found an edge case this converter gets wrong?
Use JSON to CSV to prepare the fields your recipient actually needs. Run the example, inspect the array policy and column order, then export the complete result.