Excel Column Limits: Change XLS to XLSX for More Columns
Question details
Understand the column limits of XLS and XLSX files and choose a suitable format for an exported report.

- Product
- Microsoft Excel and QuickBooks
- Device & OS
- not provided
- Scenario
- A user wants to export a QuickBooks report to an Excel workbook with more than 256 columns.
- Observed behavior
- Legacy XLS files support 256 columns, from A through IV; XLSX files support 16,384 columns, from A through XFD.
Check the exported workbook's file extension and determine whether the source report has more than 256 columns. In QuickBooks, check the report's export options, which may vary by version.
Export the QuickBooks report in XLSX format
Use this approach when the original report exceeds the XLS limit and QuickBooks offers XLSX export.
In QuickBooks, open the report you want to export and locate its Export or Excel option.
In the export settings, select XLSX or a modern Excel workbook format if your QuickBooks version offers it, then export the report.
Open the exported file in Excel and verify that the expected columns appear beyond column IV.

Save an existing XLS workbook as XLSX in Excel
Use this option to work with additional columns in a legacy workbook that already contains the data you need.
Save an XLS workbook as XLSX in WPS Spreadsheet
Open a legacy XLS workbook in WPS Spreadsheet and save it as XLSX to work with the modern Excel column limit. Re-export the source report if the original XLS export omitted columns.
- 1. Open the XLS file: Launch WPS Spreadsheet and use Open to select the exported .xls workbook.
- 2. Choose Save As: Select Menu > Save As and choose where to save the new workbook.
- 3. Select XLSX: Choose Excel Workbook (*.xlsx) as the file type and select Save.
- 4. Review the workbook: Open the saved XLSX file and check the report data and columns beyond IV.

Frequently Asked Questions
How many columns can an XLS file contain?
An XLS worksheet supports 256 columns, from A through IV.
What is the last column in an XLSX worksheet?
The last column is XFD. An XLSX worksheet supports 16,384 columns.
Will saving an XLS file as XLSX bring back missing columns?
No. Save As changes the workbook format but cannot recover columns omitted during export. Export the original report again in XLSX if that option is available.
How can I check whether QuickBooks exports to XLSX?
Open the report in QuickBooks and check its Export or Excel options for XLSX or a modern Excel workbook format. Available options depend on your QuickBooks version.




