Skip to content

CSV to JSON Converter

Convert CSV data to JSON with custom delimiters and header row detection. Copy the output with one click.

Enter CSV data to convert

CSV to JSON conversion

CSV (Comma-Separated Values) is the most common format for tabular data exchange. Spreadsheets, databases, and data pipelines all export CSV. Converting CSV to JSON makes the data accessible to JavaScript applications, REST APIs, and NoSQL databases that expect JSON input.

Handling different delimiters

Not all CSV files use commas. Tab-separated values (TSV) are common in scientific data and spreadsheet exports. European locales often use semicolons because commas serve as decimal separators. Pipe-delimited files appear in legacy banking and mainframe systems. This tool supports all four delimiter types.

Quoted fields and edge cases

RFC 4180 defines the CSV standard: fields containing the delimiter, newlines, or double quotes must be enclosed in double quotes. A literal double quote inside a quoted field is escaped as two consecutive double quotes (""). This parser handles all RFC 4180 edge cases.

Working with the output

The JSON output can go directly into API request bodies, seed scripts, or test fixtures. Use our JSON Formatter to further format or minify the output. For data that arrives as JSON and needs to become YAML configuration, chain this tool with our YAML Formatter.

Frequently Asked Questions

What delimiters are supported?
The tool supports comma, tab, semicolon, and pipe delimiters. European CSV files commonly use semicolons because commas serve as decimal separators in many locales.
How does the header row option work?
When "First row is headers" is enabled, the first row provides object keys and subsequent rows become objects with those keys. When disabled, each row becomes an array of values.
Does it handle quoted fields?
Yes. Fields wrapped in double quotes can contain the delimiter character, newlines, and escaped quotes (double-double-quotes). This follows the RFC 4180 CSV standard.
Is my data sent to a server?
No. All CSV parsing and JSON conversion runs in your browser. Nothing is transmitted over the network.