DataMimiDataMimi

Convert CSV to JSON

A CSV as JSON: any delimiter, any encoding, numbers and dates typed.

Want it to work exactly your way?

Keep this tool in your Mini-Apps to run it again in one click, or describe the job and AI builds an app of your own.

✦ Make your own app

How to use Convert CSV to JSON

  1. 1Select your file, or drop it on the page
  2. 2Choose how, then run it
  3. 3Download converted.json

Your file is opened in an isolated sandbox with no internet access, processed and deleted with it. It is read the way people's spreadsheets really are — headers that are not on row 1, merged cells, totals pasted at the bottom, dates in two formats — and everything that is changed is listed back to you.

Questions

How do I convert CSV to JSON?

Upload the CSV and download the JSON: one object per row, keyed by the header.

Does it work with semicolon or tab separated files?

Yes. The delimiter and the encoding are detected, including UTF-16 exports.

Are numbers written as numbers?

Yes. Amounts become numbers, dates ISO dates and empty cells null — not everything as text.

What is JSON Lines?

One JSON object per line, the format many databases and data tools load fastest. Choose it under Format.

More Excel tools

See all