While Google Sheets was originally envisioned as a Microsoft Excel replacement, it ended up being something more than that. Indie developers took advantage of the open API to build a number of Google Sheets add-ons that enhance its functionality in a number of ways. While there are hundreds of add-ons for Google Sheets and covering all of them is impossible, I do have a list of some of the best Google Sheet add-ons for you to check out.
Also Read: How to Combine Cells in Google Sheets
Google Sheets Add-ons
1. Power Tools
Let’s begin with an add-on that bundles a number of tools to help you be more productive. Power Tools will remove duplicates, find vlookups, merge or split cells, import data from other sheets, find and replace data in cells including formulas, compare data, add text or capitalize it, clear cell data by type and so much more.
Power Tools is a powerful suite of add-ons for Google Sheets that need to have whether you are a regular or a pro user of the Google Sheets. Useful for repetitive tasks. There is an annual subscription that unlocks more tools.
Download Power Tools: Google Sheets
2. Email Address Extractor
Chances are that you are also using Gmail and/or Gsuite to send and receive emails. Email Address Extractor Google Sheets add-on will collect all email IDs based on your criteria and save them in a sheet. You can choose to save email IDs from To, From, CC, BCC, and even body field.
The free version will work until 250 email IDs have been extracted. None of this data will be uploaded anywhere.
Download Email Address Extractor: Google Sheets
What are Google Sheets without a way to analyze all the data collected statistically? Nothing. XLMiner is one of the best Google Sheets add-ons that offers 19 Excel features that you were missing in Google Sheets. Some of them are covariance, ANOVA, correlation, histogram, moving average, exponential smoothing, sampling, and more.
XLMiner is a must-have for those who like to manage or manipulate data around to arrive at meaningful conclusions. It’s the same add-in that you loved and used in Excel.
Download XLMiner: Google Sheets
Doctopus was designed with teachers in mind which is why it comes with a handy feature. You can now handout specific documents in Google Drive to one or more specific students. Once a doc has been shared, you can track progress, comment, and revoke permissions as you deem fit.
Designed by a science teacher, Doctopus allows you to follow the workflow to the T, allowing you to manage, track, assess, and record tasks remotely.
Download Doctopus: Google Sheets
5. Google Analytics
Google Analytics is how you understand and crunch all the site data. Google Analytics for Google Sheets add-on will allow you to further manipulate these metrics to arrive at better conclusions. You can also use this add-on to retrieve data and take regular backups of your site data.
Once data has been queried and cells have been populated, you can sort or filter this data by CTC, clicks, impressions, position, and so on. Go on, try it now.
Download Google Analytics: Google Sheets
6. Template Gallery for Sheets
As the name suggests, this Google Sheets add-on is a gallery of templates that you can use based on the type of data you are working with. Some examples include invoices, calendars, timesheets, job work, letters, resumes, and so on.
What’s cool is that the same add-on will also work with Google Docs and offers a ton of templates for that too. A must-have Google Sheets add-ons if you are a Google Sheets and Docs user.
Download Template Gallery for Sheets: Google Sheets
Autocrat comes with a number of templates that you can use to merge data from spreadsheets into a document. That makes it easier to share these documents with relevant data from Google Sheets using Autocrat add-on. Autocrat can handle a large number of documents and generate them automatically.
Templates also include the ability to use Slides. You can also generate PDF files if need be. Selecting cells ie easy and the interface has been made simple.
Download Autocrat: Google Sheets
Flubaroo was developed for teachers who want to grade students based on answers to multiple-choice questions and forms. It is a Google Sheets add-on as much as a Google Form one. Grade students, give them scores and feedback, help them get better and improve, identify patterns in questions that were answered or not the most, and so much more.
Once you are done, it’s easy to share the results via email or cloud using other Google apps like Drive and Gmail. You can automate the scoring and grading process by entering the correct answers that stay hidden until the quiz is complete.
Download Flubaroo: Google Sheets
9. Lucidchart Diagrams
Lucidchart is probably the most powerful Google Sheets add-ons there is when it comes to creating charts, diagrams, mockups, ERDs, and more. You can create pretty much any type of chart with this add-on and then collaborate with your peers in real-time.
It comes with enterprise-level security with encryption and lockdown features. It’s a visual collaboration tool to makes sense of data, all packed into an easy-to-use UI. Lucidchart integrates with a number of third-party apps, so you can export data easily.
Download Lucidchart Diagrams: Google Sheets
Google Sheets Add-ons
There are hundreds of Google Sheets add-ons on the G Suite Marketplace and listing all of them, even all of the good and useful ones is beyond the scope of this article. You should begin with this list and then take it from there. That should put you in the right direction. Even better, you can share your favorite add-ons in the comments below to help everyone else.