The 10 Best Google Sheets Add-Ons Menu Lifewire Tech for Humans Newsletter! Search Close GO Software & Apps > Google Apps

The 10 Best Google Sheets Add-Ons

Make your spreadsheets amazing!

By Jerri Ledford Jerri Ledford Writer, Editor, Fact Checker Western Kentucky University Gulf Coast Community College Jerri L. Ledford has been writing, editing, and fact-checking tech stories since 1994. Her work has appeared in Computerworld, PC Magazine, Information Today, and many others. lifewire's editorial guidelines Published on April 28, 2020 Tweet Share Email Tweet Share Email Google Apps Sheets Docs Slides Just like Chrome browser add-ons, Google Sheets add-ons offer a great way to extend the functionality of the Sheets program. They can do everything from helping you remove duplicates to quickly processing mail merges, and pulling data from other sources into your sheet. We reviewed dozens of them to pull together a list of the best Google Sheets add-ons for all your needs.

How to Add Google Sheets Add-Ons

If you've never used add-ons before, don't be discouraged. You can add these little extensions to Sheets with a few quick clicks. Start from within an open spreadsheet and, from the menu bar, select Add-ons. Then, click Get Add-ons in the menu. Browse through the list, and when you find one you want to use, click Install. 01 of 10

Best for Fast and Easy Mail Merge Yet Another Mail Merge

What We Like Simple, easy interface. Import contacts from Google Contacts or HubSpot. Message templates available. Useful for more than just marketing emails. What We Don't Like Limited to 50 free messages per day. Yet Another Mail Merge (YAMM) is one of the top-rated mail merge add-ons for Google Sheets with good reason. It lets you send up to 50 emails per day for free, and you can create the email in Gmail and then pull it into the mail merge very easily. YAMM also offers real-time tracking on the messages you send, so you can quickly see if your message was delivered and who opened it. Get YAMM 02 of 10

Best for Reporting Supermetrics

What We Like Pulls data from a variety of sources, including Google Analytics, AdWords, and other non-google systems. Schedule automatic report creation. 14-day trial with full functionality. What We Don't Like The monthly subscription price is prohibitive for light users. Reporting updates and functionality limited by subscription level. If it's your responsibility to create reports for web analytics, social media, or online marketing, then Supermetrics is the tool you want in Google Sheets. This add-on can pull data from a variety of places, and provides free templates to help you create a professional version of the exact report you need. Get Supermetrics 03 of 10

Best With Fillable PDF Documents PDFfiller

What We Like Easily to complete fillable PDF document. Quickly create fillable PDF documents. One-click data merge. 30-day free trial period. What We Don't Like Users report the add-on is a little buggy. Month-to-month subscription is expensive. PDFfiller for Google Sheets lets you quickly fill out PDF forms using spreadsheet data so there's no need to copy and paste from your spreadsheeting into a PDF document. Users can also automate the process with a data merge and protect and share documents easily. Get PDFfiller 04 of 10

Best to Quickly Cleanup Sheets Crop Sheet

What We Like Can use data or selection for cropping limits. Does exactly what it claims to do—remove empty cells. What We Don't Like Performs only the single function. It's a simple thing, but having the ability to quickly delete unused columns and rows in a spreadsheet is more useful than you might imagine. By default, Google Sheets displays 26 columns and 1000 rows, and it's not uncommon to have any of them left blank. Crop Sheet allows you to quickly clean up your spreadsheets so all that unused space doesn't muck things up. Get Crop Sheet 05 of 10

Best for Finding Email Addresses Hunter for Sheets

What We Like Find publicly available email addresses without leaving Sheets. Free for 50 searches per month. What We Don't Like If you need more than 50 searches per month, the monthly fee can be steep. Some functionality limited for free accounts. If you've ever tried to find an email address for a contact at a specific domain name, you know it's not always an easy task. Hunter for Google Sheets aims to make it easier. Use this add-on from within Google Sheets to find a list of email addresses that meet specific parameters. The address are returned with a confidence score to help you determine if they're worth using. Get Hunter 06 of 10

