CSV to JSON

About this tool

CSV (Comma-Separated Values) is a plain-text format for tabular data: each line is a row, and fields are separated by a delimiter (usually a comma, but tab, semicolon, or pipe are also common). JSON (JavaScript Object Notation) is the standard data interchange format for web APIs. Converting CSV to JSON is a common step when importing spreadsheet data into a web application, database, or API. This tool converts CSV to a JSON array of objects using the first row as keys, correctly handles quoted fields (including fields containing commas or newlines), and supports custom delimiters.

How to use

1. 1Paste your CSV data into the input field, or drag and drop a .csv file.
2. 2Make sure the first row contains your column headers — these become the JSON object keys.
3. 3If fields are separated by a tab, semicolon, or pipe instead of a comma, change the delimiter.
4. 4Click "Convert" — the JSON array appears in the output panel. Use "Copy JSON" to copy it.

Frequently asked questions

What is a delimiter and when would I change it?

The delimiter is the character that separates fields in each row. The default is a comma, but data exported from European locales or certain databases often uses a semicolon (;), and data from code editors often uses a tab. If your JSON output has keys that look like multiple fields joined together, try changing the delimiter.

What happens if a field contains a comma?

Fields that contain the delimiter must be wrapped in double quotes in the CSV file. This tool correctly handles quoted fields—including those containing commas, newlines, and escaped double quotes ("")—following the RFC 4180 specification.

What does the first row represent?

The first row is the header row—its values become the keys in each JSON object. Make sure your CSV has a meaningful header row. If the first row is data rather than headers, the resulting JSON keys will be the first row's values.

Can the output have nested objects?

No. This tool produces a flat JSON array of objects, where each CSV row becomes one JSON object. Nested structures are not inferred automatically—you would need to process the flat JSON further in your application code.