JSON to CSV Converter - Convert JSON Arrays to CSV Online
Input must be a JSON array of objects, e.g. [{"name": "Alice", "age": 30}]
Convert JSON to CSV
Paste a JSON array of objects and get CSV with one row per object and
one column per key. Copy it, or download it as a .csv file
for Excel, Google Sheets or a database import. The conversion runs in
your browser, so exports with personal or financial data are not
uploaded.
Example
[
{ "id": 1, "user": { "name": "Ann", "tags": ["a", "b"] }, "note": "say \"hi\", ok" },
{ "id": 2, "extra": null }
] converts to:
id,user.name,user.tags,note,extra
1,Ann,"[""a"",""b""]","say ""hi"", ok",
2,,,,
The nested user object became two dotted columns, the
array was written as JSON text, the note with a comma and quotes was
quoted, and the second row has empty cells for every key it lacks.
Options
- Delimiter: comma, semicolon, tab or pipe. Use semicolons for Excel in locales that write decimals with a comma, such as most of Europe, or Excel will put everything in one column.
- Nested objects: flatten to dotted columns, or keep each nested object as JSON text in one cell.
Large integers such as 12345678901234567890 are written
exactly as in the input. Excel will still show them in scientific
notation and drop digits after the 15th when it opens the file, so
import ID columns as text there. To go the other way, use the
CSV to JSON converter.
Related Tools
JSON to YAML Converter
Convert JSON data to clean, readable YAML format instantly.
JSON to XML Converter
Transform JSON objects and arrays into well-formed XML documents.
YAML to JSON Converter
Convert YAML configuration files to JSON format instantly.
XML to JSON Converter
Parse XML documents and convert them to JSON objects.