There are size limits to documents, spreadsheets, and presentations you create and upload. For example, you can’t view files larger than 5 TB in Google Drive.
Size: Up to 1,024,000 characters, regardless of the number of pages or font size. A document that is converted to Google Docs can be up to 50 MB.
Size: Up to 2 million cells.
Size limits also apply to spreadsheets that collect form responses (for example, if you send a survey). The number of questions in your form and the number of cells with other data count toward your limit.
Google spreadsheets have complexity limits. Every time a cell is updated, any cell that references it is recalculated. If formulas become too complex or take too long to calculate, the spreadsheet will timeout during calculation.
Formulas that increase the complexity of a spreadsheet include:
- VLOOKUP, QUERY, SUMIF, and similar formulas that take a large range of cells as input.
- Volatile formulas (for example, NOW, RAND, OFFSET, INDIRECT) are recalculated every time the spreadsheet is modified. If there are a large number of formulas that depend on cells with volatile formulas, they will be recalculated on each edit, which may slow down a spreadsheet.
- Import-based formulas (e.g., IMPORTRANGE) are recalculated periodically and increase complexity.
You’ll see a warning message if a spreadsheet is becoming too complex. This warning means that formulas may start to display errors or take a long time to calculate if you make your spreadsheet more complex. To remove this warning, reduce complexity in the spreadsheet using the tips below.
To reduce complexity in a spreadsheet:
- Break up a large spreadsheet into different smaller spreadsheets.
- Minimize the number of complex formulas. See the list above for functions that increase complexity.
- After getting data points through any complex formula, copy and paste them as "values only."
- Select the values and copy them.
- Go to the Edit menu.
- Point your mouse to "Paste special."
- Select Paste values only.
- Minimize the number of cells that depend on:
- A large number of other cells.
- Cells with complex formulas.
- Cells that are changed frequently.
Size: Up to 100 MB for presentations created in Google Slides and presentations that are converted to Google Slides.
Size: We’ve never seen anyone make a drawing that was too big (but that’s not a dare).
Size: Up to 5 TB for files uploaded but not converted to Google Docs, Sheets, or Slides.
Reduce file size
To reduce file size and save disk space, compress images in your document (image details and dimensions may decrease).
Mary is a Docs & Drive expert and author of this help page. Leave her feedback below about the page.