Skip to content
FileMoat

Guide

Excel's row limit (1,048,576): how to check it and work with more rows

Every Excel sheet stops at 1,048,576 rows and 16,384 columns. How to tell whether a file is over the limit, and the practical ways to work with bigger data.

Updated 18 October 2026 3 min read

Excel looks infinite, but every worksheet has a hard edge: 1,048,576 rows and 16,384 columns (the last column is XFD). Exports from databases, web shops, analytics or banks pass that number more often than you would think.

The limits at a glance

  • Excel 2007 and later, Microsoft 365 (Windows and Mac): 1,048,576 rows × 16,384 columns per sheet.
  • Old .xls files (Excel 97–2003): 65,536 rows × 256 columns. Saving in this format cuts anything beyond.
  • Google Sheets: 10 million cells per spreadsheet, whatever the shape.

How to know if your file is over the limit

  • In Excel, press Ctrl + ↓ in a full column. Landing exactly on row 1,048,576 means the file was almost certainly cut.
  • Excel may also have warned you on opening: “This data set is too large for the Excel grid”.
  • To count the real number of rows without opening the file in Excel, run wc -l file.csv on Mac or Linux, or open it in a tool that reads the whole file and reports the record count.

Working with more rows than Excel allows

Spread the data over several sheets

A converter can fill the first sheet, then continue on a second one, and so on. Everything stays in one .xlsx file you can send.

Split the file into parts

Several smaller CSV files, each with the header row, each opening normally in Excel.

Analyse without loading the rows

Power Query (Data → From Text/CSV → Load To… → Only Create Connection, with Add this data to the Data Model) lets a PivotTable summarise many millions of rows. You get totals, not a scrollable sheet.

Use a tool without a row limit

For searching and sorting the full file, databases and large-file viewers are the right tool. We are building one that runs in the browser, like our other tools.

Coming soon: open millions of rows in your browser

No row limit, nothing uploaded. Join the list to hear when it launches.

Frequently asked questions

What is the maximum number of rows in Excel?

1,048,576 rows and 16,384 columns (column XFD) per worksheet, in every version since Excel 2007, including Microsoft 365, on Windows and Mac.

Is the limit different in Google Sheets?

Google Sheets limits the whole spreadsheet to 10 million cells, so the number of rows depends on the number of columns: about 1 million rows with 10 columns, 100,000 with 100 columns.

Does a workbook with several sheets have a total limit?

No fixed total: each sheet has its own 1,048,576-row limit. In practice, very large workbooks are limited by your computer's memory and become slow to open.