CSV to JSON Converter
Turn CSV into JSON and JSON back into CSV
🔒 100% бесплатно · без регистрации · файлы не покидают ваше устройство
CSV is what every spreadsheet, database and analytics dashboard exports, and JSON is what almost every API, config file and JavaScript app expects. Moving between the two by hand is where the pain starts: a product description containing a comma, an address with a line break, or a quoted field with escaped double quotes will quietly break a naive split-on-comma script and shift every column after it.
This CSV to JSON converter uses a real RFC 4180 parser instead. Quoted fields, embedded commas and newlines, escaped quotes and comma, semicolon or tab delimiters are all handled, and you decide whether the first row is a header or just data. Numbers and booleans can be detected automatically while identifiers like 01234 stay strings, so nothing loses a leading zero. The JSON to CSV direction works the same way in reverse: nested objects flatten into dot-notation columns and every field that needs quoting gets quoted correctly. Everything runs locally in your browser.
Зачем нужен CSV to JSON Converter
Seeding an app with spreadsheet data
Export a Google Sheet or Excel tab as CSV, convert it to a JSON array of objects, and drop it straight into a fixtures file or a database seed script.
Reading an API response in a spreadsheet
Paste a JSON array from an API or log, switch to JSON to CSV, and open the result in Excel, Numbers or Sheets for sorting, filtering and pivot tables.
Fixing a broken European export
Exports from German or French systems use semicolons instead of commas. Choose the semicolon delimiter and the columns line up correctly on the first try.
Debugging a messy CSV file
If a quoted field is never closed, the tool tells you the exact line so you can find the stray quote instead of scrolling through thousands of rows.
Полезные советы
- If the columns look shifted, the delimiter is usually wrong — semicolon files are common in Europe, and .tsv files use tabs.
- Turn off number detection when your CSV contains zip codes, phone numbers, or IDs you want to keep exactly as typed.
- With the header option off you get an array of arrays instead of objects, which is handy for matrix-shaped data with no column names.
- Duplicate or blank header cells are renamed automatically (name, name_2, column_3) so no column overwrites another in the JSON.
- Converting JSON to CSV works best on a flat array of objects; deeply nested structures are flattened up to four levels, then stringified.
Как пользоваться: CSV to JSON Converter
- 1Paste your CSV or drop a .csv file
- 2Pick the delimiter and say whether row one is a header
- 3Check the JSON preview on the right
- 4Copy or download the result
Часто задаваемые вопросы
Does it handle commas and line breaks inside quoted fields?▾
Yes. The parser follows the RFC 4180 rules, so quoted fields may contain commas, line breaks and escaped double quotes ("").
Is my data uploaded anywhere?▾
No. Parsing and conversion happen entirely in your browser, so customer exports and internal reports never leave your device.
What happens to nested JSON when I convert back to CSV?▾
Nested objects are flattened into dot-notation columns such as address.city, and arrays are written as JSON text inside a single cell.