CSV to JSON Converter
Convert CSV or TSV into a JSON array, with types and headers detected.
How to use CSV to JSON Converter
- Paste CSV or open a .csv file exported from Excel or Google Sheets.
- Check the delimiter and whether the first row is a header.
- Copy or download the JSON.
How it works
Parsing uses Papa Parse, a widely used open-source CSV parser that follows RFC 4180: quoted fields can contain commas, quotes (escaped as "") and line breaks. The delimiter is detected from the first rows unless you choose one.
With Convert numbers and true/false on, 1843 becomes the number 1843 and true becomes a boolean; empty cells become null. Turn it off to keep every value as text, which is safer for ZIP codes and IDs with leading zeros.
Frequently asked questions
How do I convert an Excel file?
In Excel or Google Sheets, export the sheet as CSV (File → Save As / Download → CSV), then open that file here.
Why did a ZIP code lose its leading zero?
Number conversion turned it into a number. Turn off "Convert numbers and true/false" to keep values exactly as written.
What happens with duplicate column names?
Papa Parse renames duplicates (for example name, name_1) so no data is lost.
Is my data uploaded?
No. Parsing happens in your browser and nothing is stored.
Limitations
- Very large files (hundreds of MB) can exhaust browser memory; split them first.
- Excel .xlsx files must be exported to CSV first.
Last reviewed November 9, 2026. How we build and test tools.