Convert CSV to JSON
Turn a CSV file (separator detected automatically) into a JSON array of objects.
Processed in your browserFree
Related tools
- JSON Formatter and ValidatorIndent, validate (with the line and column of the error), minify or convert JSON to CSV.
- Clean Up TextRemove extra spaces, blank lines and duplicates, rejoin lines broken by a PDF, sort lines.
- Base64 Encoder and DecoderConvert text (UTF-8) or a file to Base64, and decode a Base64 string, URL-safe variant included.
- URL Encoder and DecoderConvert the special characters of a text to %XX (percent-encoding) and decode an encoded URL.
About this tool
Convert a CSV export (Excel, Google Sheets, database) into ready-to-use JSON: the separator (semicolon, comma, tab, pipe) is detected automatically, quoted fields and line breaks are handled, and numbers and booleans can be converted.
How to use this tool
- 1Paste or import your CSV.
- 2Indicate whether the first row contains the headers.
- 3Copy or download the JSON.
Limits to know
- Rows whose column count differs from the header get empty values for the missing columns.
- Dates remain strings.
- Accepted formats
- CSV, Text
- Maximum size
- 2 MB
Privacy and file processing
Data is processed in your browser and is never sent to a server.
Read our privacy policyFrequently asked questions
It is detected from the first rows (comma, semicolon, tab, pipe). If the detection gets it wrong, for example on a single-column CSV, pick it manually in the options.
Numbers can be converted (option); dates remain strings to avoid any misinterpretation of the format (day/month or month/day).