CSV to JSON Converter Online — Headers, Semicolons & Quotes

Example: convert a CSV file with headers to JSON

Suppose a CSV export contains a name with a comma and text with escaped quotation marks:

name,city,note
"Alex, Jr",Kyiv,"Hello ""team"""
Vika,Lviv,Ready

With the first-row-headers option enabled, the converted JSON includes objects with named properties. The first record becomes:

{
  "name": "Alex, Jr",
  "city": "Kyiv",
  "note": "Hello \"team\""
}

The comma in Alex, Jr is part of the field, not a new column. Two adjacent quotation marks inside a quoted CSV field represent one literal quotation mark.

How to convert CSV to JSON without uploading data

1. Open the interactive converter and paste a CSV sample into the input editor.
2. Select Auto, comma, semicolon, tab or pipe as the source delimiter. If your export uses semicolons, select that explicitly if detection is incorrect.
3. Enable First row is headers when the first row contains column names such as name and city.
4. Run the conversion and inspect the JSON objects, fields and record count.
5. Copy the result or download it as a JSON file. Verify it before importing into another application.

Your CSV input is processed in the browser tab rather than sent to a conversion server. Avoid pasting secrets into untrusted pages or sharing generated files containing private records.

CSV to JSON with semicolons or tabs

CSV is a general name for delimited records. Spreadsheet exports in some locales use a semicolon rather than a comma. For example, name;city followed by Vika;Kyiv should be parsed with the semicolon option. A tab-delimited Excel export requires the tab option. This setting controls which separators end one field and start another.

Do not replace every comma in raw CSV text with another character: a quoted value may legally contain commas or newlines. If you want to change delimiters before importing, use the CSV delimiter converter.

Common mistakes when converting CSV data

Unexpected JSON property names

Check whether the first row is a header. Empty, repeated or unexpected column names can change the JSON object keys. Review the generated output before relying on a field name in code.

Comma inside a quoted cell

A correctly quoted field such as "Alex, Jr" is one value. Missing or unmatched quotation marks in source CSV can cause parsing errors or wrong columns.

Excel removed leading zeros

An identifier like 00123 may become 123 when Excel interprets it as a number. Preserve ID columns as text before exporting them if leading zeros matter.

Numbers, empty values and types

Inspect how your destination expects numbers, booleans and missing values. A CSV file normally stores textual fields, whereas JSON distinguishes strings, numbers, booleans and null. Do not assume automatic type inference matches your data contract.

Related conversion tools and guides

Need to go the other direction? Try JSON to CSV converter. To clean exports before conversion, use CSV duplicate removal or read the CSV deduplication guide. If you need an automated import flow across many spreadsheets, see optional Excel and data automation services; quotes are individual and the form does not collect payment.