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.

Ringkasan alat

Alat ini menerima input berstruktur dan mengembalikan output deterministik dalam pelayar tanpa muat naik pelayan.

Nama alat: CSV to JSON Converter
Niat input: Sediakan kandungan sumber untuk diubah, disahkan atau dianalisis.
Niat output: Terima output ternormal yang sesuai untuk disalin, digunakan semula atau dinyahpepijat.
Contoh input: id,name,active 1,Alice,true 2,Bob,false
Contoh 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

Pengenalan alat

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.

Gambaran keseluruhan alat

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.

Kes penggunaan

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

Contoh input/output

Niat input

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

Niat output

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

Quoted fields handle commas and escaped quotes per RFC 4180.

Niat input

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

Niat 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.

Niat input

1	Alice
2	Bob
3	Carol

Niat output

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

Soalan lazim

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.