CSV to JSON Converter

CSV to JSON Converter — Free CSV to JSON converter. Paste any CSV and convert it to a JSON array of objects instantly. Auto-detects comma, semicolon, or tab delimiters. Numbers and booleans are typed correctly. Choose pretty or minified output. No signup required.

Output

Delimiter auto-detected

—Rows

—Columns

PrettyFormat

CSV Input

JSON Output

CSV Input

JSON Output

How to convert CSV to JSON

Paste your CSV into the input field — the first row must be the header row with column names. The tool auto-detects whether your file uses commas, semicolons, or tabs and parses accordingly. Each data row becomes a JSON object with keys taken from the header row.

Numbers and booleans are typed automatically — 30 becomes the number 30, not the string "30". Empty cells become null.

Type coercion rules

CSV value	JSON type
42	42 (number)
3.14	3.14 (number)
true	true (boolean)
false	false (boolean)
(empty)	null
"hello"	"hello" (string)
New York	"New York" (string)

Common use cases

Converting spreadsheet exports to JSON for web APIs
Importing data from Excel or Google Sheets into a Node.js or Python script
Transforming report exports into a format usable by frontend applications
Seeding a database from a CSV file via a JSON-based API

Frequently Asked Questions

Does this tool auto-detect the delimiter?

Yes — it automatically detects whether your CSV uses commas, semicolons, or tabs by counting which delimiter appears most in the header row. You can paste standard CSV, European semicolon-separated, or TSV (tab-separated) files without any configuration.

Are numbers and booleans converted to the right types?

Yes — numeric strings are converted to JSON numbers, and "true"/"false" strings become JSON booleans. Empty cells become null. This means the output is properly typed JSON, not just strings.

What is the difference between pretty and minified output?

Pretty output includes indentation and newlines — easier to read and debug. Minified output is a single line with no extra whitespace — smaller and ready for APIs or storage.

My CSV has special characters — will it parse correctly?

The parser handles RFC 4180 quoted fields: values containing commas, newlines, or double quotes should be wrapped in double quotes. Double quotes inside quoted fields should be escaped as double double-quotes ("").