How are empty cells handled?

As null by default. Untick type conversion to keep them as empty strings.

Can I get one JSON object per line (NDJSON)?

Yes, choose “Array of objects” and NDJSON in the output format once conversion completes.

Is there a size limit?

Files of tens of megabytes are fine in a desktop browser.

Data & Spreadsheets

CSV to JSON

Turn a spreadsheet export into JSON for an API, a config file or a front-end fixture. Headers become keys; numbers and booleans are typed.

Runs in your browser — files never leave your device.

Drop CSV, TSV files here

or click to browse · paste from clipboard · up to 100 MB each

Select files

Options

CSV separator

Output shape

Convert numbers and booleansDotted headers → nested objectsPretty-print

Why convert CSV to JSON

Developers constantly need sample data or content from a spreadsheet as JSON. Writing a one-off script works but takes longer than dropping the file here, and this handles quoting, delimiters and encodings correctly every time.

Dotted headers (address.city) can produce nested objects, empty cells can be null or omitted, and output can be an array of objects (most common) or an array of arrays.

How it works

Drop CSV, TSV files onto the box above, click it to browse, or paste from the clipboard.
Adjust the options if you need to — the defaults suit most cases.
Press Convert. The work happens on your device, so speed depends on your computer or phone.
Download the JSON — individually or all at once.

About the formats

CSV · Comma-separated values · .csv

A plain-text table with one row per line and commas (or semicolons) between cells: the lowest common denominator for exchanging data.

CSV has no sheets, formulas, formatting or data types — everything is text.
European locales often use semicolons as separators because the comma is the decimal mark.
Values containing commas or line breaks must be wrapped in double quotes.

TSV · Tab-separated values · .tsv

Like CSV but with tabs between cells, which avoids the comma-versus-decimal problem and needs no quoting for most text.

Copying cells from Excel to a text editor produces tab-separated text.
TSV cannot contain literal tabs inside a cell without an escape convention.
Many database tools import TSV faster than CSV because there is no quoting to parse.

JSON · JavaScript Object Notation · .json

The data format of web APIs: nested objects and arrays in plain text, readable by every programming language.

JSON supports nesting; converting it to a flat table (CSV, Excel) requires flattening nested keys such as address.city.
JSON has no comments and requires double quotes around keys and strings.
A JSON array of objects maps naturally to a spreadsheet: one object per row, keys as column headers.

Related conversions

JSON to CSVOn-deviceJSON arrays flattened into CSV columns.CSV to ExcelPopularOn-deviceCSV into a proper Excel workbook, delimiter auto-detected.Excel to JSONOn-deviceExcel sheets to JSON arrays with typed values.Excel to CSVPopularOn-deviceExcel sheets to CSV with chosen delimiter and encoding.JSON to ExcelOn-deviceJSON arrays into a formatted Excel workbook.ODS to ExcelOn-deviceLibreOffice Calc ODS to Excel XLSX.

More in Data & Spreadsheets · All converters