CSV ⇔ JSON Converter
Paste CSV to convert it to a JSON array, or paste a JSON array to convert it to CSV. The header row is used as the JSON keys, which is handy when you want to turn a spreadsheet export straight into JSON for an API. To further format or validate the resulting JSON, try theJSON Formatteras well.
Glossary
CSV
Short for Comma-Separated Values, a text format that separates columns with a comma (or another delimiter). Widely used as the export format for spreadsheets like Excel.
JSON
Short for JavaScript Object Notation, a text format for representing data as key-value pairs. It is widely used for APIs and configuration files.
Header row
The first row of a CSV file, containing the name of each column. This tool uses the header row's values as the JSON keys.
Quoting
When a CSV field contains a comma or a newline, the whole field is wrapped in double quotes ("). A double quote inside the value is escaped by doubling it ("").
Share this page