Content and text
CSV to JSON Converter
Turn a CSV table into a JSON array of objects, with the delimiter detected for you.
Runs in your browser; nothing is uploaded. · Free, no account · 2 min
Importing a saved run into your account is coming soon. Until then, your last runs stay in this browser only, and you can download your files.
How to use
- Paste your CSV, or upload a .csv file, or load the example.
- Leave the delimiter on auto-detect, or choose comma, semicolon, tab or pipe.
- Say whether row one is the header, and whether to write numbers and true or false as JSON types.
- Read the warnings about ragged rows or repeated column names, then copy or download the JSON.
What it checks and how it works
The CSV is read with Papa Parse, which follows the quoting rules of RFC 4180: a cell in double quotes may hold the delimiter, a line break or a doubled quote. With a header row, each following row becomes an object keyed by the column names, and repeated names are renamed name_2, name_3. Typed output writes plain numbers, true and false, and empty cells as JSON types, while values that start with zeros, such as 01234, stay text.
CSV carries no types, so the tool cannot know that a column of digits is a phone number: leave typed output off for identifiers. A file saved from Excel in an Arabic locale may use a semicolon delimiter, which auto-detect handles.
Sources
- RFC 4180: Common Format and MIME Type for Comma-Separated Values (CSV) Files opened 29 Oct 2026
- Papa Parse documentation opened 29 Oct 2026
- RFC 8259: The JavaScript Object Notation (JSON) Data Interchange Format opened 29 Oct 2026
Related tools
JSON to CSV Converter
Turn a JSON array of records into a CSV file that opens cleanly in a spreadsheet.
JSON Formatter and Validator
Format, minify or check JSON and see exactly where it breaks.
HTML Table to CSV Converter
Paste the HTML of a table and get its data as a CSV file.
Remove Duplicate Lines, Sort and Clean a List
Remove duplicates and empty lines, trim spaces and sort a list in one pass.
Questions
About this tool
Usually an unclosed quote or a delimiter inside a cell that was not quoted. The tool counts those rows and fills missing cells with null.
No. Values that start with zeros stay text even with typed output on, so postcodes, phone numbers and SKUs keep their digits.
Yes. It reads and writes Unicode as it is. A byte order mark added by Excel at the start of the file is removed so it does not end up in your first column name.
Get started today
Find out where your brand stands in AI. Free.
Run a free AI visibility analysis on your domain. No credit card, results in minutes. See what AI engines say about your brand today.
Brands already measuring their AI visibility with Zaher.
