CSV to JSON Converter Online — Free & Private

Choose the delimiter and whether row one holds headers. Uneven rows are padded deterministically with warnings, and nothing is truncated silently beyond the documented drops.

Loading…
CSV → JSON for spreadsheet exports
Explains how the delimiter is detected and how uneven rows are padded.

Developer notes

The parser rejects unclosed quotes with an error. Extra columns are trimmed, with a warning. Check the message. All cell values stay strings. Cast numbers and booleans in your own service.

Use cases

Feed a CRM CSV dump into the body of a fetch() call. Import a vendor grid before JSON Schema validation.

About these options

For CSV output, choose the delimiter, how fields are quoted, the line endings and whether to write a header row. Auto uses a comma in English and a semicolon in French, German and Spanish, as Excel expects. For CSV input, the delimiter is detected on the first line (comma, semicolon, tab or pipe). You choose whether that line holds the column names. JSON output can use 2 or 4 spaces or a single line, with an optional recursive key sort. XML output can be pretty-printed with a chosen indent width. YAML output takes an indent width and a quoting mode for strings. XML comments are dropped, because the conversion goes through a JSON tree.

Examples

Header row

Input

sku,name,qty,price WB-001,Wireless Ergonomic Mouse,120,24.99 WB-002,USB-C Hub Pro Adapter,85,49.50 WB-003,Mechanical Keyboard RGB,42,89.00 WB-004,Adjustable Monitor Stand,67,35.25

Output

[ { "sku": "WB-001", "name": "Wireless Ergonomic Mouse", "qty": "120", "price": "24.99" }, { "sku": "WB-002", "name": "USB-C Hub Pro Adapter", "qty": "85", "price": "49.50" }, { "sku": "WB-003", "name": "Mechanical Keyboard RGB", "qty": "42", "price": "89.00" }, { "sku": "WB-004", "name": "Adjustable Monitor Stand", "qty": "67", "price": "35.25" } ]

Semicolon-delimited file

Input

id;city;country 1;Paris;FR 2;Berlin;DE 3;Madrid;ES 4;Rome;IT

Output

[ { "id": "1", "city": "Paris", "country": "FR" }, { "id": "2", "city": "Berlin", "country": "DE" }, { "id": "3", "city": "Madrid", "country": "ES" }, { "id": "4", "city": "Rome", "country": "IT" } ]

Related tools

Continue with CSV → YAML or CSV → XML, or go the other way with JSON → CSV.

CSV → JSON FAQ

How the parser behaves

Why strings only?

A CSV holds plain text, and FastMinify does not guess numeric types.

Embedded newlines inside quotes?

Supported when the field is wrapped in double quotes, as RFC 4180 describes.

UTF-8 BOM?

It is removed automatically.

Multiple header rows?

Only the first row is used as the header. Preprocess the file before converting.

Convert CSV to JSON, XML, YAML, TOML and TSV.