About XLS to XLSX
XLS to XLSX is for the spreadsheets that still come out of older accounting packages, government portals and archive folders in the Excel 97–2003 format. Newer apps, Python libraries and many upload forms expect .xlsx instead, and the old format stops at 65,536 rows. Add one .xls or a whole stack of them, and each comes back as an .xlsx with the same sheets in the same order, under the same names, with all of them also in one ZIP. Many banks, payment platforms, ERP and government systems export a web page table under an .xls name, which Excel opens only after warning that the file format and extension don't match. Those files, Excel 2003 XML files and .xlsx files that were simply renamed are recognized and converted as well, and the result says what each one really was.
The look comes across with the data: fonts with their size, bold, italic, underline and colour, cell colours, borders, alignment and wrapped text, number formats for dates, currency, percentages and thousands separators, merged cells, column widths and row heights, hidden rows, columns and sheets, frozen header rows, links and cell comments. Dates stay real dates. Two things don't come across: formulas are saved as the results they showed, and charts and pictures are not carried over. If you need live formulas, open the .xls in Excel and use Save As to pick .xlsx. If a script only needs the rows, Excel to CSV reads .xls files too and gives one CSV per sheet.
How to use XLS to XLSX
- 1Upload the .xls files
Choose or drop one or more workbooks saved in the Excel 97–2003 format, or '.xls' exports from online systems. Up to 20 files go in one task, 50 with VIP.
- 2Click XLS to XLSX
Each file is checked for what it really is, then rebuilt as a new workbook in an isolated process on our server.
- 3Download the .xlsx files
Every file keeps its name, so sales-2009.xls becomes sales-2009.xlsx, and several arrive in one ZIP as well.
Why use Cubfile for this
- The formatting comes along
Fonts, colours, borders, merged cells, number formats, column widths and frozen rows look as they did in the .xls.
- A whole stack at once
Convert a folder of old workbooks in one task and download them one by one or together as a ZIP.
- Web-page .xls exports fixed
Bank, ERP and portal exports that are really web pages, Excel 2003 XML or renamed .xlsx files become real workbooks.
- All sheets, dates intact
Every sheet keeps its name and place in the tab order, dates stay real dates, and a sheet can now grow past 65,536 rows.