The XLSX format allows for a maximum of 1,048,576 rows per worksheet.
Each worksheet within an XLSX file can have data in cells ranging from A1 to XFD1048576. This increased row limit provides users with a substantial capacity to work with larger datasets compared to the older XLS format.