JSON to CSV Converter

How to convert JSON to CSV

1. Paste JSON into the editor, usually an array of objects such as an API response.
2. Click Convert to CSV to see the result, then Export CSV to download it as a .csv file.
3. Open the file in Excel, Google Sheets, LibreOffice or any BI tool.

How the conversion works

• Rows: each object in the top-level array becomes one row. A single object becomes a single row.
• Columns: every field found in any object gets a column, in the order fields first appear. Objects that lack a field get an empty cell.
• Nested objects are flattened with dots: {"address": {"city": "Pune"}} becomes the column address.city.
• Arrays become numbered columns: tags[0], tags[1] and so on.
• Values containing commas, quotes or line breaks are quoted as the CSV standard requires, so spreadsheets read them correctly.

For example:

[
  {"id": 1, "name": "Ada", "address": {"city": "London"}},
  {"id": 2, "name": "Linus", "email": "linus@example.com"}
]

becomes:

id,name,address.city,email
1,Ada,London,
2,Linus,,linus@example.com

Tips

• If your data is wrapped, for example {"data": [...]}, paste only the array for one row per item.
• Excel may show long numbers such as phone numbers or IDs in scientific notation; format those columns as Text after importing.
• Going the other way? The CSV converter turns CSV into JSON, XML or SQL.

Conversion runs on our server in memory; the data isn't stored.

Frequently asked questions

Other tools

• JSON & XML FormatterFormat, validate and convert JSON or XML in one place.
• JSON FormatterBeautify, validate, minify and repair JSON.
• XML FormatterPretty-print XML and check that it is well-formed.
• CSV ConverterTurn CSV into JSON, XML or SQL INSERT statements.
• YAML ValidatorValidate YAML, convert YAML to JSON and back, and properties files.
• TOML ConverterConvert JSON or XML to TOML config files.
• Object MapperTurn JSON into Java, TypeScript, Go, Kotlin, Rust or Pydantic types.
• JSON & XML CompareSee what changed between two versions, by path.
• JSON SchemaGenerate a schema from a sample, or validate against one.
• JWT DecoderRead claims, check expiry and verify signatures.
• Encode / DecodeBase64, URL, JSON strings, hex and timestamps.
• SQL FormatterBeautify or minify SQL for every major database.
• Regex TesterTest regular expressions with live matches and explanations.
• UUID GeneratorUUID v4, v7, ULID and Nano ID in bulk.
• JSON ValidatorCheck JSON syntax and see the exact line of every error.
• JSON ViewerExplore JSON as a collapsible tree with search and JSONPath.
• JSON MinifierStrip whitespace from JSON for smaller payloads.
• JSON to XMLConvert JSON into well-formed XML.
• XML to JSONConvert XML, attributes and all, into JSON.
• All toolsEvery formatter, converter and generator on the site.