Google sheets max cells limits and mitigations

Question

I'd read online that Google sheets has a max cell limit of 5 million cells. A sheet that I'm currently working on has well and above passed that limit (including blank cells).

1. What is the new limit?
2. Also I'd manually checked how many cells I was using. Is there any function or script that I can use to keep a check?
3. The sheet I'm working on is going to only get bigger and it's already lagging heavily. I'd love some suggestions on which platform I could move to next to handle such big data. There are so many options, it's mindboggling. I use Google sheets mainly for it's ease in collaboration, presentability and ease of use. Any other tool with these traits but with an ability to handle bigger data?

Answer 1

1. in the early years, it was 5 million cells. last year this was upgraded to 10 million cells

   you can follow updates at: https://workspaceupdates.googleblog.com/search/label/Google%20Sheets

2. try:

   

3. take a look on Google DataStudio