Convert CSV to JSON
Turn a CSV file into a clean JSON array of records, using the header row for keys. Numbers and booleans can be typed automatically. The file is never uploaded.
- Nothing to install
- Stays in your tab
- Separator auto-detected
- Typed numbers and booleans
- Runs on your device. Files are never uploaded.
- Free and unlimited. No sign-up, no watermark.
CSV to JSON in three steps
No account, no email, no waiting for an upload.
- STEP 01
Paste or open your CSV
Add text or open a .csv, .tsv, .tab or .txt file.
- STEP 02
Check the options
The separator is detected for you. Say if the first row is a header, and whether numbers and true/false should be real values.
- STEP 03
Copy or download the JSON
You get an array of objects, indented the way you chose.
What CSV to JSON does, and what it doesn't
We'd rather tell you up front than surprise you after the download.
What you get
- Separator detectionCommas, semicolons, tabs and pipes are recognized, or you can set one yourself.
- Typed valuesCells like 42 and true become a number and a boolean. Values with leading zeros, such as 007, stay text.
- Empty cellsKeep them as empty strings, or turn them into null.
- Rebuild nestingColumns named address.city or tags.0 can be turned back into nested objects and lists.
- Tidy headersBlank headers become column_3 and repeated ones become name_2, so no data is overwritten.
Good to know
- Broken quotesAn unclosed quote is reported with its row. Check the file with the CSV validator.
- No header rowIf you turn the header option off, you get a list of lists instead of objects.
- Dates stay textDate strings are not converted. They remain strings in the JSON.
Your data never leave your device
The tool runs inside your browser instead of on our servers, so there is nothing to upload, store or delete afterwards.
Typical online tool upload
Your file travels over the internet, sits on someone else's computer for a while, and you wait for the upload and the download.
Mediaextractr no upload
The tool loads into your browser once, then works on your file locally. Nothing is sent, so nothing can leak.
When people use CSV to JSON
Seed test data
Turn a spreadsheet export into JSON fixtures for tests.
Feed a chart or map
Many JavaScript libraries expect an array of objects.
Import into a NoSQL store
Convert rows to documents.
Use a Google Sheet in an app
Export CSV, convert, and ship the JSON with your site.
Mediaextractr vs typical upload tools
| MediaextractrPrivate | Typical upload tools | |
|---|---|---|
| Your file is uploaded | Never | Yes |
| Sign-up needed | No | Often, after a few files |
| Daily file limit | None | Often 1–2 free files |
| Watermark | Never | Sometimes |
| Wait for upload & download | No | Yes |
| Speed on very large files | Depends on your device | Depends on their servers |
What the converter does with your cells
With the header option on, the first row gives the keys and every following row becomes an object. Cell text is kept as text, unless you leave on 'Read numbers and true/false as values'. Then 12.5 becomes 12.5, and true becomes true.
To protect IDs, only exact, safe numbers convert. Strings like 007, or a 20-digit order number, stay as text, so nothing is rounded or changed.
Nested JSON from flat columns
If your column names use dots, such as user.name and user.email, turn on the nesting option. The converter builds {"user": {"name": ..., "email": ...}}. Empty cells in those columns are left out, which suits optional fields.
- Use the same option in reverse by flattening with JSON flatten.
- Output to another structure with CSV to XML or CSV to YAML.
- Check the structure in the JSON tree viewer.
Typed values and what to expect
Typed values save a cleanup step, but the rules are cautious. Only plain decimal numbers convert, so a cell like 1,234 or 12% remains text, as does a date. Booleans must be exactly true or false in lowercase. If a column mixes numbers and words, the numbers still convert row by row, so check columns that should be uniform.
Questions, answered
How do I convert CSV to JSON?
Paste your CSV, check that the separator and header settings look right, and copy the JSON array.
Does converting a customer CSV upload it?
No. The rows are parsed and converted in your browser tab, and nothing is sent to a server.
Can it detect semicolon-separated files?
Yes. The separator is detected automatically, and you can override it.
Why did my zip codes stay as text?
Values with leading zeros are kept as text on purpose, so 02134 does not become 2134.
Can empty cells become null?
Yes. Turn on 'Empty cells become null' and blank cells are written as null instead of an empty string.
Is the converter usable on a phone?
It does, on current phone and tablet browsers. Open the file from your device or paste the text.