You open Google Sheets, and every time you type, the little loading spinner appears and everything freezes. Scrolling feels choppy, and formula results take forever to show up... sound familiar?

Because Google Sheets runs in your browser, it tends to slow down as your file gets bigger. Google announced in June 2024 that it had improved calculation speed by about 2x (Google Workspace Updates Blog), but depending on how you use Sheets, files can still freeze or become painfully slow.

In this article, based on information available as of March 2026, we’ll walk through five common reasons Google Sheets gets slow and the practical fixes you can try right away.

Cause 1: Too Many Cells — Watch the 10 Million Cell Limit

Google Sheets has a limit of “up to 10 million cells per spreadsheet” (Google Drive Help). The closer you get to that limit, the longer it can take just to open the file.

That said, most sheets start feeling slow long before they hit 10 million cells. As a rough guide, once you pass around 50,000 rows, scrolling and calculations often become noticeably slower.

What to do:

  • Select unused blank rows or columns, right-click, and choose “Delete rows” or “Delete columns”
  • Move older data to a separate file and reference it with the IMPORTRANGE function only when needed
  • Split your files by year, month, or another practical time period

Cause 2: You’re Using Too Many Heavy Formulas Like VLOOKUP or ARRAYFORMULA

Some Google Sheets formulas are more expensive to calculate, meaning they take more processing time. The functions below can make a file slow fast when you use them across large datasets.

  • VLOOKUP / HLOOKUP — The larger the lookup range, the slower it gets
  • ARRAYFORMULA — Great for calculating an entire array at once, but heavy when the referenced range is huge
  • IMPORTRANGE — Requires network communication each time it pulls data from another file
  • QUERY — A powerful database-like search function, but it can take time when it’s working through lots of rows
  • INDIRECT / OFFSET — These use dynamic references, which makes it harder for Google to cache calculation results

What to do:

  • Don’t set VLOOKUP ranges to entire columns like “A:Z”; narrow them to only what you need, like “A1:B5000”
  • Limit ARRAYFORMULA references to the actual range where data exists
  • Keep IMPORTRANGE to about 2 or 3 uses per file. If you need more than that, consider copying data with Google Apps Script (GAS) instead
  • If calculated values won’t change, lock them in with “Paste values only” (Ctrl+Shift+V)

Cause 3: You Have Tons of Conditional Formatting or Data Validation Rules

Conditional formatting, which automatically changes cell colors based on rules, can affect performance more than you might expect. As you copy sheets or add rows, similar rules can quietly pile up until you have dozens of duplicates.

Google’s official help also lists cleaning up conditional formatting as one way to improve performance (Google Docs Editors Help, “Improve Google Sheets performance”).

What to do:

  • Open “Format” → “Conditional formatting,” then delete unnecessary rules with the trash icon
  • If multiple rules use the same condition, combine them into one rule
  • Also check “Data” → “Data validation” and remove unused dropdown list rules

Cause 4: Too Many Images, Charts, or Pivot Tables

Images, charts, and pivot tables in a spreadsheet can also slow things down. This is especially true if you’re using the IMAGE function to load images from external URLs, since the sheet has to make network requests every time it opens.

Charts can also slow down recalculation across the entire sheet when they reference very large ranges or when there are lots of charts in the file.

What to do:

  • Keep only the charts you actually need and delete the rest
  • Make pivot table source ranges as small as practical
  • Remove images loaded with the IMAGE function if you don’t need them
  • Move analysis charts to a separate sheet or a separate file

Cause 5: Browser Issues — Cache, Extensions, and Too Many Tabs

Google Sheets is a browser-based app, so browser problems can affect it directly. Google Chrome in particular can use a lot of memory (RAM) when you have many tabs open, which can make Sheets feel slower too.

What to do:

  • Close tabs you aren’t using. Turning on Chrome’s “Memory Saver” feature can also help
  • Clear your browser cache: in Chrome, go to Settings → Privacy and security → Delete browsing data
  • Temporarily disable extensions that might be affecting Sheets
  • Turn on Chrome’s “Hardware acceleration” setting under Settings → System
  • Update your browser to the latest version

3 Last-Resort Fixes When Google Sheets Is Still Slow

If the five fixes above don’t help, try these next steps.

1. Use filter views

When you’re working with a large dataset, go to “Data” → “Create filter view” to show only the rows you need. This reduces how much the screen has to render, which can make the sheet feel more responsive. In simple terms, showing less data can help.

2. Review your Google Apps Script (GAS)

If your spreadsheet uses GAS, which is basically macro-style automation, a trigger might be running frequently and updating the sheet in the background. Go to “Extensions” → “Apps Script” → the clock icon in the left menu (Triggers), then delete any triggers you don’t need.

3. Move to BigQuery or Connected Sheets

If you’re handling business data with more than 100,000 rows, Sheets may simply not be the right place for that much data. If you’re on a paid Google Workspace plan, Business Standard or higher, Connected Sheets lets you work with BigQuery data from the Google Sheets interface.

FAQ

What’s the maximum number of rows and cells in Google Sheets?

As of March 2026, Google Sheets supports up to 10 million cells per file. The maximum number of columns is 26,000, and rows are listed as unlimited, but you can’t exceed the total cell limit.

Will converting the file to Excel make it faster?

Excel’s desktop app runs directly on your computer, so with the same amount of data, it may be faster than Google Sheets. Just watch out for formula compatibility. Google Sheets-specific functions like QUERY and IMPORTRANGE won’t work in Excel.

What if the Google Sheets mobile app is slow?

The mobile app has less processing power than the desktop version, so large files can feel even slower. Try clearing the app cache: Settings → Apps → Google Sheets → Storage → Clear cache.

What should I do if I see a warning that the spreadsheet is very large?

That’s an official warning from Google. You’ll need to lighten the file by deleting unnecessary sheets, rows, and columns, and by cleaning up formulas. If that still doesn’t help, splitting the file is usually the most effective fix.

References