CSV to JSON Converter
Parse CSV (quoted fields, embedded commas and line breaks included) into a JSON array, using the header row as keys and optional type inference.
Runs on your device
Result
Results appear here after you select “Convert”.
What it does
Turn a spreadsheet export into JSON for seeding a database or mocking an API. The parser follows RFC 4180, so quoted fields containing commas, quotes or new lines are read correctly.
How to use it
- Paste CSV text.
- Set the delimiter and whether the first row is a header.
- Convert and copy or download the JSON.
Example
The example fills in realistic values and runs the tool. Select Try an example above to see it.
When it helps
- Creating fixtures from spreadsheets.
- Importing contact lists into scripts.
- Converting reports for JavaScript charts.
Questions
What does type inference do?
Plain numbers become JSON numbers and true, false and null become their JSON values. Leave it off to keep everything as strings, which is safer for IDs and phone numbers with leading zeros.
Are empty header cells allowed?
Yes. They are named column1, column2 and so on.
More developer tools
See all 25- Diff Checker Compare two texts line by line and see exactly which lines were added or removed, with an option to ignore whitespace changes.
- Cron Expression Explainer Translate a five field cron expression into plain English and list its next scheduled run times in your local time zone.
- Number Base Converter Convert integers of any size between binary, octal, decimal, hexadecimal and base 36 using exact BigInt arithmetic.
- JSON to TypeScript Interfaces Generate TypeScript interfaces from a sample JSON payload, with nested types, optional properties inferred from arrays, and safe property names.
- IPv4 Subnet Calculator (CIDR) Calculate network address, broadcast, usable host range, subnet mask, wildcard mask and host count from any IPv4 address and CIDR prefix.
- Chmod Calculator (Linux Permissions) Convert Linux file permissions between octal (755) and symbolic (rwxr-xr-x) notation and see exactly who can read, write and execute.
People also use
Browse all 200 tools- Ideal Weight Calculator Compare ideal body weight estimates from the Devine, Robinson, Miller and Hamwi formulas alongside the healthy BMI range for your height. Health & fitness
- Crossword Solver (Pattern Finder) Find words that fit a crossword pattern like c?o?s?o?d, using ? for unknown letters and * for any number of letters. Text & writing
- HTTP Security Headers Checker Grade a website’s HTTP security headers, HSTS, CSP, X-Frame-Options, Referrer-Policy, cookies, from pasted headers or by fetching a public URL. Leads & site analysis
- Online Voice Recorder Record your voice from the microphone with a live level meter, pause and resume, playback, and download as a WAV or WebM file. Media & files