CSV to JSON — The Other Direction
You've got a spreadsheet or CSV export and need to turn it into JSON for an API, a config file, or a database import. This tool handles the conversion automatically. It reads your header row as object keys, infers types (numbers stay numbers, booleans stay booleans), and gives you a clean JSON array.
Supports both comma and tab delimiters — just paste from Excel or Google Sheets and we'll figure it out. Quoted fields with embedded commas are handled correctly. Empty cells become null values, which is usually what you want for API payloads.
Type Inference from CSV
CSV is inherently untyped — everything is a string. But when you're converting to JSON, you usually want 42 to be a number, not the string "42". This tool checks each value: if it looks like a number, it becomes a JSON number.true and false become booleans. Empty cells becomenull. Everything else stays a string.
Pasting from Spreadsheets
Select cells in Excel or Google Sheets, hit Ctrl+C, and paste here. Spreadsheets copy data as tab-separated values, and this tool detects tabs automatically. The first row becomes your JSON object keys, following rows become the array items. It's the fastest way to get spreadsheet data into JSON format.
Handling Special Characters
CSV files from different regions use different conventions. Some use semicolons instead of commas (common in European locales where commas are decimal separators). Quoted fields can contain the delimiter character, newlines, and double quotes (escaped as ""). This parser handles all standard CSV edge cases.
Use Cases
API Testing: Convert test data from a spreadsheet into JSON request bodies.Database Seeding: Turn CSV exports into JSON for MongoDB imports.Configuration: Convert a spreadsheet of settings into a JSON config file.Data Pipeline: Transform CSV logs into JSON for Elasticsearch or similar tools.
Limitations
This tool produces flat JSON objects — one level deep with no nesting. If you need nested structures, you'll want to post-process the output. Column names with dots (like address.city) stay as flat keys, not nested objects. For the reverse (JSON to CSV with flattening), see our JSON to CSV converter.