Skip to content

JSON ↔ CSV Converter

⇄Developer
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.

🔒Private by design
Your files never leave your device
⚡Instant
No uploads, no queues, no waiting
🎁Free, no sign-up
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

  1. Pick a direction. Keep “JSON → CSV” to turn JSON into a table, or choose “CSV → JSON” to turn a table back into JSON.
  2. 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.
  3. 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.
  4. Copy the result. Click “📋 Copy”, then paste the output into your spreadsheet, editor or import tool.
  5. 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

Top Tools

Tool Categories

More from VeloSpark

© 2026 VeloSpark Digital · Privacy Policy · Terms of Service · Disclaimer · About · Contact · Editorial Policy · Privacy settings

🍪 We value your privacy. We use cookies and browser storage to run this site, remember your favorites and understand which tools help people most. If ads are enabled on this site later, cookies may also be used to show them. The tools themselves work either way — your files never leave your device. You can change your choice at any time from the Privacy settings link in the footer. Read our Privacy Policy.