EN

Convert CSV to JSON

Turn CSV exports from Excel, Google Sheets or online stores into clean JSON. The separator is detected for you and the first row becomes the field names.

Your files never leave your device. Everything runs in your browser.

How it works

  1. Add your CSVPaste it, type it, open a file or drop it onto the input box. Try Sample if you just want to look around.
  2. Check the resultThe result on the right updates as you type. Errors are shown with the line and column.
  3. Copy or downloadCopy the JSON with one click or download it as a file.

Smart CSV reading

Commas, semicolons, tabs and vertical bars are all detected automatically, and quoted values with line breaks are read correctly. Numbers and true or false values become real JSON numbers and booleans.

Codes with leading zeros, such as barcodes and postal codes, and very long numbers stay as text so they are never changed by accident.

About CSV

CSV (comma separated values) stores a table as plain text: one line per row and a separator between columns. It opens in Excel, Google Sheets and almost every database tool, which makes it the easiest way to move data between programs.

About JSON

JSON (JavaScript Object Notation) is a text format for structured data. It uses objects with keys and values, arrays, strings, numbers, true, false and null. Almost every web API and many configuration files use it because both people and programs can read it easily.

Frequently asked questions

What if my CSV has no header row?

Turn off First row is header and each row becomes an array of values instead of an object.

Is my data uploaded anywhere?

No. Everything runs in your browser. Your JSON and CSV data is not sent to our servers.

How big can my JSON be?

Files of several megabytes work well. Very large files depend on your device's memory. Coloring is turned off for very large results to keep the page responsive.

Why does the tool say my JSON is invalid?

Common causes are a missing comma, a trailing comma before a closing bracket, single quotes instead of double quotes, or comments. The error box shows the line and column so you can fix it quickly.

Does it work without an internet connection?

Yes. After you open the page once, it keeps working even if your connection drops.