Google Sheets Cell Limit: Max Cells, Rows & Columns (2026)
A single Google Sheets spreadsheet can hold up to 10 million cells. That ceiling was raised from 5 million in 2022, and it applies to the total number of cells across every tab in the workbook — not per sheet. You can also have at most 18,278 columns (column ZZZ), whichever limit you hit first.
The Limits at a Glance
Cells, rows & columns
- Max cells: 10 million cells total per spreadsheet, counted across all tabs.
- Max columns: 18,278 columns, ending at column ZZZ.
- Rows: a new blank sheet defaults to 1,000 rows × 26 columns (26,000 cells), but there is no fixed row cap — rows are limited only by the 10-million-cell total. With a single column, that works out to 10 million rows.
Other limits
- Excel and CSV imports: up to 10 million cells or 18,278 columns — the same caps as native Sheets.
- Per-cell text: any cell with more than 50,000 characters is removed when an Excel file is converted to Sheets.
The Cap Is Total Cells Across All Tabs
The most common misconception is that each tab gets its own 10-million-cell budget. It doesn’t. The 10-million-cell limit is for the entire spreadsheet, so a workbook with twenty tabs splits that same pool among all of them.
This is also why those default blank tabs matter. Every new sheet starts with 1,000 rows × 26 columns = 26,000 empty cells, and even empty cells count toward the total. If you keep adding tabs or extending rows far beyond your data, you can hit the wall well before you’d expect. Deleting unused rows, columns, and tabs reclaims that budget.
How to Work With More Data
- Connect to BigQuery with Connected Sheets. Instead of loading raw rows, Connected Sheets queries billions of rows in BigQuery and only pulls summaries into the sheet, so you stay under the cell cap.
- Split the data across multiple files. Break one giant spreadsheet into several smaller files by date, region, or category, then reference them with
IMPORTRANGE. - Move to a real database. If you’re routinely brushing 10 million cells, a database (Postgres, MySQL, or BigQuery) is the right home; use Sheets as the reporting layer on top.
- Trim empty rows and columns. Select and delete unused rows/columns rather than leaving thousands of blank cells eating into the total.
- Archive old tabs. Export historical tabs to separate files so the live workbook keeps room to grow.
Troubleshooting
How many cells can Google Sheets hold?
10 million cells total per spreadsheet, counted across all tabs combined — not per sheet.
What is the maximum number of rows in Google Sheets?
There’s no fixed row limit. Rows are bounded only by the 10-million-cell total, so a single-column sheet can reach 10 million rows, while a 26-column sheet tops out around 384,615 rows.
What is the maximum number of columns?
18,278 columns, ending at column ZZZ — though you’ll usually hit the 10-million-cell cap first if you have many rows.
Did Google raise the cell limit?
Yes. The cap was 5 million cells for years and was raised to 10 million cells in 2022. Excel and CSV imports share the same 10-million-cell limit.
Quick Reference
| Limit | Value |
|---|---|
| Max cells (total, all tabs) | 10 million |
| Max columns | 18,278 (column ZZZ) |
| New blank sheet default | 1,000 rows × 26 columns |
| Max rows (single column) | 10 million |
| Excel / CSV import cap | 10 million cells |
| Per-cell text on Excel import | 50,000 characters |
Staying under the cell cap is mostly about housekeeping — trimming empty rows, archiving old tabs, and keeping spreadsheets from sprawling. Carly is an AI executive assistant that works in your inbox and calendar and connects to Google Sheets, so it can append rows, pull data into the right tab, and keep your reporting sheets tidy without you babysitting them. It starts at $35/month.
Related guides: Best AI Agents for Productivity
Ready to automate your busywork?
Carly schedules, researches, and briefs you—so you can focus on what matters.
See what people say
"Before Carly, I relied on a Calendly link, but the whole process felt impersonal and not very professional. Carly changed that by handling all the back-and-forth, so I'm no longer stuck in endless email threads trying to line up schedules.
Now Carly reaches out to candidates, shares my real-time availability, lets them pick a slot, then sends a Zoom link and drops it straight into my calendar. She sends reminders to both of us before each call, which has significantly reduced no-shows and last-minute confusion.
On top of scheduling, Carly acts like a full executive assistant, sending me my schedule the night before so I can prepare for each call. It reminds me of the old x.ai assistant, but Carly is noticeably smarter, faster, and better suited to my healthcare recruitment business."
