How are quoted fields handled?

Standard RFC 4180. A field can be wrapped in double quotes; an embedded double quote is escaped by doubling it. The parser handles newlines inside quoted fields correctly.

CSV to JSON Converter

Convert CSV to JSON and back, with custom delimiter.

Runs in your browser

Drop CSV in the input and we'll emit JSON; flip the tab to go from JSON back to CSV. Pick the delimiter, toggle the header row.

Delimiter

First row is header

Input

Output

[
  {
    "name": "Alice",
    "age": "30",
    "city": "Paris"
  },
  {
    "name": "Bob",
    "age": "28",
    "city": "Madrid"
  },
  {
    "name": "Charlie",
    "age": "35",
    "city": "Berlin"
  }
]

How to use it

Pick a direction
CSV to JSON or JSON to CSV.
Adjust delimiter and header
Default is comma + header. Use ';' for European locales or '\t' for TSV.
Paste your data
Output updates as you type. Errors appear below if parsing fails.

What is it?

A CSV-to-JSON converter parses comma-separated values - the spreadsheet export format - into a JSON array of objects keyed by the header row. The reverse takes an array of objects and emits CSV with a header. Both are essential glue when shuffling data between Excel, a database export and an API.

When to use it

Importing a spreadsheet into a no-code form that expects JSON. Producing a CSV for someone who only knows Excel. Massaging an analytics export. Doing a quick data shape check before writing a real ETL job.

Common mistakes

Hand-rolling a CSV parser with String.split(',') - it breaks on quoted commas. Forgetting that CSV doesn't have types: every value is a string when round-tripping through CSV. And exporting CSV with a comma decimal separator in a locale that uses semicolons - switch the delimiter.

FAQ

How are quoted fields handled?: Standard RFC 4180. A field can be wrapped in double quotes; an embedded double quote is escaped by doubling it. The parser handles newlines inside quoted fields correctly.

JSON Formatter & Validator

Format, minify and validate JSON instantly.

YAML to JSON Converter

Convert YAML to JSON and back, in your browser.

How to use it

Pick a direction

Adjust delimiter and header

Paste your data

What is it?

When to use it

Common mistakes

FAQ

Related tools

More in this category