Skip to content
ToolFarmToolFarm
DataComing soon

CSV to JSON Converter

Convert CSV to JSON and JSON to CSV in your browser. A built-in RFC 4180 parser handles quoted fields, commas inside values, line breaks and escaped quotes, with no upload and no extra library.

3 min read
Expected release: Soon

This tool is growing

This tool is currently being prepared.

While we plant it, browse other tools below.

What this tool does

Paste a CSV and read it back as clean JSON, or paste JSON and get a CSV you can open in any spreadsheet. The converter detects the direction and the delimiter for you, or you can set them by hand for comma, semicolon, tab or pipe files. It follows the RFC 4180 rules, so a value with a comma, a line break or a doubled quote inside quotes is parsed correctly. Values stay as text, so a code like 007 is never turned into a number. Everything runs on your device and nothing is uploaded.

What you can use it for

  • Turn a CSV export from a spreadsheet into JSON for an API or a config file.
  • Flatten a JSON array of records back into a CSV to open in Excel or Sheets.
  • Switch a European semicolon file to JSON without fighting the delimiter.
  • Convert a tab separated dump into JSON while keeping leading zeros intact.
  • Check how a row with quotes and commas is really parsed before you import it.

How to use it

  1. Paste your CSV or JSON into the input box.
  2. Leave the direction on auto, or pick CSV to JSON or JSON to CSV by hand.
  3. Choose the delimiter, or leave it on auto to detect comma, semicolon, tab or pipe.
  4. Set whether the first CSV row is a header and whether the JSON is pretty printed.
  5. Read the result, then copy it or download it as a json or csv file.

Everything runs inside your browser. No file is uploaded to any server. See more tools in this field.

Other tools people reach for in the same flow.

Data

Frequently asked questions

Does it handle commas and line breaks inside a value?

Yes. The parser follows RFC 4180, so a field wrapped in double quotes can contain the delimiter, a line break, or a doubled double quote that stands for one quote. Those values are kept whole instead of splitting the row.

Which delimiters are supported?

Comma, semicolon, tab and pipe. On auto the converter looks at the first row and picks the separator that appears most, which covers the usual comma and the European semicolon files as well as tab separated exports.

Are numbers and leading zeros preserved?

Yes. Every value is kept as text, so an id like 007 or a long phone number is not turned into a number and never loses a leading zero or precision. You decide later how to type the data.

How is JSON turned into CSV?

Give a single object or an array of objects. The columns are the union of all keys in the order they first appear, and any nested object or array is written as a JSON string in its cell so no data is lost.

Is my data sent anywhere?

No. The conversion runs entirely in your browser with no upload and no third party library. Nothing you paste leaves your device.

CSV to JSON Converter · ToolFarm