{ } JSON Workbench0 network requests. Check DevTools

"CSV to JSON":{ }

Paste or upload a CSV and get a JSON array of objects instantly. The first row becomes object keys; each subsequent row becomes one object. Runs 100% in your browser via papaparse, with automatic type inference for numbers, booleans, and nulls. No upload, no signup.

What is CSV to JSON conversion?

CSV is the lingua franca of spreadsheets; JSON is the lingua franca of APIs and JS apps. Converting CSV to JSON lets you feed tabular data into web apps, fetch() pipelines, and NoSQL stores. An array of objects is the shape almost every JS/TS codebase expects: the header row supplies keys and each data row becomes one object.

Edge cases & gotchas

  • Leading-zero values (zip codes like 01234) become numbers under inference. Disable inference to keep them as strings.
  • Duplicate header names collide; rename them to keep keys unique.
  • No header row → keys become field1, field2… unless you toggle headers off (emits arrays).
  • Fields containing the delimiter, quotes, or newlines must be double-quoted per RFC 4180; embedded quotes are escaped by doubling ("").
  • Excel “copy” clipboard data is tab-delimited (TSV), not comma.
  • Ragged rows with uneven column counts yield missing or extra keys.

Delimiter reference

DelimiterCharCommon source
Comma,Standard CSV
Tab\tExcel clipboard / TSV
Semicolon;European Excel locales
Pipe|Log exports

How to use

  1. Paste CSV into the Input pane, upload a .csv, or drop a file.
  2. Confirm the delimiter (comma, tab, semicolon, and pipe are auto-detected) and the “first row is headers” toggle.
  3. Enable type inference to coerce numbers, booleans, and nulls, or keep every value as a string.
  4. Convert to preview the JSON array of objects.
  5. Copy the result or download it as .json.

Examples

Flat CSV → array of objects

Input
id,name,email
1,Ann,[email protected]
2,Bob,[email protected]
Output
[
  { "id": 1, "name": "Ann", "email": "[email protected]" },
  { "id": 2, "name": "Bob", "email": "[email protected]" }
]

Type inference on vs off

Input
sku,price,in_stock
A1,999,true
Output
// inference on
[{ "sku": "A1", "price": 999, "in_stock": true }]

// inference off
[{ "sku": "A1", "price": "999", "in_stock": "true" }]

Quoted field with comma + newline (RFC 4180)

Input
name,note
"Smith, John","line one
line two"
Output
[{ "name": "Smith, John", "note": "line one\nline two" }]

FAQ

Can you turn CSV into JSON?

Yes. Each CSV row becomes a JSON object keyed by the header row, and all rows collect into an array.

Is my data private?

Yes. Conversion runs entirely in your browser via papaparse. Open DevTools → Network to confirm zero requests.

Which delimiters are supported?

Comma, tab (TSV), semicolon, and pipe, auto-detected and override-able.

Does it infer types?

Yes: numbers, true/false, and empty/null values are coerced. Toggle inference off to keep everything as strings (e.g. to preserve leading-zero IDs).

Is there a file-size limit?

No hard cap. You're limited only by your browser's memory, since nothing is uploaded.

Is it free?

Free, no registration.

Related tools