Données

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.

Résumé de l'outil

Cet outil accepte une entrée structurée et renvoie une sortie déterministe dans le navigateur, sans envoi au serveur.

Nom de l'outil: CSV to JSON Converter
Intention d'entrée: Fournissez le contenu source à transformer, valider ou analyser.
Intention de sortie: Recevez une sortie normalisée prête à être copiée, réutilisée ou déboguée.
Entrée d'exemple: id,name,active 1,Alice,true 2,Bob,false
Sortie d'exemple: [ { "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

Introduction à l'outil

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.

Vue d'ensemble de l'outil

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.

Cas d'usage

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

Exemples d'entrée/sortie

Intention d'entrée

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

Intention de sortie

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

Quoted fields handle commas and escaped quotes per RFC 4180.

Intention d'entrée

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

Intention de sortie

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

Intention d'entrée

1	Alice
2	Bob
3	Carol

Intention de sortie

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

Questions fréquentes

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.