Converters

CSV / JSON Converter

Convert between CSV and JSON arrays with quoted fields, newlines, and custom delimiters.

CSV / JSON
Supports quoted fields, escaped quotes, and embedded newlines.
Converted output
—

CSV / JSON Conversion

Convert between CSV table data and JSON arrays with support for quoted fields, escaped quotes, embedded newlines, and common delimiters.

Data Rules

  • CSV can use its first row as object keys
  • JSON input must have an array root
  • CSV does not retain number or boolean types, so parsed fields are strings by default

Frequently Asked Questions

Is the first CSV row always a header?
No — it is a convention, not part of the format. This tool has a switch: on, the first row becomes the JSON object keys; off, you get an array of arrays. Remember to turn it off for header-less exports (common in bank and carrier statements).
How are commas and newlines inside fields handled?
This is CSV’s one complicated rule: fields containing commas, quotes, or newlines are wrapped in double quotes, and embedded quotes are doubled (""). Excel exports normally follow this, but Chinese Excel defaults to GBK encoding and may use semicolons or tabs — check the delimiter option before pasting.
Numbers become strings — how do I keep types?
CSV has no types: "123" could be a quantity or an ID. The tool offers type inference (pure numbers become numbers, true/false become booleans); off, everything stays a string. For precise typing, post-process on the JSON side.