Convert CSV to JSON

From rows and columns to JSON objects

CSV is how spreadsheets and databases export tables, while JSON is what web apps, APIs and JavaScript code expect. Converting between them by hand is tedious and error prone, especially when values contain commas, quotes or line breaks.

This converter parses the CSV with PapaParse, a proven CSV parser, turns the first row into property names and writes each following row as an object. It detects the delimiter automatically, so semicolon-separated files from European versions of Excel work as well as comma-separated ones.

CSV vs JSON at a glance

How to convert CSV to JSON

1. 1

   Step 1: Export or save a CSV

   Use File, Save As, CSV in your spreadsheet, or take the export from your database or app.

2. 2

   Step 2: Drop the .csv file

   Make sure the first row contains the column names.

3. 3

   Step 3: Convert

   Rows are parsed with full support for quoted fields and turned into objects.

4. 4

   Step 4: Download the JSON

   You get a pretty-printed .json file with an array of objects.

Parsing details

Where CSV to JSON is useful

• Seeding a web app. Turn a spreadsheet of products or users into fixture data.

• Static site data. Feed JSON files to Astro, Next.js or Eleventy.

• API testing. Build request bodies from spreadsheet rows.

• Charts and maps. Many visualization libraries prefer JSON input.

Why every value is a string

CSV has no data types, so the converter keeps each value exactly as written, as a JSON string. That protects values that only look like numbers: ZIP codes such as 02134, phone numbers, product codes and very long IDs would be damaged by automatic number conversion.

If you need real numbers or booleans, convert the specific fields in your code, where you know which columns should be numeric. Empty cells become empty strings.

• "02134" stays "02134", not 2134.
• "TRUE" stays a string until you decide otherwise.
• "1,234.50" is kept intact for your own parsing.

Header row requirements

The first line is always treated as the header. If your file has no header, add one before converting, otherwise the first data row becomes the property names.

Duplicate column names are made unique by the parser with a numeric suffix, so no values are overwritten. Blank header cells produce empty property names, which you may want to fill in first.

Tips for CSV to JSON

• Use short, code-friendly headers such as first_name rather than First Name (optional).
• Remove summary rows and notes from the bottom of exported reports.
• Save the CSV as UTF-8 to keep accented characters intact.
• Need a key/value lookup instead of an array? Transform the JSON in your code after converting.

CSV to JSON questions