Get stats for your current active sheet and the entire workbook in one place.
By:
Works with:
62K+
Overview
Workbook Statistics: Get stats for your current active sheet and the entire workbook in one place.

Post install tip:
- Refresh the sheet
- Navigate to the 'Add-ons > Workbook Statistics' menu
- Click on 'Get Stats' and wait until the add-on fetches the details
- Re-navigate to the 'Workbook Statistics' option and then hover over any of the 3 available options
- Hit 'Refresh All' to update stats

You can find stats for the following:

> Current Sheet:
	- Sheet Name
	- End of Sheet = Cell reference of where the sheet ends
	- Cells with Data
	- Named Ranges - similar to "Tables" in MS Excel
	- Pivot Tables
	- Cells with Formulas
	- Charts
> Entire Workbook:
	- Count of Sheets
	- Cells with Data
	- Named Ranges
	- Pivot Tables
	- Cells with Formulas
	- Charts

You can always connect with me on Twitter - https://twitter.com/schoraria911 or reach out by using any of the following medium.

Useful links:
- Application homepage: https://script.gs/workbook-statistics/
- Privacy policy - https://script.gs/workbook-statistics-privacy-policy/
- Contact details - https://script.gs/contact/
Additional information
PricingNot available
Developer
Trader status unspecified
Support
Privacy policy
Terms of service
ReportFlag as inappropriate
Workbook Statistics will ask for the permissions shown below. Learn more
Workbook Statistics will need access to your Google account
This will allow Workbook Statistics to :
View and manage spreadsheets that this application has been installed in
See your primary Google Account email address
See your personal info, including any personal info you've made publicly available
Reviews
Language:
Sort by:
Google doesn't verify reviews or ratings. Learn more about reviews
Profile Picture
A User of Workbook Statistics
February 2, 2020
Worked beautifully and quickly in counting sheets, formulas, and active cells. Where can I use such information? I recently created a communication log system for a school district. Aside from the lines of GAS script and HTML, there were a number of formulas, including query functions, that were quick, but grotesque in complexity. Using this add-on, I'm able to defend the reasonable price for creation and simplicity of the overall design. 👍👍👍👍
Is this review helpful?
Yes
No
Profile Picture
Yagisanatode -Scott-
April 10, 2022
For a stats nerd, I really enjoyed accessing my Google Sheets stats at my fingertips.
Is this review helpful?
Yes
No
Profile Picture
A User of Workbook Statistics
February 2, 2020
Unlike the other add-ons that I use, this one is non-intrusive and I also was able to get permission at work quite easily because it makes use of very minimal permissions. Given the level of security risks our G Suite admin is allowed to take, we get to very thoroughly vet what tools can be used and what cannot. Plus, it helped that the code is open-sourced too.
Is this review helpful?
Yes
No
Profile Picture
A User of Workbook Statistics
February 2, 2020
Love the interface. Wish it had some auto-update features but given the restrictions, this tool is the closest of what Microsoft offers. Maybe Google should provide this option as a built-in feature instead.
Is this review helpful?
Yes
No
Profile Picture
Jojo duan
June 8, 2021
not working, waste of time
Is this review helpful?
Yes
No
Profile Picture
A User of Workbook Statistics
February 3, 2020
We've outsourced much of our data entry tasks to external vendors and part of their KPI is to be able to populate x # of rows and columns. For the most part, we used to count those manually but this add-on has helped with having those calculations made pretty easily.
Is this review helpful?
Yes
No
Profile Picture
A User of Workbook Statistics
January 31, 2020
What a piece of dookie! This was the worst app every. I couldn't even get it to work. 10 thumbs DOWN!
Is this review helpful?
Yes
No
Profile Picture
A User of Workbook Statistics
February 17, 2020
Classy! Loved the emojis :D
Is this review helpful?
Yes
No
Profile Picture
A User of Workbook Statistics
February 8, 2020
Wish things were a little more dynamic
Is this review helpful?
Yes
No
Profile Picture
A User of Workbook Statistics
February 6, 2020
My workbook has 37 sheets and 348121 total cells with data and it took only about 11.2 seconds to grab all the data. Freaky!
Is this review helpful?
Yes
No
1-10 of 11
Search
Clear search
Close search
Google apps
Main menu