Google Sheets limits: 20 million cells, 100MB files, 10MB IMPORTRANGE

Google Sheets now allows up to 20 million cells per spreadsheet, double the previous 10 million, and the same Google Drive help page lists a ceiling of 100MB for spreadsheets created in or converted to Sheets. Google made the higher cell limit generally available in September 2026 for all Google Workspace customers, Workspace Individual subscribers and personal Google accounts, and it applies to new, existing and imported files without any admin or user setting.
The cell limit is only one of several ceilings an analyst meets when a spreadsheet grows into a shared reporting tool. IMPORTRANGE is capped at 10MB of received data per request, the Import functions refresh on an hourly cycle, Connected Sheets has its own row and cell limits for BigQuery extracts, and the Google Sheets API enforces per-minute quotas on every script or integration that reads or writes the file. All figures below were checked on Google's official help, developer and Workspace Updates pages on November 20, 2026.
A team that hit the old wall at 10 million cells can now hold twice as much data in one file. The limit is set per spreadsheet, so every tab in a workbook draws on the same 20 million cell budget, and a file with several large tabs reaches the ceiling sooner than its biggest table suggests.
··········
GOOGLE SHEETS FILE LIMITS: CELLS, FILE SIZE AND CONVERSION.
The reference for spreadsheet size is the Google Drive help page on files you can store in Drive. It lists "up to 20 million cells or 100MB for spreadsheets that are created in or converted to Google Sheets." Both conditions apply, so a file with fewer than 20 million cells can still be refused on import if the source file exceeds 100MB.
The Workspace Updates post of September 10, 2026 confirms that the cell limit "increased from up to 10 million cells to up to 20 million cells" and that the limit "applies to new, existing, and imported files." The same post says Google plans to raise the file byte size limit for imported spreadsheets and labels that change as coming soon, without a number. Until Google publishes a new figure, 100MB remains the documented ceiling for converted files.
Excel conversion has one more documented rule. When a workbook is converted from Excel to Google Sheets, any cell with more than 50,000 characters is removed. The help page does not give a general per-cell character limit for native Sheets files, and none of the official pages checked for this reference published a per-sheet row or column limit on the day of verification.
........
Limit | Value | Official source |
Cells per spreadsheet | Up to 20 million | Drive help, Sept 2026 GA post |
File size (created or converted) | Up to 100MB | Drive help |
Excel cell text on conversion | Cells over 50,000 characters removed | Drive help |
Connected Sheets pivot tables | Up to 200k rows | Drive help |
Connected Sheets extracts | Up to 500k rows or 5m cells | Drive help |
IMPORTRANGE data per request | 10MB received | IMPORTRANGE help |
Sheets API reads | 300 per minute per project, 60 per user | Sheets API limits |
Sheets API writes | 300 per minute per project, 60 per user | Sheets API limits |
Sheets API request timeout | 180 seconds | Sheets API limits |
........
··········
THE 20 MILLION CELL LIMIT ROLLOUT AND WHO HAS IT.
Google first announced the doubled limit on April 22, 2026 as a beta. Admins had to register their organization through a form, registrations were processed in waves, and domains received a confirmation once they were allowlisted. The same April post introduced performance work for large files: spreadsheets with more than 1 million cells open and start up to 30% faster, and filtering and conditional formatting on large spreadsheets run up to 60% faster.
General availability followed in September. Rapid Release domains started receiving the change on September 10, 2026 and Scheduled Release domains on September 28, 2026, each with a gradual rollout of up to 15 days for feature visibility. Google states that there is no admin control and no end-user setting, and that the expanded limit applies automatically when users create, expand or import spreadsheets. By late October every eligible account should therefore have the 20 million cell limit.
··········
IMPORTRANGE AND IMPORT FUNCTION LIMITS IN GOOGLE SHEETS.
IMPORTRANGE is the usual way to pull a range from one spreadsheet into another, and its help page sets the main ceiling: the function "is capped at 10MB of received data per request," and Sheets downloads the entire referenced range. Narrowing the range to the columns a report actually needs is the most direct way to stay under the cap. Google does not publish how many bytes a cell occupies, so the safe approach is to test the real range rather than estimate it from row counts.
The refresh behavior is documented as well. IMPORTRANGE checks for updates every hour while the document is open, reloads when a document is first opened or was opened within the past five minutes, and any update to the source causes all open receiving documents to refresh. Google advises limiting chains of IMPORTRANGE across multiple sheets, avoiding cycles and limiting the number of receiving sheets, because each one must read from the source. Access granted through IMPORTRANGE counts against the 600-user share limit of the source sheet, and if the source has the option to disable download, print and copy turned on, new IMPORTRANGE formulas cannot export its data.
IMPORTDATA, IMPORTHTML and IMPORTXML follow a similar cycle. Google states that they check for updates every hour while the document is open and that opening or refreshing the document does not trigger a refresh. The quota for these functions is enforced on the document creator across all open documents that person created, and the documented error message asks users to reduce the number of IMPORTHTML, IMPORTDATA, IMPORTFEED or IMPORTXML functions. Google gives no numeric cap on the number of these functions, and Import functions cannot reference NOW, RAND, RANDARRAY or RANDBETWEEN.
For large one-time loads, Google's guidance on data ingestion recommends File > Import or Connected Sheets instead of copy and paste, which it suggests only for a few hundred rows. A file that is too big triggers the message "This file is too large to import directly into Google Sheets." The site's guide on analyzing a CSV over ChatGPT's 50MB limit covers the chunking approach for files that exceed spreadsheet limits.
··········
[[ADPLUS_300x250_1]]
GOOGLE SHEETS API QUOTAS FOR SCRIPTS AND INTEGRATIONS.
The Google Sheets API usage limits page, last updated September 3, 2026, sets per-minute quotas that refill every minute: 300 read requests per minute per project and 60 per minute per user per project, with the same figures for write requests. Exceeding them returns a 429 error, and Google recommends exponential backoff with a maximum backoff of typically 32 or 64 seconds. There is no daily limit as long as the per-minute quotas are respected.
Two other documented rules shape integration design. A batch request, including all its subrequests, counts as one API request, and any request that Sheets processes for more than 180 seconds returns a timeout error. The API has no hard size limit per request, but Google recommends a maximum payload of 2MB. Standard use is available at no additional cost, and the page states that exceeding the quota request limits is planned to incur charges to the Google Cloud billing account later in 2026, without publishing a rate.
Connected Sheets has separate limits because the data stays in BigQuery: up to 200k rows for pivot tables and up to 500k rows or 5m cells for extracts. The site's reference on Connected Sheets for BigQuery limits and query costs explains how those queries are billed.
··········
SIZING A GOOGLE SHEETS WORKBOOK AGAINST THE 20 MILLION CELL LIMIT.
The example below is illustrative. A sales operations team keeps three tabs in one workbook: an orders table, a customer table and a small lookup table. Every figure was computed in Python.
........
Tab (illustrative) | Rows | Columns | Cells |
Orders | 480,000 | 25 | 12,000,000 |
Customers | 60,000 | 18 | 1,080,000 |
Lookup | 2,000 | 6 | 12,000 |
Total | 13,092,000 |
........
The workbook uses 65.5% of the 20 million cell limit. Under the old 10 million limit the same file would have been at 130.9% and could not have existed as one spreadsheet. The remaining headroom is 6,908,000 cells, which at 25 columns equals 276,320 more order rows. A 25-column table can hold at most 800,000 rows in an otherwise empty spreadsheet; at 12 columns the ceiling is 1,666,666 rows, and at 40 columns it is 500,000.
Because the three tabs share one budget, moving the customer table to its own spreadsheet would free 1,080,000 cells for orders. The same orders table pulled through a Connected Sheets extract would hit the 5m cell ceiling first: at 25 columns that allows 200,000 rows, below the 500k row limit.
The API side of the example follows the same arithmetic. A nightly script that writes 500 separate ranges one request at a time needs 9 minutes at the quota of 60 write requests per minute per user, while the same 500 updates sent as one batch request count as a single request. The pandas logic for the cell count is short enough to rerun on any workbook inventory:
import pandas as pd
tabs = pd.DataFrame({
"tab": ["Orders", "Customers", "Lookup"],
"rows": [480_000, 60_000, 2_000],
"cols": [25, 18, 6],
})
tabs["cells"] = tabs["rows"] * tabs["cols"]
total = tabs["cells"].sum()
print(total, round(100 * total / 20_000_000, 1))
print((20_000_000 - total) // 25)For pivot work on tables of this size, the guide on building pivot tables with Gemini in Google Sheets and checking totals shows how to verify the output, and the guide on QUERY and ARRAYFORMULA formulas with Gemini covers formulas that summarize large ranges without copying them.
··········
GOOGLE SHEETS LIMITS: WHAT IS DOCUMENTED AND WHAT TO TEST.
Google documents the core numbers clearly: 20 million cells per spreadsheet for every account type since the September 2026 rollout, 100MB for spreadsheets created in or converted to Sheets, removal of cells longer than 50,000 characters when converting from Excel, 10MB of received data per IMPORTRANGE request, and Sheets API quotas of 300 requests per minute per project and 60 per user per project for both reads and writes.
Several points are not fixed in the documentation. Google has announced a higher byte limit for imported spreadsheets without a number or date, has said that exceeding API quotas will be charged later in 2026 without a price, and does not publish numeric caps for the number of Import functions or per-sheet row and column limits on the pages checked. Teams that run large shared workbooks should count cells per tab, narrow every IMPORTRANGE to the columns a report needs, batch API writes, and move tables that keep growing toward Connected Sheets and BigQuery before the workbook reaches the 20 million cell ceiling.
··········
FOLLOW US FOR MORE.
·····
DATA STUDIOS
·····
datastudios.org




