CSV to JSON

Convert CSV to JSON online for free — the header row becomes object keys, numbers and true/false become real JSON types, and the separator (comma, semicolon or tab) is detected automatically. Paste CSV or drop a file, preview it, then copy or download pretty-printed JSON.

100% private — everything runs in your browser. Conversion happens on your device; nothing is uploaded.

100% private — runs in your browser
…or paste CSV text

Converted in your browser with SheetJS — your data never leaves your device. Excel formulas are exported as their calculated values; formatting such as colours and merged cells isn’t carried into CSV or JSON.

How to convert CSV to JSON

  1. Drop a CSV file or paste CSV text.
  2. Check the preview and options.
  3. Copy or download the JSON.
  4. Use it in your app, API or config.

What you can use it for

  • Turn spreadsheet exports into API-ready JSON
  • Create fixtures and mock data for development
  • Convert data for charts and visualisation libraries
  • Prepare content for static site generators

More free tools

Building for the web?

Format, minify, convert and generate code with our free, private developer tools.

See all free tools →

Frequently asked questions

How do I convert CSV to JSON?

Drop the CSV in (or paste it) and the JSON appears instantly. Click Download or Copy.

Can I get an array of arrays instead of objects?

Yes — untick “First row is headers”.

Need the reverse?

Use our JSON to CSV converter.

Is my data uploaded?

No. The conversion runs in your browser with the open-source SheetJS library, so spreadsheets with customer or financial data stay on your device.

Does it work with semicolon or tab-separated files?

Yes. The tool reads the first line of your CSV, counts the commas, semicolons and tabs in it, and uses whichever appears most as the separator. So a header row like name;city;country is read as semicolon-separated, and a tab-separated file works the same way. You can drop .csv, .tsv or .txt files, or paste the text. If none of the three appear in the first line, commas are used.

How are numbers, true/false and empty cells written in the JSON?

With “Keep numbers and true/false as types” ticked, which is the default, cells that read as numbers become JSON numbers, so 36 is written as 36, and true or false in any capitalisation becomes a JSON boolean. Empty cells become null, so every object keeps the same keys. Untick the option to get every value as a text string instead; empty cells still come out as null.

How do I keep leading zeros, ZIP codes or long ID numbers?

Untick “Keep numbers and true/false as types”. While it's ticked, number-like cells are converted, so 00123 becomes 123, a 20-digit ID loses its last digits, $5 becomes 5 and, in a semicolon-separated file, 1,5 becomes 15. With it unticked, every cell is copied as the exact text in your CSV, such as "00123" and "1,5", and the result updates straight away.

How are dates converted?

With types on, cells read as dates are written as text in YYYY-MM-DD form, with HH:MM:SS added only when there's a time, so 2024-01-15 13:45 becomes "2024-01-15 13:45:00". Dates use your local time, so the day doesn't shift. Slash dates are read month first, so 1/15/2024 becomes 2024-01-15, while 15/01/2024 stays as text. Untick types to keep dates exactly as typed.

What if a cell contains commas, quotes or line breaks?

Wrap that cell in double quotes and it's read as one value. A comma inside "Hello, world" stays part of the text, a line break inside the quotes is kept as \n in the JSON string, and a doubled quote ("") becomes a single quote character. Without the surrounding quotes, each comma starts a new column, so values can shift into the wrong keys.

What happens with duplicate or blank column headers?

Each header becomes a key, and keys have to be unique, so a repeated header gets a number added: a second name column becomes name_1. A blank header cell becomes __EMPTY, as do cells beyond the last header in longer rows. Rows with fewer cells than the header still get every key, with null for the missing values. Rename headers in your CSV first for cleaner keys.

Can I convert several CSV files at once?

Yes. Drag several CSV files onto the drop area together and each one becomes its own sheet, named after its file. Pick one from the Sheet menu to convert it alone, or tick “All sheets” to get a single JSON object keyed by file name, with each file's rows inside. The click-to-browse picker takes one file at a time, so use drag and drop for a batch.

Is there a file size limit?

The tool sets no file size limit; the file is read and converted in your browser. For big files, the preview shows the first 50 rows and 20 columns, and the Result box shows the first 200,000 characters of JSON. Copy and Download JSON always contain the full output, and the row and column count above the preview confirms how much was read.