Google Sheets 20 Million Cell Limit: What Changed and How to Fix Size Errors

Google Sheets doubled its maximum spreadsheet capacity

For years, the practical hard ceiling for a normal Google Sheets spreadsheet was 10 million cells across the workbook. In April 2026, Google opened a beta that doubled that capacity to 20 million cells for participating organizations. On 10 September 2026, Google announced that the doubled limit was moving to general availability.

The new capacity is not restricted to spreadsheets created after the announcement. Google says it applies to new files, existing files, and imported files. That means an existing workbook that previously had to stop growing near the old ceiling can expand further once the feature reaches the account.

The change is important because “20 million cells” describes spreadsheet capacity, not merely the number of cells that currently contain visible data. Large workbooks with many tabs, rows and columns can consume the limit much sooner than users expect.

Official source: Google Workspace Updates, September 10, 2026. The earlier beta was announced in Google’s April 22, 2026 Sheets performance update.

The 20 million-cell limit is rolling out gradually

General availability does not mean every Google account received the new capacity at the same moment. Google is using its normal staged Workspace rollout.

There is no admin control and no end-user setting for the larger limit. Once the rollout reaches the account, the expanded capacity applies automatically when creating, expanding or importing spreadsheets.

This rollout schedule is the first thing to check if you read that Sheets supports 20 million cells but your spreadsheet still refuses to grow beyond the old ceiling. A Rapid Release account can be in the rollout window through late September, while Scheduled Release domains begin later.

How is the Google Sheets cell limit counted?

The useful mental model is rows × columns for every tab, added together across the spreadsheet. The limit is not simply a count of cells containing values or formulas. Allocated blank rows and columns can consume spreadsheet capacity too, which is why deleting genuinely unused grid space can resolve a limit error even when those cells look empty.

This explains a common situation: the visible dataset may contain far fewer than 20 million populated cells, but the workbook can still approach its grid ceiling because many tabs contain thousands of unused rows or columns.

Google’s Help Community troubleshooting guidance for cell-limit errors specifically recommends deleting empty rows or columns elsewhere in the spreadsheet when a result cannot expand because the workbook may exceed the cell limit.

Practical troubleshooting reference: Google Docs Editors Community guide to IMPORTRANGE errors. Community guidance is not the same as an official product specification, but it reflects the established behavior of the Sheets grid limit.

Why does Google still say 10 million cells in some places?

As of 14 September 2026, Google’s newer Workspace Updates post says the limit is now 20 million cells, while the Google Drive Help page titled “Files you can store in Google Drive” still displays the older 10 million-cell limit.

That is a documentation mismatch, not evidence that the September announcement is false. The Workspace Updates post is dated September 10 and explicitly says the 20 million limit is now generally available, subject to the staged rollout. The older Help text simply has not caught up yet.

There are therefore two different reasons you may still encounter “10 million”:

1. Your account has not received the rollout yet. This is especially plausible during September and early October 2026.
2. You are reading an older Help Center page or error reference. Google’s documentation can update after the product announcement.

Compare the current September 2026 Workspace announcement with the Google Drive Help file-size page, which still showed the older value when this article was reviewed.

First identify which “size” error you actually have

Increasing the spreadsheet cell ceiling does not make every size-related Google Sheets error the same. Before deleting data, identify whether the failure is caused by the workbook grid, an imported file, a Connected Sheets extract, or an import-function quota.

How to fix a Google Sheets cell-limit error

If the problem really is the workbook’s grid capacity, the fastest fix is usually to reduce the number of allocated cells rather than deleting random values.

1. Delete unused rows at the bottom of large tabs. Select rows you do not need, right-click and delete them. Clearing contents is not the same as reducing the grid.
2. Delete unused columns to the right. Tabs imported from other systems can contain far more allocated columns than the visible data needs.
3. Check every tab, including hidden tabs. The spreadsheet limit applies across the workbook, so an oversized archive or hidden staging sheet can consume capacity.
4. Move historical data into an archive spreadsheet. Keep the active operational workbook smaller and link to the archive only where necessary.
5. Split unrelated workloads. If one spreadsheet contains several years, regions or business units that rarely interact, separate files can be easier to maintain than one 20 million-cell workbook.
6. Reduce the destination size before copying tabs. A sheet copy can fail when the target workbook would cross the limit even if the copied data itself is relatively small.

For example, if a tab has 200,000 rows and 100 columns allocated, that tab alone represents 20 million grid cells. If the actual dataset uses only 25 columns, removing the unnecessary 75 columns drastically reduces the grid footprint without removing any real records.

Do not assume that pressing Delete on cell contents frees the same capacity. When the problem is grid size, the useful action is to delete the rows or columns themselves where they are truly unnecessary.

