Developer Data

CSV to JSON

What to do

Processed in your browser · nothing is uploaded

Local · RFC 4180, not a comma split
Advertisement
320 × 100

Converts CSV with a header row into an array of objects, parsing properly rather than splitting on commas, so quoted fields containing commas, quotes and line breaks all survive.

How to use the csv to json

1 Paste your input. The result appears immediately.
2 Pick the operation you want.
3 Copy the result, or save it as a file.

Splitting on commas is the mistake almost every quick script makes, and it fails on the first address in the file. Real CSV, as described in RFC 4180, allows a field to be wrapped in double quotes, and inside those quotes a comma is data, a doubled quote is one literal quote, and even a line break is allowed. That is why a spreadsheet export with addresses or free-text notes turns to nonsense under a naive parser. This handles all three. It does not guess types. Every value comes out as a string, because a CSV cell has no type information and guessing turns leading-zero product codes into integers and loses the zeros.

Questions

Because a quoted field can contain commas, quotes and line breaks. The first address in your file will break a naive split.

RFC 4180; common format for CSV files
Advertisement
300 × 250
Was this tool any good?
Internal signal only · I use it to find the tools worth rebuilding