JSONToTable
Loading Excel to JSON...
Please wait a moment

How to Convert an Excel File to JSON — Step by Step

Convert any Microsoft Excel spreadsheet to JSON instantly — right in your browser. No server upload, no account, no install required.

Step 1

Upload Your Excel or CSV File

Drag your file onto the upload zone or click to browse. Supported formats: .xlsx, .xls, and .csv. Parsing runs entirely in the browser using the SheetJS library — your data is never sent to any server.

Example: Excel file before conversion

employees.xlsx
ABC
1NameCitySalary
2Lisa MartinezNew York75000
3Mike JohnsonChicago65000
Step 2

Choose Sheet and Header Option

If the workbook has multiple sheets, click the sheet tabs in the toolbar to switch between them — each sheet is converted independently. Toggle "Has headers" to control whether the first row becomes JSON object keys or stays as raw data:

•
Has headers ON (default): First row becomes property names — output is an array of objects like [{"Name":"Lisa","City":"New York"}]
•
Has headers OFF: All rows including the first are included — output is an array of arrays like [["Name","City"],["Lisa","New York"]]

Example: JSON output with "Has headers ON"

[
  {
    "Name": "Lisa Martinez",
    "City": "New York",
    "Salary": 75000
  },
  {
    "Name": "Mike Johnson",
    "City": "Chicago",
    "Salary": 65000
  }
]
Step 3

Copy or Download the JSON

The converted JSON appears in the editor panel instantly. Use the toolbar buttons to copy to clipboard or download as a .json file:

•
Copy: Copies the full JSON text to your clipboard — ready to paste into code, a database query, or another tool
•
Download JSON: Saves a .json file named after your original file and sheet
•
Multi-sheet: Switch to any sheet tab and copy/download that sheet's JSON separately
•
Need a table view? Use XLSX to Table to browse the same file as an interactive HTML table with search and filter

What is Excel to JSON Conversion?

Excel files use the Office Open XML (ECMA-376) format, a ZIP-based archive of XML files standardised by Ecma International. JSON — formally defined by RFC 8259 — is a lightweight, human-readable text format natively supported by every major programming language and database.

Converting Excel to JSON bridges the gap between spreadsheet-based data entry and modern software systems. Spreadsheets are widely used for collecting and sharing data, but applications typically consume JSON through REST APIs. This tool lets you go directly from a shared Excel file to usable JSON without writing any code.

The conversion uses SheetJS — a widely-used open-source library for reading and writing spreadsheet formats — running entirely in your browser. Refer to the Microsoft Open XML documentation for technical details on the .xlsx format.

Prefer working in a different environment? Google Sheets also supports exporting data, but for a quick one-off conversion of a local .xlsx file this browser tool requires no account or install.

Common Use Cases

API Development
Turn a product catalog or price list spreadsheet into JSON to seed a REST API or mock server without manually writing the data structure.
NoSQL Database Import
Convert employee or customer records from Excel to JSON for bulk import into MongoDB, Firestore, or DynamoDB — all of which use JSON-like document structures.
Data Migration
Extract data from legacy Excel reports and convert to JSON for migration into modern applications or cloud services that do not support .xlsx natively.
Frontend Seeding
Use JSON output directly as static data in a React, Vue, or Angular application during development — no backend needed for prototype data.
BI and Analytics
Feed JSON from Excel exports into data pipelines, dashboards, or tools that prefer JSON input over CSV for preserving data types.
Quick Data Inspection
View raw cell values and inferred data types from a spreadsheet without opening Excel or Google Sheets — especially useful for checking what an export actually contains.

Frequently Asked Questions

Is my Excel data safe?
Yes. All parsing happens locally in your browser using SheetJS. No file or data is ever sent to a server. You can verify this by using the tool while offline.
What file types are supported?
.xlsx (Excel 2007+), .xls (Excel 97-2003), and .csv files are all supported. Password-protected files cannot be parsed.
What is the difference between "Has headers ON" and "Has headers OFF"?
With headers ON, the first row becomes JSON object keys and rows become objects. With headers OFF, the output is an array of arrays including the first row as raw data.
Can I convert multiple sheets?
Yes. If your workbook has multiple sheets, tabs appear in the toolbar. Click any tab to switch sheets and convert each one independently.
Are empty cells included in JSON output?
Yes, empty cells output as empty strings ("") so the array structure remains consistent across all rows.

Related Tools

XLSX to Table

Upload an Excel file and view it as an interactive searchable table with multi-sheet support

Excel to Table

Upload an Excel (.xlsx, .xls) or CSV file and view it as a searchable, filterable HTML table instantly

Excel to CSV

Upload an Excel file and convert any worksheet to CSV — copy or download the output

Excel Column Picker

Select specific columns from an Excel file, preview the result, and download a trimmed spreadsheet

Excel Row Filter

Filter Excel rows by column conditions (contains, equals, starts with) and export only matching rows

JSON to Excel

Convert JSON data to Excel spreadsheets with multiple worksheets and formatting