Google Sheets 10 million cell limit checker (now 20 million)

Google raised the limit from 10 million to 20 million cells per spreadsheet in September 2026. It covers new, existing and imported files, and there is no setting to turn on.

• Rapid Release accounts: rollout from September 10, 2026.
• Scheduled Release accounts: rollout from September 28, 2026.
• Personal Google accounts: included.

Each rollout could take up to 15 days to reach every account. The limit is for the whole spreadsheet, so every tab is added together.

• Rows: open the tab and scroll to the bottom. The last row number is the row count.
• Columns: scroll right to the last column. Type its letter (for example AN) and the tool turns it into a number.
• Growth: for a tab that keeps getting new rows, open it and choose File > Download, then CSV. Drop the file in step 2 and pick the date column.

Empty rows and columns at the edge of a tab are part of its grid, so count to the very end.

• Cells in a tab = rows x columns.
• Cells in the file = the cells in every tab added together.
• Share used = cells in the file / the limit (20,000,000).
• New cells a month = for each tab, new rows a month x that tab’s columns, added together.
• Months left = (limit - cells in the file) / new cells a month.

Column letters count A = 1, Z = 26, AA = 27, AZ = 52 and ZZ = 702. From a CSV, new rows a month is the average of the last three full months. The last month in the file is left out because it may be partial, and a month with no new rows counts as zero.

Example: a tab with 182,000 rows and columns A to AN (40 columns) holds 7,280,000 cells. If 4,200 rows land there each month, it adds 168,000 cells a month.

• Delete empty edges. Right-click the empty columns or rows past your data and choose Delete column or Delete row. Each column removed frees as many cells as the tab has rows.
• Archive closed years. Copy last year’s rows into a separate spreadsheet, then delete them here.
• Give growing tabs their own file. A tab that a form or another app writes to every day can live in its own spreadsheet.

Moving tabs can break formulas that point at them. Our field guide on Google Sheets reports that break when a column changes shows how to make those links sturdier. If one person holds the whole file in their head, start with the spreadsheet only one person understands.