JSON to CSV Converter
Convert JSON arrays to CSV and back, in-browser.
Paste a JSON array to convert.
How to use
- 1 Paste a JSON array of objects, or a CSV document.
- 2 Choose the direction: JSON → CSV or CSV → JSON.
- 3 The converter unions all keys and escapes fields automatically.
- 4 Copy the output or download it as .csv / .json.
About JSON to CSV Converter
The JSON ⇄ CSV converter turns a JSON array of objects into a spreadsheet-ready CSV file, and parses CSV back into clean JSON.
It builds the header row from the union of every key across your objects, so rows with missing fields still line up correctly, and it quotes any value that contains a comma, quote or newline following the RFC 4180 convention that Excel, Google Sheets and Numbers all understand.
CSV is still the universal language of spreadsheets and data imports, while JSON is the language of APIs and config.
Moving between them by hand is tedious and error-prone — one stray comma inside a value breaks the whole file.
This tool handles the escaping for you and round-trips losslessly for flat data.
Nested objects are serialised as compact JSON inside the cell so nothing is lost.
As with every My Tools Garage tool, conversion happens locally in your browser.
Paste an export from your database, an API response, or a spreadsheet, and convert it without sending a single byte to a server.
FAQ
What JSON shape does it expect?
A top-level array of objects, e.g. [{"a":1},{"a":2}]. Each object becomes a CSV row and its keys become columns.
How are commas and quotes inside values handled?
Any field containing a comma, double quote or newline is wrapped in double quotes, and embedded quotes are doubled — the RFC 4180 standard spreadsheets expect.
What happens to nested objects?
Nested objects and arrays are serialised as JSON text inside the cell, so the data is preserved even though CSV itself is flat.