Best for Quickly Changing Text Case ChangeCase

What We Like Easily change character case in numerous ways. Very fast on smaller documents. What We Don't Like Limited functionality. Can be slow on large spreadsheets. It can be tedious if you need to go through a large spreadhseet and change the case of text in a number of cells. ChangeCase can automatically change characters to all uppercase, all lowercase, first letter capitalized, and more. Get ChangeCase 07 of 10

Best for Teachers Who Manage Student Projects Doctopus

What We Like Automatically copy, distribute, and share files with a roster of students. Permissions can be managed automatically or granularly. Includes rubric view. What We Don't Like Rubric view can become cumbersome. Steep learning curve. For teachers that manage student projects, Doctopus offers a functionality you may not find elsewhere. This handy little plug in can automate the distribution of assignments to your students and keep track of their activity during the project. The Goobric add-on for Google Sheets is a great companion to Doctopus that also attaches rubric-based grading capabilities to your tracking and management workflow. Get Doctopus 08 of 10

Best for Managing Finances Bkper

What We Like Simple, but robust accounting tool. Connections to 10,000+ banks and credit cards. Attach files and pictures to transactions. What We Don't Like Bkper files are difficult to locate in Google Drive. Cannot connect to your bank without premium subscription. Bookkeeping and finance programs can be complicated, but Bkper aims to make them simpler. This handy add-on helps you manage your personal, household, or business finances. It uses bots to automate some functions and allows for collaboration with other people. The real-time dashboards also help you get a clearer picture of your finances in real time. Get Bkper 09 of 10

Best to Remove Dupes Remove Duplicates

What We Like Quickly removes duplicate entries in spreadsheets. Highlight duplicate rows. Pro version requires low one-time purchase. What We Don't Like Free version limited to one search per day. Limited support for free users. Duplicate data in a spreadsheet can create havoc, and it can be difficult to find and remove. If you often need to de-dupe your Google Sheets, Remove Duplicates is a simple add-on that does exactly that. Get Remove Duplicates 10 of 10

Best for Scraping Website Data ImportFromWeb

What We Like Fast way to scrape data from a website. Uses proxies and emulators to increase number of accessible websites. Faster than default IMPORTXML capability. What We Don't Like Limited to 500 requests every 6 hours. Sites can block the scraper from gathering data. If you have need to pull all the data from a website (e.g. for pulling price comparisons or competitive reviews), you've probably used IMPORTXML in the past. There's an easier way. ImportFromWeb is easy to use and doesn't encounter the slow downs that often plague IMPORTXML. Get ImportFromWeb Was this page helpful? Thanks for letting us know! Get the Latest Tech News Delivered Every Day Subscribe Tell us why! Other Not enough details Hard to understand Submit More from Lifewire How to Search in Google Sheets The 10 Best Google Drive Add-ons for 2022 How to Remove Duplicates in Google Sheets How to Put a Spreadsheet in Google Slides How to Highlight and Find Duplicates in Google Sheets 10 Best Free Email Accounts for 2022 How to Use Google Sheets The 10 Best Road Trip Planner Apps for 2022 The 10 Best Password Managers of 2022 How to Convert Excel Documents to the PDF Format 21 Best Places to Get Free Kindle Books (October 2022) How to Save a Google Spreadsheet to Desktop ODS File (What It Is & How to Open One) 17 Best Free Cloud Storage Services for Backup in 2022 How to Add, Hide, Freeze, or Remove Columns in Sheets 10 Best PDF Splitter Tools & Methods Newsletter Sign Up Newsletter Sign Up Newsletter Sign Up Newsletter Sign Up Newsletter Sign Up By clicking “Accept All Cookies”, you agree to the storing of cookies on your device to enhance site navigation, analyze site usage, and assist in our marketing efforts. Cookies Settings Accept All Cookies