JSON Toolbox LogoJSONToolbox

Excel to JSON

Convert Excel and CSV files to JSON in your browser. Upload an .xlsx, .xls, or .csv file, choose a sheet, and get a JSON array where each row becomes an object. Copy or download the result without uploading your data to a server.

Excel / CSV file

Drop an .xlsx, .xls, or .csv file here

Choose file

JSON output will appear here...
All processing happens in your browser. No JSON is sent to our servers.

Key Features

Upload Excel or CSV

Open a local .xlsx, .xls, or .csv file. The file is read in your browser, so its contents are not uploaded to a server.

Pick a Sheet

When a workbook contains more than one sheet, choose the sheet you want to convert. The selected sheet's rows become the JSON output.

Rows Become Objects

The first row is used as keys and each following row becomes a JSON object. The result is a JSON array you can use directly in code.

Preserve Cell Types

Numbers stay numbers and text stays text. Empty cells are returned as empty strings so the object shape stays consistent across rows.

Copy or Download

Copy the JSON array to your clipboard or download it as a .json file for use in APIs, scripts, or data pipelines.

Browser-Based Processing

Reading, parsing, and conversion happen in your browser. The page does not require an account or send your file to a remote service.

How to Use

1

Choose an Excel or CSV file

Click Choose file or drop an .xlsx, .xls, or .csv file into the input area. The file is read locally in your browser.

2

Select a sheet

If the workbook has more than one sheet, pick the one you want to convert. The first row of that sheet is used as the JSON keys.

3

Review the JSON output

Each row becomes a JSON object and all rows form an array. Numbers and text keep their cell types, and empty cells become empty strings.

4

Copy or download

Copy the JSON array or download it as a .json file. Validate or clean the data afterward if you plan to use it in production.

Excel to JSON Example

Turn the first sheet of a spreadsheet into a JSON array of objects.

Spreadsheet (first sheet)
Name,Age,Active
Alice,28,TRUE
Bob,34,FALSE

This shows the first sheet as comma-separated values. Column headers become keys and each row becomes one JSON object.

JSON Output
[
  {
    "Name": "Alice",
    "Age": 28,
    "Active": true
  },
  {
    "Name": "Bob",
    "Age": 34,
    "Active": false
  }
]

Each row is converted to an object. Numbers stay numbers and the TRUE/FALSE cells become JSON true/false values.

Excel stores TRUE/FALSE and numbers in its own format; the converter maps them to the matching JSON types.

How to Convert Excel to JSON Online

What Is Excel to JSON Conversion?

Excel to JSON conversion, also called spreadsheet to JSON conversion, reads a table and produces a JSON array where each row becomes an object. An Excel JSON result is a portable format for moving tabular data from Excel or CSV into a web API, a configuration file, or a data pipeline.

How the Conversion Works

  1. Open the file: choose an .xlsx, .xls, or .csv file. The file is read in your browser.
  2. Use the first row as keys: the header row becomes the object keys.
  3. Map each row: every following row becomes one JSON object.
  4. Collect the rows: all objects are returned as a JSON array.

Cell Types

Numeric cells stay numbers, text cells stay strings, and boolean cells such as TRUE/FALSE become JSON true/false. Empty cells are returned as empty strings so that every object keeps the same keys. Raw date serials may appear as numbers because the converter reads the underlying cell value.

Multiple Sheets

When a workbook has more than one sheet, select the sheet you want to convert. Only the selected sheet is turned into JSON.

When to Use It

  • API payloads: turn a spreadsheet export into request bodies.
  • Configuration: move tabular settings into JSON config.
  • Data pipelines: feed cleaned rows into scripts.
  • Prototyping: quickly get sample JSON from a table.

Privacy

Conversion runs entirely in your browser. Your file is not uploaded and no account is required. Do not open files that contain passwords, tokens, or production credentials in any online tool.

Related Tools

Frequently Asked Questions

What file types can I convert?

You can convert .xlsx, .xls, and .csv files. Whether you convert xls to json or xlsx to json, the same parser reads all three formats, so a CSV export behaves like a single-sheet spreadsheet.

How are rows turned into JSON?

The first row of the selected sheet is treated as column headers and used as object keys. Each subsequent row becomes one JSON object. The final result is a JSON array of those objects.

What if my workbook has multiple sheets?

A sheet selector appears when more than one sheet is present. Choose the sheet you want; only the selected sheet is converted.

Are numbers and dates preserved?

Numeric cells are kept as JSON numbers and text cells as strings. Boolean cells such as TRUE/FALSE become JSON true/false. Spreadsheet date serials may be returned as numbers rather than formatted dates, because the converter reads raw cell values.

How are empty cells handled?

Empty cells are returned as empty strings so that every object has the same set of keys. If you need null instead, post-process the output.

Can I convert a large Excel file?

The practical limit depends on browser memory and the size of the file. Very large sheets may slow the page or the download. For huge exports, a local command-line tool such as a Python or Node script can be more reliable.

Is my file data safe?

Yes. The file is read and parsed in your browser. It is not uploaded to a server and no account is required. Avoid files that contain passwords, tokens, or other sensitive production data.

Is this a free Excel to JSON converter?

Yes. You can convert an Excel or CSV file, review the JSON, copy it, or download it without creating an account.