CSV to JSON Converter

What is CSV to JSON?

CSV (Comma-Separated Values, RFC 4180) is the universal tabular format — supported by Excel, Google Sheets, every database, every BI tool. JSON (RFC 8259) is the universal hierarchical format — used by virtually every web API and modern application.

Common conversion scenarios: importing spreadsheet data into web apps, seeding databases from Excel exports, preparing API request bodies from CSV exports, mocking API responses for testing, migrating legacy data from spreadsheets to NoSQL.

Conversion example

# CSV input
name,age,email
Alice,30,alice@example.com
Bob,25,bob@example.com

# JSON output
[
  { "name": "Alice", "age": "30", "email": "alice@example.com" },
  { "name": "Bob",   "age": "25", "email": "bob@example.com" }
]

The first row becomes JSON keys; each subsequent row becomes an object. Numbers are kept as strings unless the tool detects pure numeric columns and converts.

CSV gotchas to know

• Embedded commas: "Smith, John" → quoted strings preserve commas
• Embedded quotes: "He said ""hi""" → doubled quotes inside quoted strings
• Newlines in fields: quoted strings can span multiple lines (RFC 4180)
• Excel encoding: Excel saves CSV in CP1252/UTF-8-BOM by default — paste raw or save as "CSV UTF-8" to avoid mojibake
• Empty fields: a,,b → middle field is empty string, not null
• Delimiter variations: regional settings sometimes use semicolons (;) instead of commas (Europe)

How to Use

1. Paste CSV data or upload a .csv file.
2. Click Convert.
3. Review the JSON output — verify field names and values.
4. Copy or download as .json.

Privacy: Conversion runs in your browser. No upload.

FAQ