Turn a list of JSON objects into a CSV table for Excel, Google Sheets or Numbers. Each key becomes a column. Nested objects become dotted columns such as address.city, and a list inside a row is kept as JSON text. For an .xlsx file, use JSON to Excel. The reverse is CSV to JSON.
How to use it
- Paste a JSON array (or an object that holds one), or open a file.
- A CSV preview appears with the number of rows and columns.
- Download the .csv file or copy it.
Read more: How to open a JSON file on Windows, Mac, a phone or in Excel · Convert JSON to CSV: nested objects, arrays and Excel gotchas
Private, and made for big files
This tool runs in your browser, in a background worker: nothing you paste or open is uploaded, and nothing is kept after you leave. JSON and XML input can be up to 1 GB, depending on available memory. Processing runs in a background worker; large analyses can take a minute or more. Already loaded features keep working if your connection drops. Loading another tool or jq for the first time needs a connection. When one tool isn't enough, GigaJSON opens your data with a tree, a table, JSONPath/JMESPath/jq queries, transforms, diff and history.
Turn nested fields into columns
Try [{"id":"001","customer":{"name":"Ada","city":"Pune"},"total":149},{"id":"002","customer":{"name":"Sam","city":"Oslo"},"total":89}]. Each object becomes a row; nested customer fields become columns. Review the header and the two records before downloading.
A quoted JSON ID does not force Excel to treat a CSV cell as text. Import that column as Text to keep 001 intact. Arrays and missing values also need a deliberate export choice. The nested JSON-to-CSV guide explains these cases with examples.


Questions
What JSON can be converted?
A list of objects works best. If you give it an object with one list inside, that list becomes the rows. Anything else becomes a single row.
How are nested objects handled?
They are flattened into dotted column names: {"address": {"city": "Lima"}} gives a column called address.city. Lists inside a row are written as JSON text.
Is my data uploaded?
No. The tool runs in your browser, in a background worker. Nothing you paste or open goes to a server, and nothing is kept after you leave the page.
How large a file can it handle?
JSON, XML and CSV input can be up to 1 GB, depending on memory. YAML input and JSON repair are limited to 128 MB. Conversion runs in a background worker. jq, text editing and text-based exports have separate limits, shown when you use them.
All tools
- JSON FormatterIndent with 2 or 4 spaces, sort keys
- JSON ValidatorLine and column of the first error
- JSON MinifierRemove whitespace, see the bytes saved
- JSON RepairFixes quotes, commas, comments, AI output
- JSON Schema GeneratorA JSON Schema from examples
- JSON Schema ValidatorCheck JSON against a schema
- JSON Token CounterCount tokens, select data, compare JSON and TOON
- JSON EditorTree and code editing, undo and history
- Large JSON ViewerTree, table and search for huge files
- JSON Lines ViewerJSONL and NDJSON logs as a table
- JSON Log ViewerCount and filter JSON Lines logs
- Large CSV ViewerCSV files too big for Excel, up to 1 GB
- JSON VisualizerThe data as a graph, PNG and SVG export
- JSON DiffChanges between two documents
- JSON Path FinderClick a value, copy its path
- JSONPath TesterJSONPath, JMESPath and jq, live
- JMESPath PlaygroundJMESPath, for AWS CLI queries too
- jq PlaygroundReal jq in your browser
- JSON to CSVNested objects become dotted columns
- JSON to ExcelAn .xlsx sheet, numbers kept as numbers
- CSV to JSONDelimiters detected, 007 stays 007
- JSON to XML@keys become attributes
- XML to JSONRSS feeds, sitemaps, SOAP responses
- JSON to YAMLReadable YAML, ambiguous strings quoted
- YAML to JSONAnchors and multiple documents
- JSON Lines to JSONNDJSON or JSONL into one array
- JSON to JSON LinesA JSON array as one record per line
- JSON to TOONConvert JSON to TOON, with token counts
- JSON to MermaidA flowchart or class diagram, drawn
- JSON SplitterCut a big file into parts, or sample it
- JSON to TypeScriptInterfaces inferred from your data
- JSON to GoGo structs with json tags
- JSON to RustRust structs that derive serde's Serialize and Deserialize
- JSON to PythonPython dataclasses with type hints
- JSON to JavaJava classes with getters and setters
- JSON to C#C# classes with System.Text.Json attributes
- JSON to KotlinKotlin data classes
- JSON to SwiftSwift structs that conform to Codable, with CodingKeys
- JSON to DartDart classes with fromJson and toJson
- JSON to ZodZod schemas with TypeScript types inferred from them
- JWT DecoderHeader, payload and expiry, locally
- JSON EscapeText to a JSON string and back
- Sample JSON FilesDownload test JSON, 100 KB to 1 GB
- Sample JSON Lines FilesDownload test NDJSON, one record per line
- Sample CSV FilesDownload test CSV, 100 KB to 1 GB
- Sample XML FilesDownload test XML, 100 KB to 1 GB
- Sample GeoJSON FilesPoints, lines and polygons, up to 1 GB
- Sample Nested JSONRecords 8 levels deep, up to 1 GB
- Sample Unicode JSON13 scripts, emoji and escapes
- Sample API ResponsesJSON:API, HAL, GraphQL, pages, errors
- Large JSON File GeneratorTest data from 100 KB to 1 GB