Excel File Row Limit: Maximum Rows and Your Options

An Excel worksheet can contain a maximum of 1,048,576 rows, numbered 1 through 1,048,576. That limit applies to each worksheet in modern Excel, including Excel for Microsoft 365; it is not a limit on the total number of rows across every sheet in a workbook.

The maximum number of rows in Excel

The row ceiling is part of the worksheet grid. Every worksheet has 1,048,576 rows and 16,384 columns, with the final column named XFD. These are fixed limits: adding another worksheet gives you another grid, but it does not enlarge the existing one.

A row can be empty, contain values, hold formulas, or be used as a table header. It still occupies one of the numbered positions. If a dataset has one header row followed by 1,048,575 records, it fills the sheet exactly. If the first row is a title and the second is a header, only 1,048,574 rows remain for records.

For example, a worksheet with 250,000 data records and one header uses 250,001 rows. It has 798,575 grid rows left, though that does not necessarily mean the workbook will perform well with that many additional records. Memory, formulas, formatting, and other workbook contents affect practical performance.

Why older Excel files have a lower limit

The limit depends on the file format as well as the version of Excel. The older Excel 97–2003 workbook format, usually identified by the .xls extension, supports 65,536 rows and 256 columns per worksheet. Its last column is IV. Modern .xlsx workbooks support 1,048,576 rows and 16,384 columns.

This difference matters when exchanging files with someone who uses an older version or when saving a modern workbook in the older format. Excel may warn that features or data are incompatible. A sheet containing more than 65,536 rows cannot be represented in full in an .xls worksheet; saving a copy in that format can require removing or rearranging data. Keep the original .xlsx file and check any compatibility warnings before continuing.

CSV is different: it is a plain-text format, not an Excel workbook format, and it does not define a universal worksheet row ceiling. A CSV file may contain more records than Excel can show on one sheet. Opening or loading it into a worksheet does not remove Excel’s grid limit, however. A program designed to process the complete file, or an appropriately configured data import, may be needed for records beyond that limit.

Does the limit apply to a workbook or a worksheet?

The 1,048,576-row limit applies separately to every worksheet. A workbook can have multiple sheets, and Excel does not set one small fixed maximum total row count for all sheets combined. The possible number of worksheets depends on available memory and system resources. Adding sheets can therefore increase the amount of data a workbook holds, but it is not always a good way to manage a large dataset.

Splitting a list across sheets can make it harder to filter, sort, summarize, or keep records consistent. If you divide data this way, use a consistent column layout and an explicit way to identify which part contains each record. For analysis across many parts, combining the data in Power Query or storing it in a database is often more manageable than manually copying ranges between sheets.

There is also a difference between worksheet rows and the Excel Data Model. The Data Model can store and relate data for analysis without putting every record into visible worksheet cells. Its capacity depends on available memory and other system resources, so it should not be treated as unlimited. It is nevertheless a useful option when the dataset is larger than one worksheet and the goal is to build PivotTables or reports rather than inspect every record in a grid.

How to check how much room is left

Excel shows the row number along the left edge of the worksheet. The last possible row is 1,048,576 in a modern workbook or 65,536 in an .xls worksheet. To estimate remaining space, count the rows occupied by headers and records, then subtract that total from the sheet’s maximum. Remember that a title, notes, or blank rows placed inside the data range also take up positions.

To inspect a large sheet, use the Name Box to the left of the formula bar: enter A1048576 and press Enter to go to the bottom row in column A. This only navigates to a cell; it does not tell you how many records your dataset contains. If you use Ctrl+End on Windows, Excel moves to the last cell it considers used, which may be far beyond the actual data because formatting or past edits can extend the used range.

For a reliable record count, identify the column that should contain a value on every record, then count its populated entries with a suitable method. Check that the count excludes the header if you are comparing records with the worksheet’s available rows. Blank lines within a list and partially filled records can make a simple visual estimate misleading.

What happens when data exceeds the row limit?

A worksheet cannot display or store additional rows below its final row. When an import or paste operation contains more data than the sheet can accommodate, Excel cannot place all of it in that worksheet. Depending on the operation and the source, Excel may report a problem or load only the portion that fits. Do not assume that a completed-looking sheet contains every source record: compare the imported row count with the source count.

Formulas, formatting, and tables cannot extend the grid either. Converting a range into an Excel Table makes filtering and structured references more convenient, but a table remains on a worksheet and cannot exceed the worksheet’s dimensions. Likewise, changing zoom, hiding rows, or using a different view does not change the maximum.

