Data

CSV to JSON Converter

Turn CSV into a JSON array with one row per object. Optional header detection, configurable delimiter, and type coercion that turns 1/true/null into real JSON values.

Riepilogo dello strumento

Questo strumento accetta input strutturati e restituisce output deterministici nel browser, senza upload al server.

Nome dello strumento: CSV to JSON Converter
Intento dell'input: Fornisci il contenuto di origine da trasformare, validare o analizzare.
Intento dell'output: Ricevi un output normalizzato adatto a copia, riutilizzo o debug.
Esempio di input: id,name,active 1,Alice,true 2,Bob,false
Esempio di output: [ { "id": 1, "name": "Alice", "active": true }, { "id": 2, "name": "Bob", "active": false } ]

CSV inputDrop file

DelimiterFirst row is headerCoerce numbers and booleans

Paste CSV above and click Convert to JSON.

JSON outputRead-only

Introduzione allo strumento

Turn CSV into a JSON array with one row per object. Optional header detection, configurable delimiter, and type coercion that turns 1/true/null into real JSON values.

Panoramica dello strumento

The parser is RFC-4180 compliant: it handles quoted fields, escaped quotes ("" → "), mixed \n and \r\n line endings, and trailing blank lines. With header mode on, the first row becomes the JSON object keys; with it off, each row is output as an array. Type coercion converts bare integers, floats, true/false, and null into their JSON-native form — leaving ambiguous strings (like "007" or "01-02") alone.

Casi d'uso

Convert an Excel export to JSON for an API test
Seed a web app fixture from a CSV file
Pipe spreadsheet data into jq for filtering
Prepare CSV survey data for a charting library

Esempi di input/output

Intento dell'input

id,name,active
1,Alice,true
2,Bob,false

Intento dell'output

[
  { "id": 1, "name": "Alice", "active": true },
  { "id": 2, "name": "Bob", "active": false }
]

Quoted fields handle commas and escaped quotes per RFC 4180.

Intento dell'input

product,price,notes
"Widget, Blue",19.99,"On ""sale"""
Gadget,42,ships 2 weeks

Intento dell'output

[
  { "product": "Widget, Blue", "price": 19.99, "notes": "On \"sale\"" },
  { "product": "Gadget", "price": 42, "notes": "ships 2 weeks" }
]

TSV input with the header row disabled outputs an array of arrays. Numeric cells are coerced to numbers.

Intento dell'input

1	Alice
2	Bob
3	Carol

Intento dell'output

[
  [1, "Alice"],
  [2, "Bob"],
  [3, "Carol"]
]

FAQ

Is this CSV to JSON converter free?+

Yes. Convert as much as you need — unlimited rows, no sign-up, no upload to any server.

Does it support tab-separated or semicolon-separated files?+

Yes. Change the delimiter option to Tab, Semicolon, or Pipe before converting. Excel exports from European locales typically use semicolons.

What is type coercion?+

When enabled, 1 becomes the number 1, "true" becomes the boolean true, and "null" becomes null. Turn it off to keep every cell as a string — useful when you want to preserve leading zeros like "007".

Can it handle quoted fields with commas inside?+

Yes. The parser follows RFC 4180: "a, b" is a single cell containing "a, b", and "" inside a quoted cell is treated as a literal double quote.

Is the first row always treated as the header?+

Only when the "First row is header" option is on (default). Turn it off and you get an array of arrays instead of an array of objects.