How to fix “This file is too large to import directly into Google Sheets”

This error can survive the move to 20 million cells because Google treats spreadsheet cell capacity and imported file byte size as separate constraints. In its September announcement, Google specifically said it plans to increase the file byte-size limit for imported spreadsheets in the future.

For a very large CSV, Google’s own recommendation is to import the file into BigQuery and analyze it through Connected Sheets. Google says this workflow can let users open CSV files of any size for analysis with familiar Sheets tools because the full source data remains in BigQuery rather than being forced into the normal spreadsheet grid.

1. Open the large file or begin from Sheets.
2. Choose Data → Data connectors → Connect to BigQuery.
3. Select the Google Cloud project. BigQuery access and an appropriate project are required.
4. Create the BigQuery table from the file.
5. Analyze the connected dataset from Sheets. Use pivots, functions, charts, queries or filtered extracts instead of loading every raw cell into a standard workbook.

Google’s official ingestion guidance: Learn how to optimize your data ingestion and Get started with BigQuery data in Google Sheets.

A 20 million-cell spreadsheet can still be slow

The new limit is a capacity increase, not a promise that every 20 million-cell workbook will feel fast. Large datasets interact with formulas, conditional formatting, external imports, array calculations, volatile functions, scripts and browser memory.

Google did improve large-sheet performance before the 20 million-cell general release. In April 2026, Google said spreadsheets with more than one million cells could open up to 30% faster, filtering could be up to 60% faster, and applying conditional formatting could be up to 60% faster.

Those improvements are meaningful, but they do not make spreadsheet design irrelevant. A 5 million-cell workbook with thousands of expensive formulas can perform worse than a much larger workbook containing mostly static values.

Ways to reduce performance pressure

• Limit formulas to the rows that actually need them rather than using unnecessarily large open-ended ranges.
• Reduce repeated volatile calculations where a stored value or controlled refresh is sufficient.
• Consolidate repeated external import calls instead of creating many separate IMPORT functions.
• Remove conditional-formatting rules that cover huge unused ranges.
• Use a database or BigQuery for raw datasets that are primarily queried rather than manually edited.

Performance figures come from Google’s April 2026 Sheets performance announcement.

When 20 million cells is still not enough: use Connected Sheets

There is a point where increasing a spreadsheet ceiling stops solving the underlying problem. If you routinely work with tens or hundreds of millions of records, a spreadsheet should often become the analysis interface rather than the place where every raw record is stored.

Connected Sheets lets Google Sheets query and analyze data stored in BigQuery. Google describes it as a way to work with billions of rows while keeping a familiar spreadsheet interface. Queries run against BigQuery, and the results needed for analysis are surfaced in Sheets.

This also changes the architecture of the workbook. Instead of importing a massive CSV and then fighting the spreadsheet ceiling, you can keep the source data in BigQuery, filter or aggregate it first, and return only the slices required for a report, chart, pivot table or operational decision.

Connected Sheets has its own feature-specific limits. For example, Google’s current documentation says BigQuery extracts can pull up to 500,000 rows or 10 MB; when an extract contains more than 50,000 rows and up to 500,000 rows, it must stay at or below 5 million cells. Those are extract limits, not the normal spreadsheet’s new 20 million-cell ceiling.

Official documentation: Get started with BigQuery data in Google Sheets and Analyze and refresh BigQuery data using Connected Sheets.

What the change means for Excel and CSV imports

Google explicitly says the 20 million-cell ceiling applies when importing large datasets from Microsoft Excel (.xlsx) and CSV files. That is useful for Excel workbooks that were previously blocked by the 10 million-cell Google Sheets ceiling.

But there are two different ceilings to keep in mind:

So an Excel or CSV file can theoretically fit within 20 million spreadsheet cells and still encounter an import-size problem for another reason. When that happens with a CSV, Google directs users toward BigQuery and Connected Sheets rather than treating the 20 million-cell announcement as a universal import fix.

Common questions about the new Google Sheets limit

Import-function quotas are documented separately by Google in Learn more about Import functions.

Bottom line

The September 2026 update gives Google Sheets much more room: up to 20 million cells instead of 10 million, including for existing spreadsheets and Excel or CSV imports. But the most useful way to troubleshoot a large-sheet error is still to identify the constraint before trying to fix it.

If the workbook is hitting the grid ceiling, remove unused rows and columns, archive old data, or split the workbook. If the error says a file is too large to import directly, remember that imported file byte size is a different limit and use Connected Sheets with BigQuery for truly large CSV datasets. If the workbook is simply slow, reduce calculation complexity rather than assuming the extra 10 million cells are a performance solution.