Convert XLSX to XLS
This conversion goes backwards, and it is done under duress: an old machine, a piece of industrial software, an upload form written two decades ago. The important thing to check before you send the result is the row count, because the legacy format stops at 65,536 rows per sheet and going over that ceiling loses data rather than raising an error.
Use this without the search next time. Prathom Workbench puts Prathom's tools in your toolbar.
Add to Chrome — freeDrop your XLSX file here, or click to browse
Up to 50 MB. Deleted automatically after 30 minutes.
What it does
- Output opens in software that predates the 2007 formats
- Sheets, formulas and formatting are carried across
- Sheets over 65,536 rows or 256 columns cannot fit the format
How to use XLSX to XLS
- 1
Upload the .xlsx
Any modern workbook. Check its row count first if it holds a large dataset.
- 2
The workbook is written in the legacy format
Cells, formulas, number formats and styles are re-expressed as the binary structure the old software expects.
- 3
Verify the row count in the result
If a sheet exceeded the ceiling, the output cannot hold all of it. Compare the last row against the original before relying on the file.
How it works
The workbook's sheets, cells, formulas and styles are read from the Office Open XML package and written into the legacy compound binary structure. Formulas remain formulas, so the file recalculates when opened in whatever old software is waiting for it.
The conversion is a genuine downgrade rather than a repackaging: the destination format has fewer capabilities than the source, so some things have nowhere to go.
The row ceiling, in detail
65,536 rows and 256 columns per sheet. These are structural limits of the format and cannot be raised. A modern sheet allows 1,048,576 rows and 16,384 columns, so a dataset built in the newer format can easily exceed what the older one can hold.
This is the one check worth doing every time, because the failure is quiet. Look at the last row of the converted file and compare it with the original.
What else may be simplified
Features the newer format added and the older one never had: some conditional formatting rules, newer chart types, and recent functions. Values and ordinary formulas transfer faithfully; anything sophisticated is worth opening once to confirm.
When to send CSV instead
If the destination only needs the data rather than the workbook, CSV avoids every one of these limits. It has no row ceiling, no column ceiling and no version, and essentially all software reads it. Choose .xls only when the receiving system genuinely wants a spreadsheet file.
Converting down, and what down costs
This goes from a documented ZIP of XML to a proprietary binary, from a million rows to 65,536, and from sixteen thousand columns to 256. Every one of those is a step backwards, and the only reason to take it is software that cannot read anything else.
The row ceiling is the one that can lose data rather than features. A workbook
past 65,536 rows cannot be represented in .xls at all, and some tools truncate
silently rather than refusing — the file opens, looks right, and ends early.
Check the row count first. If it is over the limit and the destination genuinely
cannot read .xlsx, exporting to CSV is usually the better answer: it keeps every
row, and almost anything that reads .xls reads CSV too.
Examples
A template for an old production system
Small and structural, which is the ideal case for a downgrade. The old system accepts it and the formulas still work when the file is opened there.
A dataset that is too big for the format
The legacy ceiling is 65,536 rows, so nearly two thirds of this dataset has no home. Split the data across sheets or send CSV instead, which has no row limit at all.
Frequently asked questions
What happens if my sheet has more than 65,536 rows?
It does not fit. The legacy format has a hard ceiling of 65,536 rows and 256 columns per sheet, and this is a limitation of the file structure rather than of the software reading it. The failure is worse than an error because some tools truncate silently. Always compare the last row of the output against the original when converting anything large.
Why would anyone want the older format?
Because something refuses the newer one. Industrial control software, laboratory instruments, older accounting packages and a surprising number of upload forms were written when .xls was the only spreadsheet format that mattered and have never been updated. When one of those is the destination, the format is the blocker and this is how you get past it.
Are macros carried across?
No. A plain .xlsx cannot store macros in the first place, so there is nothing to carry. If the workbook you are converting is an .xlsm containing VBA, converting to .xls does not preserve that code either. Workbooks whose behavior depends on macros need to be handled deliberately rather than through a format conversion.