Convert JSON to CSV for Excel and Google Sheets
Each object in a JSON array becomes a row, and every key becomes a column. Nested objects are flattened into columns like address.city. When the array is inside a larger document, a JSONPath query such as $.users (already filled in above) selects it.
How to use it
- Paste JSON into the Input panel or open a file.
- If the array is nested, type its path in the search box, for example
$.data.items. - Download the
.csvfile and open it in Excel, Numbers or Google Sheets.
How the CSV is built
- Columns are the union of all keys, in the order they first appear.
- Nested objects are flattened with dot notation; nested arrays are written as JSON text.
- Values containing commas, quotes or line breaks are quoted per RFC 4180.
nulland missing values become empty cells.
More JSON tools
All tools are free and run privately in your browser.
JSON FormatterBeautify, validate & convert
JSON ValidatorFind errors by line and column
JSON ViewerCollapsible tree with search
JSON MinifierCompress JSON, see bytes saved
JSON RepairFix broken JSON automatically
JSONPath TesterQuery and filter JSON
JSON EscapeStringify and unescape JSON
JSON to YAMLReadable YAML for configs
JSON to CSVArrays to spreadsheet rows
JSON to XMLWell-formed XML output
CSV to JSONSpreadsheets to JSON arrays
JSON Schema GeneratorInfer a draft 2020-12 schema
JSON to TypeScriptInterfaces with optional fields
JSON to GoStructs with json tags
JSON to JavaRecords with Jackson annotations
JSON to KotlinData classes for kotlinx.serialization
JSON to SwiftCodable structs with CodingKeys
JSON to DartFlutter models with fromJson
JSON to C#Classes for System.Text.Json
JSON to C++Structs for nlohmann/json
JSON to CTyped structs for C
JSON to PHPReadonly DTO classes
JSON to PythonDataclasses with type hints
JSON to CSV FAQ
How do I convert nested JSON to CSV?
Nested objects are flattened automatically into dot-separated columns such as address.city. Use a JSONPath query to choose which array becomes the rows.
Can I open the CSV in Excel?
Yes. Download the file and open it in Excel, Numbers, LibreOffice or Google Sheets. It uses commas and CRLF line endings.
Is my data uploaded to a server?
No. The JSON to CSV runs entirely in your browser using JavaScript. Your data is never uploaded, logged or stored, and the tool keeps working offline after your first visit.