How to convert CSV to JSON
- Paste your CSV data into the input box or upload a
.csvfile. - Select the delimiter used in your file, comma, semicolon, or tab. Use Auto-detect if unsure.
- Click Convert to JSON. The first row is treated as the property names of each JSON object.
- Copy the output or download it as a
.jsonfile.
How does the conversion work?
The converter reads the first row as the header, then maps each subsequent row to a JSON object using those header values as keys. A file with three rows of data and four columns produces a JSON array of three objects, each with four properties.
Quoted fields, including those that contain commas, line breaks, or double quotes, are handled according to the RFC 4180 CSV standard. Numbers and boolean values (true, false) are converted from strings when they are unambiguous.
Choosing the right delimiter
The delimiter is the character that separates values in each row. Common choices:
- Comma (,): the default; used by most spreadsheet exports and databases
- Semicolon (;): common in European locales where commas are used as decimal separators
- Tab ( ): TSV format; often produced by copy-pasting directly from spreadsheet cells
If you are not sure which delimiter your file uses, select Auto-detect and the tool will inspect the first few lines to determine the most likely separator.
Common use cases
- API development: convert a spreadsheet export to the JSON format expected by an endpoint
- Data import: load a CSV database dump into a JavaScript or Node.js application
- Configuration: transform a CSV reference table into a JSON lookup object
- Analytics: feed spreadsheet data into a charting library that expects JSON
Privacy
All conversion happens in your browser. Your CSV data is never sent to a server, never stored, and never logged. You can use this tool offline once the page has loaded.