Excel to JSON: Convert a Spreadsheet Without Uploading It
A spreadsheet is a grid; JSON is a list of records. Converting one to the other means deciding which row is the header, what an empty cell becomes, and what to do with a date that Excel stores as a serial number. The converter here does it in your browser, so a sheet containing salaries, client lists or pricing never leaves your computer.
The first row becomes the keys
Each column heading becomes a property name and each row below it becomes one object. A sheet with Name | Age | City and two data rows becomes an array of two objects. A blank header cell is named column_2 rather than dropped, because silently losing a column is worse than an ugly name.
Empty cells become empty strings
Excel distinguishes an empty cell from zero; JSON has null, 0 and "". This converter uses an empty string for a genuinely empty cell, so a numeric column stays numeric and an empty text column stays text. A row where every cell is empty is skipped entirely, because it is padding from the end of the sheet, not a record.
Dates, formulas and formatting
Excel stores a date as a number of days since 1900, and a formula as an expression plus a cached result. This converter reads the cached result β the value you see in the cell β not the formula. Formatting (currency symbols, thousands separators, colours) is not carried across, because a spreadsheetβs display format is not data. If you need a date as ISO text, format the column as text in Excel before saving.
Why no upload matters here
Spreadsheets are the most sensitive files most people own: payroll, customer lists, supplier pricing, medical records. Almost every free converter uploads the workbook to a server to parse it server-side. This one unzips the .xlsx in your browser, reads the XML, and produces JSON locally. The Excel to JSON converter does the same work with no upload at all.
When a .csv is better
If the workbook has one sheet, no formatting and no formulas, saving as CSV and using the CSV to JSON path is faster and produces a smaller file. Use .xlsx when the data genuinely lives in Excel and re-exporting would risk changing it.