JSON & Data Tools

CSV → JSON

Parse CSV using RFC 4180 conventions, including quoted commas, line breaks, and escaped quotes.

Press Ctrl / ⌘ + Enter to run
Read-only result

Parse CSV using RFC 4180 conventions, including quoted commas, line breaks, and escaped quotes.

What this tool does

Convert CSV to JSON using the first row as field names and each remaining row as an object. Values stay as strings by default, with quoted commas, escaped double quotes, and line breaks handled according to CSV rules.

  • Fields containing commas such as "Tom, Jr." are supported.
  • Two double quotes in a row represent a double quote within a field.
  • Specific parsing errors will be displayed when the number of fields is inconsistent or quotation marks are not closed.

How to use it

  1. Paste the CSV with the first row of headers.
  2. Click "Convert to JSON".
  3. View parsing warnings or format object arrays.
  4. Copy the results or download result.json.

Common uses

  • Convert spreadsheet exported CSV to front-end test data.
  • Check the actual field boundaries of complex CSVs.
  • Convert Chinese and multi-line text records to JSON.

CSV → JSON Features

Parses CSV according to RFC 4180 basic rules, including commas within quotes, newlines, and double quotes. Review the result, then copy it for use.

FAQ

Do line breaks in CSV always indicate new records?

Not necessarily. Fields surrounded by double quotes can contain newlines, and the parser will keep them within the same field.

Will the numerical value automatically become Number?

Not by default, the tool preserves the textual semantics of CSV and avoids postal codes, long numbers, or leading zeros from being incorrectly converted.

Can Windows CRLF be recognized?

Yes. The parser recognizes CRLF, LF, or CR line terminators.

Back to Developer Tools