CSV to JSON Converter

CSV rows into a JSON array

This converter turns CSV or TSV text into a clean JSON array right in your browser. Paste a spreadsheet export, a database dump, or an API response and get formatted JSON you can drop straight into code, a config file, or a request body. The parser follows RFC 4180, so quoted fields that contain commas, double quotes, or line breaks are handled correctly rather than splitting your rows apart.

Options you can control

Choose a delimiter — comma, tab (TSV), semicolon (common in European Excel), pipe, colon, space or caret, or type your own — or let auto-detect pick one from the first line. Keep “First row is a header” on to get an array of objects keyed by column name, or turn it off to get an array of arrays. Enable type conversion to turn cells like 42, true, and null into real JSON numbers, booleans, and null, while leaving identifiers such as 007 or zip codes as strings so nothing is corrupted. Everything runs locally, so even large or sensitive files never leave your device.

Four shapes, three ways to write them

The output does not have to be an array of objects. Pick an object keyed by a column and each row becomes the value under its own key, with the key column left out of that value; a key value that turns up twice is quoted back at you and the conversion stops, because keying on it would drop a row. Pick one array per column for {"name": ["Ann","Bob"]}. Turning the header off gives the fourth shape, an array of arrays with the first row included. Each of those can be written indented with two spaces, minified onto one line, or as JSON Lines — one record per line with no commas between them, downloaded as a .jsonl file. JSON Lines only makes sense for a list, so asking for it on a keyed or column-array shape is refused instead of quietly written as something else.

Shape the rows before they become JSON

Under More options, skip lines at the top drops a title row or an export banner sitting above the header, and auto-detect then reads the header line it lands on. Max rows caps the data rows and is applied after sorting, so a sorted limit is a real top-N. Sort rows by orders by any column — numbers as numbers, everything else in code-point order, and stable, so rows that tie keep the order the file had them in. A columns list picks and reorders the fields you want, and a name that is not in the file is reported by name. Leave an empty field out removes that key from the row object entirely instead of writing an empty string, and read NULL as null accepts NULL, Null or null without switching on full type conversion. Rebuild nested objects turns path headers such as address.city back into real nesting; a numeric segment like tags.0 rebuilds an array, the joining character can be ., / or _, and two headers that disagree about a path are reported rather than silently overwriting each other. It is the exact inverse of the flattening the JSON to CSV converter does.

Files a spreadsheet actually exports

Open a .csv, .tsv or .txt of up to 10 MB and say which encoding it was saved in: utf-8, utf-16le, utf-16be, windows-1252, windows-1251, iso-8859-2, euc-kr, shift_jis, gb18030 or big5. Decoding is strict, so a CP949 export read as UTF-8 tells you which setting to change instead of handing back a page of question marks. A leading UTF-8 byte-order mark from Excel is stripped so the first key is exactly the column name, duplicate header names are disambiguated (a, a_2) instead of one column swallowing another, and the apostrophe a spreadsheet writer puts in front of a cell starting with =, +, - or @ is taken back off on the way in. Copy link puts every option in the URL and your data in none of it.