CSV to JSON
What this does
Reads a CSV (header row plus data rows) and produces an array of JSON objects, one per row, with the header names as keys. Quoted fields, embedded commas and line breaks inside quotes are handled.
When to use it
- Turning a spreadsheet export into data a web app or API can use.
- Building seed data for a database.
Good to know
All values come out as strings. Numbers and booleans can be converted with the option, but leading zeros (postcodes) will then be lost — leave them as text.