CSV to JSON Converter
Paste CSV or open a file and get clean JSON instantly. The parser handles quoted fields, escaped quotes and line breaks inside cells, and detects whether your file uses commas, semicolons, tabs or pipes. Output an array of objects keyed by the header row or plain arrays.
How to use the CSV to JSON Converter
- Paste CSV text or open a .csv, .tsv or .txt file.
- Leave the delimiter on Auto-detect or choose one.
- Choose whether the first row is a header and whether to detect types.
- Pick array of objects or array of arrays and an indentation.
- Copy the JSON or download it as a .json file.
Features
- RFC 4180 parsing: quotes, doubled quotes and multi-line cells
- Auto-detects comma, semicolon, tab and pipe delimiters
- Optional type detection for numbers, booleans and null
- Keeps values like 007 or long IDs as text
- Renames blank or duplicate headers and warns about uneven rows
Benefits
- Feed spreadsheet exports straight into APIs and code
- Avoid broken data from naive comma splitting
- Data stays in your browser
Frequently asked questions
Why are some numbers kept as text?
Values with leading zeros (like postcodes or 007) and integers too large for JavaScript are kept as strings so no information is lost.
What if a row has fewer columns than the header?
Missing values are set to null and a warning tells you how many rows were affected.
Does it handle semicolon CSV from Excel?
Yes. Auto-detect recognises semicolon-separated files, which Excel produces in many European locales.
Related tools
- Data Storage Converter — Convert bits, bytes, KB, MB, GB, TB and PB, plus binary KiB, MiB, GiB and TiB, with 1000 vs 1024 clearly labelled.
- Image Metadata Viewer — View EXIF, GPS, XMP and IPTC metadata in photos: camera, lens, exposure, date and location, then export or remove it.
- JSON to CSV Converter — Convert a JSON array to CSV, flattening nested objects into dot-notation columns, with delimiter choice and an Excel-friendly BOM.
- Percentage Calculator — Work out X% of Y, what percent one number is of another, percentage change, or increase and decrease a value by a percent.
- Loan EMI Calculator — Calculate the monthly EMI for any loan, plus total interest, total payment and a year-by-year repayment breakdown.
- Invoice Generator — Create a professional invoice with your details, line items, discounts, tax and shipping, then download it as a PDF or print it.