1

I know that Google sheets has a 2 million cell limit.

https://support.google.com/drive/answer/37603?hl=en

but was wondering is there a limit to the number of sheets? the old google sheet has this limit. https://www.quora.com/What-are-the-limits-of-Google-Sheets

I can't seem to find any references on the limits for the new google sheet except that 2 million cell limit.

|improve this question
  • I was able to make 750: webapps.stackexchange.com/a/59952/29140 – Jacob Jan Tuinstra Mar 9 '17 at 19:42
  • @JacobJanTuinstra Have you tried modifying your code to generate more? Maybe by appending additional sheets for a second run if you hit the run time limit, and reducing the number of cells in each sheet? At 26 Columns and 100 rows, you will hit the cell limit at 769 sheets. – Karl_S Mar 10 '17 at 13:27
0

There is no reported limit outside the number of cells. There is a limit of 50000 characters in a cell, easily tested by trying to add more, so other limits may be found which are not listed.

There are also limits inferred by taking the cell limit into account. Meaning 2 million 1 cell sheets, or 2 sheets at 1 million cells.

|improve this answer
0

Today, i have a SpreadSheet with 1200 Sheets. Each Sheet have one cell (1 row and 1 column). Therefore, if the limit of cell is 5 millions ... maybe it can give an idea, or not.

|improve this answer

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.