How Many Rows Can Excel Handle? 1,048,576, But With a Catch

How many rows can Excel handle? Exactly 1,048,576 per worksheet. That's the number, and it hasn't changed in years. Sounds like a lot, but the catch is that Excel often starts to crawl long before you get anywhere near it.

I've opened workbooks with a few hundred thousand rows and watched a single filter spin for ten seconds. Here's the practical number where that lag actually starts, and what to do once your data outgrows the grid.

How many rows can Excel handle?

Excel handles a maximum of 1,048,576 rows and 16,384 columns per worksheet, according to Microsoft's own specifications. A workbook can hold many sheets, and each one gets its own fresh 1,048,576-row limit.

For most everyday work, like building a chart or running a handful of formulas, you likely won’t come close to either cap.

Excel isn't the only spreadsheet with a ceiling. Here's how it compares to a couple of common alternatives:

Figures correct as of August 2026. Check the vendor's site for the latest specs.

💡 Note: The number hasn't moved across recent versions. Microsoft 365, Excel 2024, and the web version all share the same limit.

Why Excel has a row limit

Excel's row limit comes from 2 to the 20th power, or 1,048,576. Microsoft picked that number so the row index would fit into a small binary value, which kept calculations fast on the processors available when this cap arrived. Excel introduced the limit in 2007, up from just 65,536 rows in Excel 2003 and earlier.

I like knowing that detail: the cap is a genuine engineering tradeoff between speed and how many rows a worksheet can hold.

64-bit Excel keeps the same row cap, but it isn't boxed in by the old 32-bit version's roughly 2GB memory ceiling, so a workbook near that limit performs better today than it would have in 2007.

What happens when your data hits the row limit

Excel's row limit is a hard storage cap, and it works the same whether you can see the rows or not. Import a file past 1,048,576 rows, and Excel warns you the dataset is too large, then keeps only the first 1,048,576 rows if you click through. Everything past that row is gone from the sheet.

That million-row cap is mostly theoretical anyway. In my experience, sheets start to lag once they cross into the low hundreds of thousands of rows, especially with heavy formulas or a machine low on RAM. If you're doing serious analysis inside a large Excel file, the RAM in your laptop can matter more than the row count itself.

Once you push past what Excel can comfortably handle, the failures show up in a few ways:

• Silent data loss: You import more rows than the limit allows, and Excel drops everything past the cap without much warning.
• Crashes and freezes: Out-of-memory errors, spinning saves, and the occasional hard quit that takes unsaved work with it.
• File bloat and corruption: Your workbook balloons from formatting and formulas, and a cloud sync can time out mid-save, leaving a corrupted file behind.
• Wrong numbers, no error: Deep formula chains can return stale totals or flip to #REF! and #VALUE! after a heavy operation, so your report looks right while it's quietly wrong.

That last one is the failure I actually worry about with client reports. A crash, you notice right away. A silently miscalculated total, you might not catch until someone downstream asks why the numbers don't add up.

What to do when your data outgrows Excel

Once you're regularly bumping the row limit, the fix comes down to picking the right tool for the job you're actually trying to do:

Power Query, the Data Model, and PowerPivot are built into Excel, and they can pull in well over a million rows for pivoting and reporting. The tradeoff is that you give up the click-anywhere, edit-anything freedom that a normal worksheet gives you.

If you're comfortable writing queries, a database is a clean home for data you keep joining and filtering. If you'd rather not take on that learning curve, a data analysis tool can let you ask questions of a dataset that would never fit on a single sheet.

How to keep Excel fast (staying under the limit)

Not ready to leave Excel? A few habits keep a large workbook usable:

• Switch to 64-bit Excel: The 32-bit version is capped at about 2 GB of memory, while the 64-bit version lifts that limit and scales with the RAM in your machine.
• Cut your formula count: Swap whole-column references for bounded ranges, and paste values once a calculation is final so Excel isn't recalculating cells that will never change again.
• Filter at the source: Use Power Query to pull in only the rows you need instead of loading the whole file onto the sheet first.
• Save as .xlsb: The binary format opens and saves faster than .xlsx for large workbooks.
• Automate the repetitive cleanup: If you run the same prep every week, a macro can do it in one click and spare your fingers.

I've seen the formula cleanup alone buy back real time on a sluggish workbook, sometimes without touching anything else. If your spreadsheets keep hitting the wall, there are also AI tools for Excel that are worth a look.

💡 Tip: Don’t forget to create a backup before a big refresh. A timestamped copy only costs you a minute, but rebuilding a corrupted file will cost much more.

Analyze data that's too big for the grid

How many rows can Excel handle before it stops being useful for your work? Fewer than you'd think once formulas and formatting pile up. When you hit that wall, you shouldn't have to learn Power Query or SQL just to answer a simple question about your own data.

Julius is built for exactly that kind of question. Ask it in plain English, and you get the analysis and the charts back without opening a formula bar.

Here's what you can do with Julius:

• Data search: Ask your question before you have a file ready. You can pull public web data or structured financials for 17,000+ companies straight from Julius, through its Financial Datasets integration.
• Direct connections: Link Postgres, Snowflake, or BigQuery, or upload a CSV or Excel file, and analyze data that would never fit on a worksheet.
• Built-in visualization: Ask a question and get the analysis back with charts already drawn, no formulas required.
• One-click sharing: Turn any analysis into a shareable report without extra formatting.

Ready to skip the row limit and go straight to the insight? Try Julius for free today.

Frequently asked questions

Has the Excel row limit changed in Microsoft 365 or newer versions?

No. The limit is still 1,048,576 rows per worksheet across current desktop, web, and Microsoft 365 versions. Excel 2003 and earlier versions capped out much lower, around 65,000 rows.

Can Excel handle 2 million rows?

No. Excel can't hold that many rows on a single worksheet grid. You can work with well over a million rows using Excel's Data Model and Power Query, which store data outside the sheet, or move the data to a database or an AI data analysis tool.

How many rows before Excel slows down or crashes?

Excel typically starts lagging once a workbook crosses into the low hundreds of thousands of rows. Heavy formulas, large file size, and limited RAM can all push that number lower.

What is the column limit in Excel?

Excel allows 16,384 columns per worksheet, with the last column labeled XFD. Most spreadsheets hit the row limit long before the column limit, since datasets are usually longer than they are wide.

If you open a file with more rows than the limit, do you lose data?

Yes. Excel keeps only the first 1,048,576 rows in that worksheet and warns you the dataset is too large. Rows past the cap are dropped, so use a tool without a row cap if you need every row.

What's the best alternative when data is too big for Excel?

The best alternative is Power Query and the Data Model for big reporting inside Excel, a database for repeated joins and queries, or an AI data analysis tool like Julius for answers and charts without writing SQL.