Convert Excel to JSON Online
Turn a sheet of an Excel workbook into JSON: one object per row, with formula results instead of formulas. The workbook is opened in your browser and never uploaded.
Drop a CSV or Excel file here
CSV · XLSX · XLS · XLSM · XLSB
Ready to download as a binary file.
How to convert Excel to JSON
Three steps from pricing.xlsx to JSON.
1. Drop the workbook
Drop an .xlsx, .xls, .xlsm or .xlsb file, or paste cells copied from Excel.
2. Check it in the grid
Make sure row 1 holds the column names. Delete title rows, notes and blank rows above the header in the grid, or they become your JSON keys.
3. Pick a shape and copy
Choose a shape and an indent, then copy the JSON or download data.json.
Example: Excel in, JSON out
A pricing sheet where the Annual column is a formula (=C2*10).
| A | B | C | D | |
|---|---|---|---|---|
| 1 | Plan | Seats | Monthly | Annual |
| 2 | Basic | 1 | 9 | =C2*10 |
| 3 | Team | 10 | 29 | =C3*10 |
[
{
"Plan": "Basic",
"Seats": 1,
"Monthly": 9,
"Annual": 90
},
{
"Plan": "Team",
"Seats": 10,
"Monthly": 29,
"Annual": 290
}
]Annual is a formula column, but the grid calculates it, so the JSON gets 90 and 290 as numbers. Only the active sheet (Plans) is converted; the Notes sheet is left out.
What changes between Excel and JSON
Numbers and text
A cell that parses as a number is written as a JSON number, anything else as a string. Here Seats, Monthly and Annual come out unquoted.
Empty cells
An empty cell becomes an empty string (""), never null.
Other shapes
Keyed Object uses the first column (Plan) as the key of each entry and leaves it out of the value. JSONLines writes one object per line, which suits streaming tools and log pipelines.
One sheet at a time
Only the sheet whose tab is active goes into the JSON: here "Plans". Click the "Notes" tab to convert that sheet instead.
When to convert Excel to JSON
- Moving data a business team maintains in Excel into an app's config or seed file.
- Building a JSON fixture from a client's spreadsheet without writing an import script.
Excel to JSON in JavaScript
TabularJS reads every sheet; the snippet picks one by name. Then each row is zipped with the header into an object.
import tabularjs from 'tabularjs';
const { worksheets } = await tabularjs('pricing.xlsx');
const sheet = worksheets.find((ws) => ws.worksheetName === 'Plans');
const [header, ...rows] = sheet.data; // Annual arrives as "=C2*10"
const records = rows.map((row) =>
Object.fromEntries(header.map((key, i) => [key, row[i] ?? '']))
);
console.log(JSON.stringify(records, null, 2));Unlike this page, TabularJS does not calculate formulas: Annual comes back as "=C2*10". Dates arrive as serial numbers (45414 is 2024-05-02).
Frequently asked questions
Can I convert all sheets into one JSON file?
Not in one go: the converter outputs the sheet whose tab is active. Convert each tab separately, or use TabularJS in code, which returns every sheet in the worksheets array.
How are Excel dates converted?
The output takes each value as the grid shows it, so check the date column in the grid before copying. In code, TabularJS returns dates as serial numbers (45414 is 2 May 2024) with the cell format alongside.
My workbook has several sheets. Which one is converted?
The one whose tab is active in the grid (the first sheet when the file opens). Click another tab to convert that sheet to JSON instead.
How do I key the JSON by Plan?
Choose Keyed Object. The first column (Plan) becomes the property name of each entry and the other columns become its fields. Values in the first column must be unique, or later rows overwrite earlier ones.
Does pricing.xlsx get uploaded when I convert it to JSON?
No. The workbook is opened in your browser and never uploaded.