JSON LAB / BROWSER TOOLS
JSON to CSV Converter
Turn nested JSON into a useful spreadsheet. Choose your records, preview the columns, and export a CSV on your device.
0 / 1,000,000 UTF-8 bytes. Maximum 20,000 rows, 200 columns, and 8 MB of CSV output. Over-limit tasks are rejected; exports are never shortened.
Leave empty for the root. A single object becomes one row; an array must contain only objects. Paths use object keys, without array indexes or wildcards.
Nested objects become dot-path columns. Null and missing fields are blank. CSV has no data types: import IDs such as 00123 as Text in your spreadsheet to keep leading zeros.
What you can do
- Select records at a path such as data.items.
- Flatten objects into columns and choose how arrays are represented.
- Preview 20 rows; export every supported row with your selected columns.
- Choose a delimiter, Excel-friendly UTF-8 BOM and formula protection.
Questions, answered
Can I convert an API response?
Yes. Enter the path to its records, such as data.items. An array of objects becomes rows; a root object becomes a single row.
How are nested fields handled?
Objects become dotted columns. Arrays remain JSON text unless you choose to join primitive values. Ambiguous column names are rejected instead of overwritten.
Why is a leading apostrophe added to a cell?
Formula protection is enabled by default. It prefixes potentially executable spreadsheet cells with an apostrophe. Disable it only when you intentionally want the original text.
Does CSV preserve JSON types?
CSV contains text, not JSON types. Spreadsheet apps may also reinterpret long IDs, leading zeros and dates. Import those columns as text when exact values matter.
What are the limits?
Up to 1 MB of JSON, 100 nesting levels, 20,000 rows, 200 columns and 8 MB of CSV output. The tool blocks exports beyond its limits instead of exporting only part of your data.