How do I convert a CSV file to JSON?

Paste your CSV data into the tool, select the delimiter (comma, semicolon, tab, or pipe), check "First row is header" if the first line contains column names, then click Convert. The tool outputs a JSON array where each row becomes an object keyed by the header names.

What is the difference between CSV and JSON?

CSV (Comma-Separated Values) is a flat text format where each line is a row and commas separate fields — compact and spreadsheet-friendly. JSON (JavaScript Object Notation) is a hierarchical format using key-value pairs and arrays — better for APIs, nested data, and JavaScript applications. CSV → JSON is the standard step when importing spreadsheet data into a web app or database.

What delimiters does this CSV converter support?

The converter supports comma (,), semicolon (;), tab (TSV files), and pipe (|) delimiters. Select the matching delimiter before converting. European spreadsheets (Excel with regional settings) often use semicolons instead of commas. Tab-delimited files are common exports from databases and data tools.

What happens to quoted fields in CSV?

The parser handles RFC 4180 quoting: fields wrapped in double quotes can contain the delimiter character without being split. For example, "New York, NY" is treated as a single field even with a comma inside. Double-quoted fields with escaped quotes ("") are also handled correctly.

How do I convert CSV without a header row?

Uncheck the "First row is header" option. The converter will then output a JSON array of arrays (each inner array is a row of raw values) rather than an array of objects. This is useful for CSV data where all rows are equal and there is no column naming row.

What is the size limit for CSV conversion?

There is no hard limit — conversion runs entirely in your browser using JavaScript. In practice, files up to several megabytes convert in under a second. Very large files (100 MB+) may be slow depending on your device. For very large datasets, consider using a command-line tool like jq or csvtojson.

Back

CSV to JSON Converter

CSV (Comma-Separated Values) is a flat text format where each line is a row. JSON (JavaScript Object Notation) uses key-value pairs in a hierarchical structure. To convert: parse each CSV row using the header row as keys. Example: "name,age\nAlice,30" becomes [{"name":"Alice","age":"30"}]. Supports comma, semicolon, tab, and pipe delimiters. Quoted fields can contain the delimiter character.

Convert CSV data to JSON instantly. Supports comma, semicolon, tab, and pipe delimiters. Toggle header row, choose pretty or minified output. Free, no signup.

Works OfflineDark ModeNo Ads

CSV Input

Delimiter:

First row is header

Output:

How to Use

1
Paste your CSV data
Copy CSV data from a spreadsheet, file, or database export and paste it into the input field
2
Select the delimiter
Choose comma, semicolon, tab, or pipe — match the delimiter used in your CSV file
3
Toggle the header option
Check "First row is header" if the first line contains column names; uncheck for raw arrays
4
Click Convert to JSON
Click the Convert button to parse the CSV and generate the JSON output
5
Copy or use the JSON
Click the copy button to copy the JSON array to your clipboard, then paste it into your app or API

Frequently Asked Questions

How do I convert a CSV file to JSON?: Paste your CSV data into the tool, select the delimiter (comma, semicolon, tab, or pipe), check "First row is header" if the first line contains column names, then click Convert. The tool outputs a JSON array where each row becomes an object keyed by the header names.
What is the difference between CSV and JSON?: CSV (Comma-Separated Values) is a flat text format where each line is a row and commas separate fields — compact and spreadsheet-friendly. JSON (JavaScript Object Notation) is a hierarchical format using key-value pairs and arrays — better for APIs, nested data, and JavaScript applications. CSV → JSON is the standard step when importing spreadsheet data into a web app or database.
What delimiters does this CSV converter support?: The converter supports comma (,), semicolon (;), tab (TSV files), and pipe (|) delimiters. Select the matching delimiter before converting. European spreadsheets (Excel with regional settings) often use semicolons instead of commas. Tab-delimited files are common exports from databases and data tools.
What happens to quoted fields in CSV?: The parser handles RFC 4180 quoting: fields wrapped in double quotes can contain the delimiter character without being split. For example, "New York, NY" is treated as a single field even with a comma inside. Double-quoted fields with escaped quotes ("") are also handled correctly.
How do I convert CSV without a header row?: Uncheck the "First row is header" option. The converter will then output a JSON array of arrays (each inner array is a row of raw values) rather than an array of objects. This is useful for CSV data where all rows are equal and there is no column naming row.
What is the size limit for CSV conversion?: There is no hard limit — conversion runs entirely in your browser using JavaScript. In practice, files up to several megabytes convert in under a second. Very large files (100 MB+) may be slow depending on your device. For very large datasets, consider using a command-line tool like jq or csvtojson.

CSV to JSON Converter

CSV Input

How to Use

Frequently Asked Questions

Related Tools