CSV to JSON Converter with Semicolon and Tab Delimiters
Convert CSV data to JSON array format
What does the CSV to JSON converter do?
It turns delimited tabular data — a spreadsheet export, a database dump, a report someone emailed you — into a JSON array of objects. The first row is treated as the header, and each subsequent row becomes an object whose keys are those header names. Quoted fields are handled, so values containing the delimiter itself (like "Smith, John") don't break the row into extra columns.
The conversion runs entirely in your browser. The CSV you paste is never uploaded, stored, or logged, so it's safe to convert exports containing emails, order data, or other records you wouldn't put in a random web form.
When to use it
The most common case is seeding or testing: you have data in Excel or Google Sheets and your code wants JSON — fixtures for tests, a mock API response, a one-off import script. Instead of writing a throwaway parser, export as CSV, paste, convert.
It's also handy in the other direction of a debugging session: when an ETL job or import endpoint chokes on a CSV file, converting a few rows here shows you exactly what objects your parser should be producing, which makes it obvious whether the file or the code is at fault. Semicolon-delimited files (the default in many European Excel locales) and tab-separated exports are covered by the delimiter switch — if your columns come out mashed into one field, that switch is almost always the fix.
Example
Paste:
name,age,email John,30,[email protected] Jane,25,[email protected]
and Convert produces a two-element array: [{"name": "John", "age": "30", "email": "[email protected]"}, ...]. Note that every value is a string — CSV has no type information, so numbers stay quoted and you cast them in your code where you know the intended type. Use "Copy link to this result" to share a permalink that restores your exact input and delimiter for a teammate; the data is encoded in the link fragment, not sent to any server. Going the other way? There's a matching JSON to CSV tool.
How to use the CSV to JSON Converter with Semicolon and Tab Delimiters tool
- 1
Paste your CSV
Include the header row — it becomes the JSON keys. Spreadsheet exports from Excel or Google Sheets work as-is.
- 2
Pick the delimiter
Comma is the default; switch to semicolon or Tab if your export uses those.
- 3
Convert
Each data row becomes one object in the output array, keyed by the headers.
- 4
Copy or share
Copy the JSON, or copy a permalink that restores your input and settings for anyone who opens it.
Frequently asked questions
Is my data uploaded anywhere?
No. Parsing and conversion happen entirely in your browser with JavaScript. Nothing you paste leaves your machine, and shared permalinks encode the data in the URL fragment, which browsers never send to the server.
Why is everything in one column / one key?
The delimiter doesn't match. European Excel exports often use semicolons and copy-pasted spreadsheet cells are tab-separated — switch the delimiter button and convert again.
Why are my numbers strings in the output?
CSV carries no type information, so every value is emitted as a string rather than the tool guessing. That keeps ZIP codes, phone numbers, and IDs with leading zeros intact; cast to numbers in your code where you know the type.
Can I convert JSON back to CSV?
Yes — use the companion JSON to CSV tool on this site. It takes an array of objects, unions all keys into a header row, and quotes values correctly.
Related on TechLogHub
Related Converter Tools
Unix Timestamp Converter with Milliseconds
Convert Unix timestamps to human-readable dates and vice versa
ENV to JSON
Convert .env files to JSON format
ENV to Docker Compose
Convert .env files to docker-compose environment snippet
Query String to JSON
Parse URL query strings into JSON objects
JSON to Query String
Convert JSON objects to URL query strings
JSON to CSV Converter with Headers from Every Key
Convert JSON arrays to CSV format
Get the next tool before you need it
One email a week: new and trending developer tools, fresh comparisons, and what shipped. Unsubscribe in one click.

