JSON ↔ CSV Converter
Free · No sign-up · Your files never leave your browser
Free, no sign-up, your converted table in seconds — paste, convert, copy.
JSON is how apps and APIs store records. CSV is how spreadsheets and people read them. This converter moves between the two in both directions: turn a JSON array of objects into a comma-separated table for a spreadsheet, or turn CSV text back into a pretty-printed JSON array. Paste, pick a direction, convert, copy — nothing is uploaded and there is nothing to install.
JSON ↔ CSV Converter
Convert arrays of objects to CSV/spreadsheet format and back.
Free, no sign-up, your converted table in seconds — paste, convert, copy.
Conversion runs in your browser on your own device. Your JSON and CSV text is never uploaded.
Flat data converts cleanly both ways. Nested objects are not flattened: a nested object becomes the text [object Object] in its cell, so flatten nested data before converting if you need its inner fields as columns.
JSON is how apps and APIs store records. CSV is how spreadsheets and people read them. This converter moves between the two in both directions: turn a JSON array of objects into a comma-separated table for a spreadsheet, or turn CSV text back into a pretty-printed JSON array. Paste, pick a direction, convert, copy — nothing is uploaded and there is nothing to install.
Your files never leave your device
No uploads, no queues, no waiting
No account, no card, nothing to install
What people use this converter for
Developers paste an API response here to check its records in Excel or Google Sheets. Shop owners turn exports into a spreadsheet they can sort and share. Analysts and students go the other way, turning a small table into JSON for code or a test fixture. It suits quick one-off jobs: tidying a list, checking a feed, or reshaping data before an import.
How to use the JSON ↔ CSV Converter
- Pick a direction. Keep “JSON → CSV” to turn JSON into a table, or choose “CSV → JSON” to turn a table back into JSON.
- Paste your data. For JSON, paste a complete array starting with `[` and ending with `]`. For CSV, paste the header row first, then one record per line.
- Click Convert. A green “✓ Converted.” message confirms success. A red error message explains the exact problem, such as invalid JSON or a CSV with no data row.
- Copy the result. Click “📋 Copy”, then paste the output into your spreadsheet, editor or import tool.
- Check one row by eye. Compare the first output record with your first pasted record — it catches a wrong direction or a cut-short paste.
A worked example
Paste this JSON, the same sample shown in the input box:
`[{"name":"Ali","city":"Lahore"},{"name":"Sara","city":"Karachi"}]`
Two objects become a header row plus two data rows — three lines, with no trailing empty line:
```
name,city
Ali,Lahore
Sara,Karachi
```
Run that CSV back through “CSV → JSON” and you get the same two records as a JSON array, printed with a two-space indent.
How JSON → CSV decides the columns and escaping
The header is the union of every key in every object, in the order keys are first seen. If a later record adds a new key, that column is added at the end, and earlier rows simply leave that cell empty. A missing key and a JSON `null` both become an empty cell. Numbers and booleans are written as their plain text, so `42` stays `42` and `true` stays `true`.
The delimiter is always a comma — there is no delimiter option. A cell is wrapped in double quotes only when its text contains a comma, a double quote, or a line-break (line feed) character. A double quote inside a quoted cell is doubled, so `say "hi"` becomes `"say ""hi"""`. Rows are joined with line breaks, with no extra blank line at the end.
How CSV → JSON reads your table
The first line becomes the keys; every following line becomes one object. Quoted cells are read properly: a comma inside quotes stays inside the value, and a doubled quote becomes one real quote. Every value comes back as a string — `1` returns as `"1"` and `true` returns as `"true"` — because CSV itself carries no type information. Short rows get empty strings for missing keys, extra cells are ignored, and Windows-style line endings (CRLF) are accepted.
Honest limits: nested data and multi-line cells
This tool does not flatten nested objects. An object value becomes `[object Object]` in its cell, so `{"address":{"city":"Lahore"}}` loses its inner city as a column. A nested array becomes its joined text, so `[1,2]` becomes the quoted cell `"1,2"`. Flatten nested data first if you need its inner fields as columns.
The two directions are also not perfectly symmetrical for line breaks. JSON → CSV can quote a cell that contains a line break, but CSV → JSON splits the pasted text into lines *before* it parses quotes, so a quoted cell spanning several lines will be read as separate rows. Keep each CSV record on one line when converting back. This is a paste-and-copy tool only: no file upload, no download button, no delimiter choice and no type guessing.
Frequently asked questions
Is this JSON ↔ CSV converter really free?
Yes. Both directions are free, with no account or sign-up. Paste your data, click Convert, and copy the result — that is the whole process.
What JSON shape does the JSON → CSV direction need?
It needs a non-empty array of objects, such as two records inside square brackets. A single object on its own, an empty array, or plain text will be rejected with the message “JSON must be a non-empty array of objects.”
Does this converter flatten nested objects?
No. An object value appears in its cell as the text [object Object], and a nested array appears as its joined text. Flatten your data first if you need the inner fields as separate columns.
Will numbers and booleans stay numbers in CSV → JSON?
No. Every CSV value returns as a string, so 1 becomes "1" and true becomes "true". CSV carries no type information, and this tool does not guess types. Convert the strings to numbers or booleans afterwards if your code needs real types.
How are commas, quotes and line breaks handled?
In JSON → CSV, a cell containing a comma, a double quote or a line break is wrapped in double quotes, and any inner double quote is doubled. In CSV → JSON, quoted cells are parsed back correctly, but a quoted cell that spans several lines is not supported.
Is my JSON or CSV data uploaded anywhere?
No. Conversion runs in your browser on your own device, and the tool loads no external library. Your data is never sent to a server, so it is safe for private lists and API responses.
Related tools
- Converter & Utility Tools — the full converter and utility toolbox on one page, including this JSON ↔ CSV Converter.
- Free Tools — every free VeloSpark Digital tool in one place.
Built by Umar Hayat — VeloSpark Digital
More Converter & Utility Tools
- QR Code Generator — free QR code generator: turn any link or text into a scannable QR code in seconds.
- Converter & Utility Tools — the full converter & utility toolbox on one page.
- Free Tools — every free VeloSpark tool, guide and category in one place.
