CSV ↔ JSON Converter

Runs in your browserConverters#Data#CSV

Convert CSV to JSON and back, with file open, table preview and Excel-friendly CSV download.

Delimiter

First row is headers

Detect numbers and true/false"007" and other values with leading zeros stay text

Input CSV

id,name,city,pin,amount,paid
1,Asha Traders,Pune,411001,2500.50,true
2,Ravi Stores,Delhi,110001,1200,false
3,"Sharma & Sons, Ltd",Jaipur,302001,780,true

Output JSON · 3 rows

[
  {
    "id": 1,
    "name": "Asha Traders",
    "city": "Pune",
    "pin": 411001,
    "amount": 2500.5,
    "paid": true
  },
  {
    "id": 2,
    "name": "Ravi Stores",
    "city": "Delhi",
    "pin": 110001,
    "amount": 1200,
    "paid": false
  },
  {
    "id": 3,
    "name": "Sharma & Sons, Ltd",
    "city": "Jaipur",
    "pin": 302001,
    "amount": 780,
    "paid": true
  }
]

id	name	city	pin	amount	paid
1	Asha Traders	Pune	411001	2500.5	true
2	Ravi Stores	Delhi	110001	1200	false
3	Sharma & Sons, Ltd	Jaipur	302001	780	true

How to use, limits & privacy

About CSV ↔ JSON Converter

Convert CSV files to JSON and JSON back to CSV as you type, with a table preview. It detects the delimiter (comma, semicolon, tab or pipe), turns numbers and true/false into values, lists rows that need a look instead of failing, and flattens nested JSON into columns such as address.city. CSV downloads open correctly in Excel, including Hindi and other Indian scripts. It runs in your browser.

How to Use

Choose the direction

Pick CSV → JSON or JSON → CSV. Paste your data, click Open file, or drop a .csv or .json file on the input box.

Adjust the options

Set the Delimiter or Separator, whether the first row has headers, and whether numbers and true/false are detected. The output and Table preview update at once.

Copy or download

Click Copy or Download. Keep Excel-friendly download on when the CSV will be opened in Excel.

Privacy & Processing

Mode: local
Files Leave Browser: Local tool processing; review details below
Max Input Size: Device memory limits
Account Required: No
Data Stored Locally: Nothing is saved; the input is cleared when you leave the page.
Network Processing: Assets or models may require an initial download

Files and text are converted in your browser. Nothing is uploaded.

Rules & Limitations

Rows with too few or too many values are converted anyway and listed as warnings with their line numbers.
Values with leading zeros, such as 007 or a phone number starting with 0, stay text. Turn off number detection to keep every value as text.
For JSON → CSV, the input must be a list of objects or lists, a single object, or an object holding one list.
Nested objects and lists become dotted columns (address.city, tags.0); the reverse conversion does not rebuild the nesting.
Files up to 20 MB can be opened; the table preview shows the first 50 rows.

Top Suggestions

Turning an Excel or Google Sheets export into JSON for an app or API
Converting an API response into a CSV to open in Excel
Checking a CSV file for rows with missing values
Preparing product or contact lists for import into another system

CSV ↔ JSON Converter FAQ

How do I convert a CSV file to JSON?

Choose CSV → JSON, then click Open file or paste the CSV. The first row becomes the keys of each object; turn off First row is headers to get lists instead.

Why does Hindi text look broken when I open a CSV in Excel?

Excel guesses the wrong text encoding for plain UTF-8 files. Keep Excel-friendly download on: it adds a UTF-8 marker at the start of the file so Excel reads Hindi and other scripts correctly.

What happens to nested JSON?

Nested objects and lists are flattened into dotted column names, for example address.city and tags.0, so every value gets its own column.

Why is my CSV with semicolons not split into columns?

Set Delimiter to Semicolon if detection guesses wrong. CSV files saved by Excel in some European languages use semicolons instead of commas.

Are my files uploaded?

No. Files are read and converted in your browser and never leave your device.