If Excel opens a large CSV, it may be tempting to treat the visible bottom row as the end of the source file. It is only the end of the worksheet area available for that load. Preserve the original file and verify the number of source records before deleting, overwriting, or reporting on an imported subset.

Ways to work with more than one sheet can hold

The right solution depends on whether you need to view every record, transform it, or summarize it. Consider these approaches:

Use Power Query and the Data Model. In Excel for Microsoft 365 on Windows, choose Data > Get Data > From File > From Text/CSV to connect to a text file, then select Transform Data if you need to clean or reshape the data. In Power Query Editor, use Home > Close & Load > Close & Load To… and choose an available load destination such as the Data Model rather than a worksheet when the complete dataset will not fit in a sheet. The exact options can depend on the source and Excel setup. On Mac or Excel for the web, available import and Data Model features can differ; check the commands in that version rather than assuming the Windows path is present.
Summarize instead of displaying every record. If the task is reporting, use a PivotTable or an aggregated query to show totals by month, product, region, or another category. A summary with a few thousand groups may answer the business question without placing millions of transaction rows on a sheet.
Use a database or data platform. For data that must be stored, filtered, joined, and queried at scale, a database is designed for that kind of work. Excel can remain a reporting or analysis front end, while the larger source stays in a system better suited to managing it.
Split the output only when separate files or partitions make sense. Splitting a file by year or another clear key may be practical for delivery or archival, but it introduces the risk of duplicated, omitted, or inconsistently formatted records. Document the split and retain a reliable source of truth.

Power Query is available in Microsoft 365 for Windows and can transform data before loading. Loading a query result to a worksheet still brings the worksheet row limit into play. Loading to the Data Model avoids displaying all records as worksheet cells, but the model consumes memory and is intended for analysis, not as a substitute for a well-managed database in every situation.

Choosing a format and avoiding data loss

For ordinary modern work, save in .xlsx format unless a specific workflow requires another type. Use .xls only when an older application genuinely needs it and the data fits its limits. If you need to share a large extract, a text-based format such as CSV can be useful, but remember that CSV does not preserve workbook features such as multiple sheets, cell formatting, formulas as formulas, or the Data Model.

Before converting or importing a large file, make a copy and compare counts at each stage: source records, records after any filtering, and records loaded to the destination. When an import applies filters or removes duplicates, a lower output count may be expected; when it does not, an unexpected difference deserves investigation.

Also distinguish file size from row capacity. A workbook with fewer rows can still be slow or large if it contains complex formulas, extensive formatting, many pivot caches, images, or other embedded content. Conversely, a simple dataset can contain many rows while remaining relatively compact. Hitting a performance problem before reaching the official row ceiling is not unusual, and adding more worksheet rows is not a fix for slow calculation or an oversized file.

Common misconceptions about Excel row limits

One frequent misconception is that Excel has one million rows total. The limit is 1,048,576 rows per worksheet, and a workbook can contain more than one worksheet. Another is that a table, filter, or CSV import bypasses the grid limit. These features change how data is organized or brought into Excel, not the dimensions of the worksheet itself.

It is also easy to confuse the row limit with the number of records a computer can process. Excel’s worksheet grid has a firm boundary, but other tools and Excel’s Data Model may handle larger datasets subject to their own capabilities and available resources. The best choice depends on what you need to do with the data, not just how many rows the source contains.

Frequently Asked Questions

How many rows can an Excel spreadsheet have?
A modern Excel worksheet supports 1,048,576 rows. The older .xls format supports 65,536 rows per worksheet.

Is the Excel row limit per sheet or per file?
It is per worksheet, not per workbook. A workbook can contain multiple sheets, although the number it can use depends on available memory and resources.

Can Excel handle more than 1 million rows?
It cannot put more than 1,048,576 rows on one worksheet. You can work with larger sources using options such as the Data Model, Power Query, or a database, subject to system resources and the capabilities of the chosen tool.

Does a CSV file have the same row limit as Excel?
No. CSV is a text format without a universal Excel-style worksheet limit. But loading the file into an Excel worksheet still cannot display more rows than the sheet supports.

Will converting an .xlsx file to .xls keep all its rows?
Not if a worksheet has more than 65,536 rows. The .xls format has a lower row limit, so keep a modern-format original and review Excel’s compatibility warnings before saving a legacy copy.

Try it: the Date Difference Calculator: days, months, years and weekdays between two dates, with the DATEDIF formulas.

More in How-to basics

Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources

Spotted an error in this guide? Let us know.