YourTools.
简体中文
CSV to Excel, Excel to CSV and JSON converter
CSV to Excel, Excel to CSV and JSON converter

Convert CSV to JSON

Convert CSV to a JSON array of objects in your browser. The header row gives the keys, number columns become numbers and codes like 007 stay strings. No upload.

Process locally

Files stay in this browser session. Closing or clearing releases them.

Choose files

CSV, XLSX, JSON, one at a time

Drop files here, or

Adjust settings

Optional: Convert to, Encoding, Delimiter and more

CSV to Excel, Excel to CSV and JSON converter

Run

Processes in this browser; cancel at any time

Choose files first

About this task

Turn a CSV export into JSON to load it into a script, a test fixture, an API request or a document database. This page opens the table converter set to JSON: every row becomes an object whose keys come from the header row, in an indented array.

A column becomes JSON numbers only when every value in it is a plain number, so prices and counts are numbers while postal codes, phone numbers and IDs with leading zeros stay strings. Empty header cells get names like column_3, and a repeated name gets _2. Files up to 10 MB, 30 columns and 100,000 rows are converted in your browser.

How to do it

  1. Choose or drop one CSV file and check the columns in the preview.
  2. Keep “Convert to” on JSON and “First row is header” on.
  3. If the preview looks wrong, change the “Encoding (CSV)” or the “Delimiter (CSV)”, for example to Semicolon for European exports.
  4. Select Run and download the .json file.

Common questions

What does the JSON look like?

An array with one object per row, such as [{"sku": "007", "price": 12.5}], indented with two spaces. Keys keep the order of the CSV columns.

How do I keep every value as a string?

Turn off “Store number columns as numbers”. Every value then stays text, which is safer for phone numbers, postal codes and anything you will not calculate with.

My CSV has no header row. What happens?

Turn off “First row is header” and the keys become column_1, column_2 and so on, so the first row is kept as data.

Other settings and related tasks

Need other settings? Open the full CSV to Excel, Excel to CSV and JSON converter tool.