XLS vs XLSX Limits FAQ

What is the exact row and column limit of an .xls file?

A classic .xls (BIFF8) worksheet holds at most 65,536 total rows (rows 1 through 65,536) and 256 columns (columns A through IV). If row 1 contains headers, you can store up to 65,535 data records per sheet.

How many rows and columns can an .xlsx file hold in Excel?

Modern .xlsx worksheets support up to 1,048,576 rows and 16,384 columns (columns A through XFD) per worksheet, with up to 32,767 characters per cell.

Why does Excel warn that the file format and extension of my .xls file do not match?

That warning appears when a website or script generates an HTML table, XML spreadsheet, or CSV text file and simply renames the extension to .xls instead of compiling a real binary OLE2 BIFF8 stream.

Do .xlsx files allow more than 32,767 characters in a single cell?

Both .xls and .xlsx cap single-cell text length at 32,767 characters. If your JSON records include longer log strings or payloads, export to UTF-8 CSV instead so long text fields are not truncated.