CSV to JSON Converter

What is CSV → JSON?

Converting CSV to JSON transforms spreadsheet or export data into the structured array of objects that APIs, JavaScript, and NoSQL databases expect. The parser follows RFC 4180 — it correctly handles quoted fields containing commas, embedded newlines, and escaped quotes — and can optionally coerce numeric strings into real numbers.

How to convert CSV to JSON

1. 1Paste your CSV (with a header row) into the input pane.
2. 2The first row is used as object keys; each subsequent row becomes one JSON object.
3. 3Toggle numeric type inference if you want "42" parsed as a number instead of a string.
4. 4Copy the JSON array for use in code, an API request, or a database import.

Use Cases

Code Examples

id,name
1,Ada
2,Linus

[
  { "id": "1", "name": "Ada" },
  { "id": "2", "name": "Linus" }
]

Key Concepts

Quoted fields

A field wrapped in double quotes can contain commas, newlines, and doubled quotes (""). This lets CSV hold free-text safely.

Header row

The first line names the columns. Without it, keys fall back to positional names like col1, col2.

Type inference

CSV is all text. Numeric inference turns "42" into 42 and "true" into a boolean — convenient, but disable it for zip codes or IDs with leading zeros.

Tips & Best Practices

• ▸Leading-zero IDs (like 00123) lose their zeros if numeric inference is on — keep them as strings.
• ▸If columns look misaligned, your CSV may use a different delimiter (semicolon/tab). Check the source export settings.
• ▸Fields with commas must be quoted in the source CSV, or the parser will split them into extra columns.
• ▸Trailing empty lines produce empty objects — trim the input if you see stray {} entries.