Data Conversion
CSV to JSON
Convert CSV table data into JSON arrays and objects.
Data Conversion
JSON to CSV
Export JSON arrays into CSV format for spreadsheets and BI tools.
Tool Panel
Processed locallyAbout JSON to CSV
Turns an array of objects into CSV using the keys as the header row, with configurable delimiter and header toggle.
- 1
The input must be a JSON array: an array of objects produces a header row from the union of their keys (in first-seen order), with empty cells where an object lacks a key; an array of arrays is written out as-is with no header row.
- 2
Fields that need it are quoted automatically: a value containing the delimiter, a quote or a newline is wrapped in `"` with inner quotes doubled — the rule Excel, Numbers and Google Sheets all read.
- 3
The delimiter can be `;` (the default in some European Excel locales) or a tab, and the header row can be turned off.
- 1
Paste a JSON array
The sample is an array of objects; objects with different keys are fine, the header is the union.
- 2
Pick the options for your target
Match the delimiter to the importing application, and decide whether you want a header row.
- 3
Copy the result
Paste it into a spreadsheet — values containing the delimiter already carry their quotes, so nothing shifts columns.
Because nothing is flattened here: turning `{"a":{"x":1}}` into a column means guessing a column name for you (`a.x`? `a_x`?), and a wrong guess is harder to notice than an obvious failure. Flatten the data yourself first, or use JSON → YAML, which keeps the hierarchy. Array values are joined with commas — and since that contains the delimiter, they arrive quoted.
By the order keys first appear across all objects. To pin it down, give every object the same keys in the order you want to see.
Related tools
View allData Conversion
CSV to YAML
Transform CSV rows into YAML for configuration and data exchange.
Data Conversion
Data Conversion
CSV to TSV
Convert comma-separated CSV into tab-separated TSV format.
Data Conversion
Data Conversion
JSON to YAML
Convert JSON documents to YAML with clean, readable output.
Data Conversion
Data Conversion
JSON to XML
Transform JSON structures into XML format for system integration.
Data Conversion
Data Conversion
JSON to TSV
Convert JSON arrays into TSV for tab-based data workflows.
Data Conversion
Data Conversion
JSON to Markdown Table
Generate Markdown tables directly from JSON array data.
Data Conversion
Data Conversion
XML to JSON
Parse XML and convert it into structured JSON output.
Data Conversion