JSON to CSV Converter
Related external tools
Some links are affiliate links.
Related tools
Convert a JSON array of objects into CSV for Excel or Google Sheets, and turn CSV back into JSON for your apps. Values with commas, quotes or line breaks are escaped correctly, and you can pick the delimiter. Everything runs in your browser — your data is never uploaded.
How to use
- Choose a direction: JSON → CSV or CSV → JSON.
- Pick the delimiter — comma, tab or semicolon.
- Paste your data, then copy or download the converted result.
How it works
An array of JSON objects maps neatly onto a table: each object is a row and each key is a column. The converter gathers the union of all keys for the header, then writes each row, wrapping any value that contains the delimiter, a quote or a line break in quotes. Going the other way, the first CSV row becomes the keys and each following row becomes an object.
Features
Two-way conversion
Turn JSON into CSV or CSV into JSON with a single toggle.
Smart headers
Columns are built from the union of all object keys, so missing fields become empty cells.
Correct quoting
Values containing commas, quotes or newlines are escaped per the CSV standard.
Choose the delimiter
Output comma, tab or semicolon separated values to match your target program.
Type inference
When reading CSV, numbers, true/false and null are converted to real JSON types.
When to use it
Open data in Excel
Turn a JSON API response into a CSV you can open directly in a spreadsheet.
Import a spreadsheet
Convert an exported CSV into JSON to load it into your app or script.
Move data around
Switch between formats when migrating records between different systems.
Quick reports
Flatten structured data into a table for a quick, shareable report.
Notes
- Nested objects and arrays are written as JSON text inside a single cell.
- The first CSV row is treated as the header when converting to JSON.
- Numbers, booleans and null are inferred from CSV text automatically.
- All processing runs on your device; your data is never uploaded.
FAQ
- Can it convert CSV back to JSON?
- Yes. Switch the toggle to CSV → JSON and paste your CSV; the first row becomes the object keys.
- How are nested objects handled?
- Nested objects or arrays are serialized as JSON text within a single CSV cell, so no data is lost.
- Can I use tabs as the delimiter?
- Yes. Choose Tab (for TSV) or Semicolon from the delimiter menu, in addition to the default comma.
- Will the CSV open in Excel?
- Yes. The output is standard CSV with proper quoting, so it opens in Excel, Google Sheets and similar tools.
- Is my data sent to a server?
- No. The conversion happens entirely in your browser and nothing is uploaded.