Dados

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.

Resumo da ferramenta

Esta ferramenta aceita entrada estruturada e devolve saída determinística no navegador, sem upload para o servidor.

Nome da ferramenta: CSV to JSON Converter
Intenção da entrada: Forneça conteúdo de origem para transformar, validar ou analisar.
Intenção da saída: Receba uma saída normalizada pronta para copiar, reusar ou depurar.
Entrada de exemplo: id,name,active 1,Alice,true 2,Bob,false
Saída de exemplo: [ { "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

Introdução à ferramenta

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.

Visão geral da ferramenta

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.

Casos de 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

Exemplos de entrada/saída

Intenção da entrada

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

Intenção da saída

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

Quoted fields handle commas and escaped quotes per RFC 4180.

Intenção da entrada

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

Intenção da saída

[
  { "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.

Intenção da entrada

1	Alice
2	Bob
3	Carol

Intenção da saída

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

Perguntas frequentes

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.