CSV to JSON Converter Logo
Developer Tools Embed Tool

CSV to JSON Converter

Paste CSV data or drop a CSV or TSV file and turn it into JSON, or turn JSON back into CSV. Pick the delimiter, say whether the first row is a header, and choose typed values or plain strings.

Convert CSV
0
Uses
—
Verified
Open
Access
Nov 2026
Added
Back to Directory
CSV
CSV to JSON Converter

Convert both ways, auto-detect the delimiter, and preview the table before you copy.

Drop a .csv, .tsv, .txt or .json fileor tap to choose (or paste below)
Saved on this device

Stored in your browser only. Nothing is uploaded.

Found a Bug or Missing a Feature?

Report any problems or suggest new features you want. You can write in English, Urdu, Hindi, or any language! Our AI will analyze your feedback and upgrade the tool.

About This Tool

Paste CSV data or drop a CSV or TSV file and turn it into JSON, or turn JSON back into CSV. Pick the delimiter, say whether the first row is a header, and choose typed values or plain strings.


Spreadsheets speak CSV, and most web code speaks JSON. Moving data between them looks simple until a name contains a comma, a column is separated by semicolons, or a zip code loses its leading zero. This converter handles those cases in both directions and shows a table preview, so you can see what you are about to copy.

A short walk through

Pick CSV → JSON or JSON → CSV, then paste your data or drop a .csv, .tsv, .txt or .json file. The result updates as you type. Below the output you get the row count, column count, the delimiter that was used and the output size, plus a preview of the first eight rows.

Settings that matter

  • Header row: turn it on to get objects with named keys, or off to get plain arrays. Empty or duplicate header names are repaired for you, for example the second name becomes name_2.
  • Type conversion: numbers, true, false and null become real JSON types. Values like 007 stay text, because turning them into a number would destroy data.
  • Empty cells: choose between an empty string and null, depending on what your database expects.
  • Indentation: two spaces, four spaces, tabs or minified for an API payload.

Going from JSON back to CSV

Paste an array of objects and every key becomes a column, even when some objects miss keys. Nested objects are flattened with dots, and quotes, line breaks and delimiters inside values are escaped properly. If the CSV is headed for Excel, tick the formula protection box so that a cell starting with an equals sign cannot execute.

Mistakes it catches

An unclosed quote in CSV or a stray bracket in JSON produces a plain error message instead of silent garbage. The Use output as input button lets you round-trip a result to check that nothing changed on the way.

Where it fits

Analysts use it to turn an export into something a script can read. Developers use it to build mock data for an API. Marketers use it to move product lists between a spreadsheet and a store. When your JSON needs cleaning first, validate it with the JSON formatter and validator, and when you need a dedicated reverse path, the JSON to CSV converter is a focused alternative.

Quick answers

How does the tool know which delimiter my file uses?

It counts commas, semicolons, tabs and pipes in the first line, ignoring anything inside quotes, and picks the most common. You can also choose one yourself.

Why did my zip code 01234 stay as text?

Numbers with a leading zero are not real numbers, so the type conversion leaves them as strings and keeps the zero.

What happens to nested JSON when I convert it to CSV?

Nested objects are flattened into dotted column names such as address.city. Arrays are written into the cell as JSON text.

Is my data sent anywhere?

No. Parsing happens in your browser, and files up to 20 MB can be loaded.

What does protect against spreadsheet formulas do?

It adds an apostrophe before cells that begin with =, +, - or @, so Excel will not run them as formulas when you open the CSV.