DEV Community

Cover image for Workbook Statistics - Google Spreadsheet Add-on
Sourabh Choraria
Sourabh Choraria

Posted on

Workbook Statistics - Google Spreadsheet Add-on

Workbook Statistics - Get stats for your entire Google Spreadsheet in one place. | Product Hunt Embed

Get stats for your current active sheet and the entire workbook in one place.

Finally! Its live on the G Suite Marketplace 🎉

Would love for some of you to critique it so I can improve 😅 will soon put out the code on GitHub and open-source this + also share a post on the entire process.https://t.co/5koer6xQt2 pic.twitter.com/goyRZFYEoJ

— Sourabh Choraria (@schoraria911) January 10, 2020

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 to share any suggestions or feedback as well!

Top comments (0)