Why this happens
If Sheetgo can't load your Google Sheets source file, it's usually because the file is too large for the Google Sheets API to process in a single read. This article explains what makes a spreadsheet "heavy," how to tell when yours has crossed that line, and what you can do to bring it back.
What is a heavy Google Sheets file?
A spreadsheet becomes heavy when it combines three things:
Large volume of data — hundreds of thousands of rows, or wide tables with many columns.
Complex or volatile formulas — especially functions like
NOW(),TODAY(),RAND(),RANDBETWEEN(), orINDIRECT(), which Google re-evaluates every time the file changes.ARRAYFORMULAover open-ended ranges (likeA:AorB2:B) amplifies the effect across thousands of rows.Heavy formatting — many conditional format rules, lots of colored cells, merged cells, mixed fonts, or styles applied to empty rows below your data.
Any one of these alone is usually manageable. It's the combination that pushes the file past what Google's API can reliably serve.
A clear symptom: open the file in your browser and watch the top-right area above the grid. If you see a thin blue progress bar constantly appearing — or reappearing every time you edit a cell — that's a sign the file is under strain. When multiple users have it open, the strain increases.
How to make your file lighter
Reducing file complexity usually involves addressing data, formulas, and formatting together.
Data volume
Archive old rows into a separate "history" file, keeping only active data.
Delete unused blank rows and columns.
Split one large sheet into multiple files and merge them using Sheetgo.
Formulas
Replace volatile functions with a single reference cell.
Avoid open-ended
ARRAYFORMULAranges (A:A); use bounded ranges (A1:A5000).Replace multiple
VLOOKUPcalls with a singleQUERY()when possible.Prefer
INDEX/MATCHorXLOOKUPover complexVLOOKUP.Convert finalized formulas into static values.
Formatting
Remove unnecessary conditional formatting rules.
Clear formatting from empty rows.
Simplify borders, merged cells, and font styles.
Transfer formatting and Filter by color
Two Sheetgo features can impact performance:
Transfer formatting: Works best with small to medium files. Large files increase API load because reading and formatting are expensive.
Filter by color: Only the background color is needed; remove other styling to reduce load time.
Still stuck?
If the file is still failing after optimization, contact Sheetgo Support at [email protected] for further assistance.