ConverterNew

CSV to JSON Converter with Semicolon and Tab Delimiters

Convert CSV data to JSON array format

100% client-side — your data never leaves your browserNo data stored or uploadedFree for lifetime · No signup

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. 1

    Paste your CSV

    Include the header row — it becomes the JSON keys. Spreadsheet exports from Excel or Google Sheets work as-is.

  2. 2

    Pick the delimiter

    Comma is the default; switch to semicolon or Tab if your export uses those.

  3. 3

    Convert

    Each data row becomes one object in the output array, keyed by the headers.

  4. 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

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.