CSV to JSON Online: Convert Spreadsheet Data in One Click

You exported data from Excel, Google Sheets, or a database — and it came out as CSV. Now you need JSON to feed an API, seed a database, or use in a JavaScript app. Writing a conversion script every time is overkill.

Convert CSV to JSON Free →

A good CSV-to-JSON converter handles headers automatically, produces valid JSON, and deals with edge cases like quoted commas and empty fields. Here’s everything you need to know.

---

When Do You Need CSV to JSON Conversion?

This conversion comes up constantly in real development work:

• API seeding — loading test data into a REST API that expects JSON
• Database imports — converting exported spreadsheet data to JSON for MongoDB or Firestore
• Frontend data — using a spreadsheet as a data source for a chart or table component
• Config generation — converting a product list or feature matrix from CSV to JSON config
• Data pipelines — transforming analytics exports before processing
• Mock data — turning sample data spreadsheets into fixtures for testing

---

How CSV to JSON Conversion Works

A CSV file has two parts: headers (first row) and data rows. The converter maps each header to a key and each data value to the corresponding value in a JSON object.

Input CSV:

name,age,city,active
Alice,28,New York,true
Bob,34,Chicago,false
Carol,22,Austin,true

Output JSON:

[
  { "name": "Alice", "age": "28", "city": "New York", "active": "true" },
  { "name": "Bob", "age": "34", "city": "Chicago", "active": "false" },
  { "name": "Carol", "age": "22", "city": "Austin", "active": "true" }
]

Each row becomes an object in an array. Headers become keys.

---

Step-by-Step: Convert CSV to JSON Online

1. Open the CSV to JSON tool
2. Paste your CSV data — or type directly in the input box
3. Verify the delimiter — default is comma (,), but you can switch to tab, semicolon, or pipe
4. Click Convert — the tool outputs valid JSON
5. Copy the output — ready to use in your code, API request, or file

---

Handling Edge Cases

Commas inside values

When a field contains a comma, it must be quoted:

name,description
Button,"Click here, or press Enter"

The converter handles this correctly and produces:

[{ "name": "Button", "description": "Click here, or press Enter" }]

Empty fields

name,email,phone
Alice,[email protected],
Bob,,555-0100

Converts to:

[
  { "name": "Alice", "email": "[email protected]", "phone": "" },
  { "name": "Bob", "email": "", "phone": "555-0100" }
]

Empty fields become empty strings. If you need null instead, post-process the output.

Type coercion

CSV stores everything as text. The converter outputs strings by default. If your API expects numbers or booleans, you’ll need to handle type conversion in your code:

const data = csvToJson(csvText);
const typed = data.map(row => ({
  ...row,
  age: parseInt(row.age, 10),
  active: row.active === 'true'
}));

No headers

If your CSV doesn’t have a header row, enable the “no header” option — the tool generates keys like field0, field1, etc., which you can rename.

---

Real-World Use Case: Seeding a Database

You have a products.csv exported from a spreadsheet:

id,name,price,category,in_stock
1,Widget A,9.99,Tools,true
2,Widget B,24.99,Gadgets,false
3,Widget C,4.99,Tools,true

Convert to JSON, then use it to seed your database:

// Node.js example
const products = require('./products.json');

async function seed() {
  await db.collection('products').insertMany(
    products.map(p => ({
      ...p,
      price: parseFloat(p.price),
      in_stock: p.in_stock === 'true'
    }))
  );
}

---

Programmatic Conversion

For automation or backend processing, several libraries handle CSV-to-JSON:

JavaScript/Node.js:

import { parse } from 'csv-parse/sync';
import fs from 'fs';

const csv = fs.readFileSync('data.csv', 'utf-8');
const records = parse(csv, { columns: true, skip_empty_lines: true });
console.log(JSON.stringify(records, null, 2));

Python:

import csv
import json

with open('data.csv') as f:
    reader = csv.DictReader(f)
    data = list(reader)

print(json.dumps(data, indent=2))

Command line with jq and mlr:

mlr --c2j cat data.csv

---

Tab-Separated and Other Delimiters

Not all “CSV” files use commas. Tabs are common from Excel exports:

name\tcity\tcountry
Alice\tNew York\tUS

The CSV to JSON converter supports custom delimiters — select tab (TSV), semicolon (common in European locales), or pipe (|).

---

Real-World Scenario: Migrating a Product Catalog from Spreadsheet to API

Your client maintains their product catalog in Google Sheets — 400 rows, columns for SKU, name, price, description, category, and stock count. You need to seed this data into a new e-commerce backend that accepts a JSON array via a REST endpoint. Re-typing it is out of the question. Exporting directly from Google Sheets as CSV and converting it is the right approach, and it takes about two minutes.

Export the sheet as CSV (File → Download → CSV). Open the CSV-to-JSON converter, paste the contents, and confirm the delimiter is a comma. The tool maps each column header to a JSON key automatically. The output is a valid JSON array ready to POST. Before sending it to the API, run the result through a JSON formatter to spot any malformed rows — empty description fields showing as "" instead of null, for example, which might cause validation errors on the backend. Handle type coercion in a small script: price should be parseFloat, in_stock (stored as "true"/"false" in the spreadsheet) should become a boolean.

This workflow scales. When the client updates the spreadsheet next month, you export again, convert, run the same coercion script, and POST the diff. Pair it with a simple Node.js migration script that compares existing IDs and only upserts changed records — suddenly a repeatable, error-free import pipeline replaces a fragile manual process.

---

Quick Tips

1. Always inspect the first few rows of output before importing. Check that column headers mapped correctly, that quoted fields with commas inside them parsed as single values, and that numeric-looking strings like "9.99" or boolean strings like "true" are flagged for type coercion.

2. Use a consistent header naming convention in your source spreadsheet. Headers with spaces (like Product Name) become awkward JSON keys. Rename them to snake_case or camelCase before exporting — it saves a post-processing step every time.

3. Handle null vs empty string explicitly. CSV has no native null type — empty cells become empty strings "" in JSON. If your API distinguishes between a missing field and an empty value, add a post-processing step: Object.fromEntries(Object.entries(row).map(([k, v]) => [k, v === '' ? null : v])).

4. For large files (10,000+ rows), process programmatically instead of in a browser tool. Use csv-parse in Node.js or Python’s csv.DictReader with streaming to avoid memory issues and handle encoding edge cases like BOM markers from Excel exports.

5. Save your coercion script alongside your data. The next time you need to re-import, the transformation logic is already written. Version-control both the raw CSV and the conversion script so you can reproduce the import exactly if something goes wrong.

---

JSON to CSV: Going the Other Way

Need to reverse the process? The JSON to CSV tool converts a flat JSON array back to CSV — useful for exporting API data to a spreadsheet.

---

Related Tools on DevPlaybook

• JSON Formatter — validate and prettify the JSON output
• JSON to CSV — reverse conversion for API data exports
• CSV Viewer — view and inspect CSV data in a table
• JSON Diff — compare two JSON objects or arrays

---

TL;DR

CSV to JSON conversion is a fundamental data-wrangling task. Key points:

• Headers become JSON keys; each row becomes an object in an array
• Watch out for type coercion — CSV values are strings, JSON may need numbers/booleans
• Handle edge cases: quoted commas, empty fields, custom delimiters
• For bulk or automated conversion, use csv-parse (Node.js) or Python’s csv module

Convert your CSV to JSON now →