File Format & Compatibility

Excel Column Limits: Change XLS to XLSX for More Columns

Amos GikundaAmos Gikunda Nov 20, 2026 869 views

Question details

Understand the column limits of XLS and XLSX files and choose a suitable format for an exported report.

Excel Column Limits: Change XLS to XLSX for More Columns
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.
Before you start

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.

Solution 1Recommended

Export the QuickBooks report in XLSX format

Use this approach when the original report exceeds the XLS limit and QuickBooks offers XLSX export.

1
Open the report

In QuickBooks, open the report you want to export and locate its Export or Excel option.

2
Choose XLSX if available

In the export settings, select XLSX or a modern Excel workbook format if your QuickBooks version offers it, then export the report.

3
Check the exported columns

Open the exported file in Excel and verify that the expected columns appear beyond column IV.

Export the QuickBooks report in XLSX format
Export options vary: If XLSX is not available, check the options for your QuickBooks version or adjust the report before exporting. Saving an already truncated XLS file as XLSX will not restore missing columns.
Work with Excel files in WPS Office

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. 1. Open the XLS file: Launch WPS Spreadsheet and use Open to select the exported .xls workbook.
  2. 2. Choose Save As: Select Menu > Save As and choose where to save the new workbook.
  3. 3. Select XLSX: Choose Excel Workbook (*.xlsx) as the file type and select Save.
  4. 4. Review the workbook: Open the saved XLSX file and check the report data and columns beyond IV.
Save legacy workbooks in XLSX format for access to more columnsOpen and save Microsoft Excel XLS and XLSX filesUse familiar spreadsheet controls to review exported reportsEdit spreadsheets with the free WPS Office suite
microsoft office alternative - wps office

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.