Headered CSV to JSON

Use this for standard CSV files where the first row names the JSON properties.

A specific workflow: Headered CSV to JSON

Prepare a spreadsheet export for an API test without hand-writing a JSON object for every row.

Example input

email,subscribed
ari@example.com,true

Expected output

[
  { "email": "ari@example.com", "subscribed": true }
]

How to use CSV to JSON

  1. Paste or upload your CSV

    Paste CSV text or open one or more .csv files exported from Excel, Google Sheets or a database client. Everything stays on your machine.

  2. Headers become JSON keys

    The first row is read as the header row and each column name becomes a property on every record. Switch to the Table view first if you want to sanity-check how the columns were detected.

  3. Copy or download the JSON

    Get back a formatted array of objects you can paste straight into a test fixture, a seed script or an API request body.