CONVERT · ENTIRELY IN YOUR BROWSER

CSV to JSON

Convert exported spreadsheet data into a JSON array for your application. Quoted commas, embedded newlines, and Unicode characters are handled as CSV data.

CSV to JSON workspace

LOCAL WORKSPACE
Convert / CSV to JSONA fresh start for your data.
JSON
CSVAwaiting input
A clean slate awaits

Your converted data will appear here.

Conversion options Fine-tune your output
Processed locally in your browser.

A PRACTICAL EXAMPLE

See the transformation.

Input

name,city
Alex,London
Sam,"New York"

Output

[
  {"name": "Alex", "city": "London"},
  {"name": "Sam", "city": "New York"}
]

How to use CSV to JSON

  1. Paste CSV or open a CSV file.
  2. Select the input delimiter and whether the first row contains headers.
  3. Convert and download your JSON array.

Preserve quoted fields and leading zeroes

With headers enabled, the first row supplies object keys. CSV has no reliable type information, so every cell becomes a JSON string. Commas inside quoted cells remain part of the value; a doubled quote represents one literal quote.

Input

code,note
00123,"Hello, ""world"""

Output

[
  {
    "code": "00123",
    "note": "Hello, \"world\""
  }
]

Common problems and how to fix them

Rows have different numbers of fields

Check the selected delimiter and quote cells containing that delimiter or a newline. Fix missing or extra fields in the source; the converter will not silently discard them.

My CSV has no header row

Turn off the header option. Each row becomes an array of strings, including the first row. With headers enabled, names must be nonempty and unique.

I need numbers or booleans instead of strings

Apply explicit type conversion in your application after reviewing each field. Automatic guessing can corrupt account codes and other identifiers.

Limitations and supported input

Values remain strings to preserve leading zeroes and identifiers. Header names must be unique and nonempty. Without headers, rows become arrays. Inconsistent row widths are rejected rather than silently discarded.

Files must be UTF-8 text and no larger than 10 MiB. Very deep or complex documents may exceed the 15-second processing limit. JSON numbers use JavaScript precision; keep long identifiers as strings.

Your data stays on your device

All parsing and conversion happens in a local browser worker. Your input is not sent to a server or saved in browser storage. Closing or reloading the page clears this workspace. Read our privacy explanation.

GOOD TO KNOW

A little clarity.

Simple tools. Straight answers.

Are numbers automatically converted?

No. Values remain strings, so postal codes such as 00123 retain their leading zeroes.

Can my cells contain newlines?

Yes. Wrap multiline cells in double quotes and escape an embedded quote by doubling it.

KEEP THINGS MOVING

Useful next steps.

Find your next tool

ALL TOOLS

{ }JSON to CSVTurn JSON records into spreadsheet-ready rows.CSV to JSONTransform spreadsheet rows into clean JSON.YAML to JSONMake YAML configuration ready for JSON.JSON to YAMLTurn JSON into readable YAML configuration.{ }JSON FormatterPretty-print or minify JSON in one click.JSON ValidatorFind syntax errors with a clear location.CSV CleanerTrim whitespace, remove duplicates, tidy rows.

Privacy Settings

Optional measurement is off until you choose it. Pasted data, file contents, output, and search text are never included in our analytics events.

Read the privacy policy