CSV to JSON Converter
Convert CSV data into a JSON array of objects, using the header row as keys.
From spreadsheet to JSON
To use a product list, translation table or test data prepared in Excel or Google Sheets in an app, API or database import, you need JSON. This tool uses the first row as property names and turns each row into a JSON object.
Correct CSV parsing
Commas inside quotes, cells containing line breaks and escaped quotes are read correctly. Comma, semicolon or tab delimiters can be detected automatically.
Type detection
Turn on optional type detection and '42' becomes a number, 'true' a boolean and 'null' a null value, so your app needs no extra conversion. Processing happens in your browser.
How to use CSV to JSON Converter
- Paste your CSV data.
- Choose the delimiter or let it be detected.
- Turn on type detection if you like.
- Copy or download the JSON output.
Why use this tool?
The fastest way to turn spreadsheet data into a developer-friendly format; your data never leaves your device.
FAQ
Are numbers converted to numbers?
Optionally. With type detection on, numbers, true/false and null become real JSON types.
What if there's no header row?
The first row is used as headers; add column names at the top for headerless data.
Can I paste from Excel directly?
Yes, copy the cells and paste them; tab-separated data is detected automatically.
Related tools
JSON to CSV Converter
Convert a JSON array of objects into an Excel-friendly CSV with automatic column headers.
Open toolJSON Formatter and Validator
Pretty-print messy or minified JSON and find errors with line and column details.
Open toolJSON Minifier
Remove all unnecessary whitespace from JSON for smaller, faster-to-transfer data.
Open toolXML Formatter and Validator
Indent XML documents for readability and check that they're well-formed.
Open tool