JSON to CSV
Converts JSON objects to a CSV table, checks its columns, and downloads the file.
Processed on this device. The files are not sent to a server.
How to use this tool
- Paste an array of JSON objects and choose the separator.
- Check the first 20 rows and the formula protection option.
- Copy the CSV or download the full file.
What you should know
Up to 200,000 characters, 1,000 rows, 30 columns, 50 levels and 50,000 values; output up to 1 MB. Columns by union of keys, empty for null or missing keys; nested objects and arrays as JSON in a cell. UTF-8 CSV without BOM, with quotes and CRLF breaks. By default, strings/headers that look like formulas with an apostrophe are neutralized; you can change your text. Negative numbers are preserved; Integers outside the JavaScript safe range must be entered as strings. Decimals use floating point precision.
What about nested objects or different keys?
A column is created for each key found. A nested object or array is serialized as JSON within its cell; It doesn't automatically expand into other columns.