DocTransform
Log InSign Up

Free tool

Convert CSV to JSON

Drop a CSV and download a JSON file with one record per row, named by your header row.

Drop your CSV here

CSV, TSV or TXT. Up to 50 MB.

Free, no sign-up. Your file is read in this browser tab and never uploaded.

Each row becomes one record named by your header row; columns holding only numbers or only true/false keep that type, and empty cells become null.

Before
After
[
  {
    "name": "Ana",
    "zip": "02134",
    "qty": 2,
    "vip": true
  },
  {
    "name": "Ben",
    "zip": "10001",
    "qty": null,
    "vip": false
  }
]

How to convert CSV to JSON by hand

Excel can't save a file as JSON. By hand, for a short file:

  1. Start a text file with [ on the first line.
  2. Write each row as {"Header": "value", …}, using your header row's names, with a comma after every row but the last.
  3. Leave numbers and true/false without quotes, and write an empty cell as null.
  4. End with ] on the last line and save the file as UTF-8 with the .json extension.

Or drop the file at the top of this page and skip these steps.

Questions

Is my file uploaded?

No. The file is read and converted by this page inside your browser tab. Nothing is sent to a server.

What does the JSON look like?

An array with one record per row, named by your header row: [{"name": "Ana", "qty": 2}]. Columns holding only numbers or only true/false keep that type, empty cells become null, and codes like 02134 stay text. A header like address.city stays one name; it is not turned into nesting.

Will my accents and separators be read?

Yes. The page reads files saved as UTF-8 or in the older Windows format Excel uses, and it finds the separator (comma, semicolon, tab or bar) for you.

Is there a size limit?

Up to 50 MB and about 20 million cells (rows times columns) per file. A bigger file is refused whole, never cut short, because a browser tab runs out of memory.

More from DocTransform

Convert a file

Fix or check a CSV