CSV to JSON

Going the other way turns an export or a spreadsheet into an array of objects, which is the shape you want when feeding a CSV into an API, a database seeder, or a test fixture.

The first row becomes the keys. Parsing follows the real CSV conventions rather than splitting on commas: quoted fields may contain the delimiter, "" is an escaped quote, and a field may span multiple lines. Numbers and booleans are converted to their JSON types instead of staying strings.

Why did my ID 007 become 7?

Values that look numeric are typed as numbers, which drops the leading zeros. For identifiers, postcodes, and phone numbers that matters — if you need them kept as text, quoting them in the CSV is not enough, so check the output before relying on it.

My file is semicolon separated. Can I still use this?

Yes. Set the delimiter control above the editor to semicolon, tab, or pipe. Exports from spreadsheets in locales that use a comma for decimals are usually semicolon separated.