If you feel that Google Sheets can’t get any better, you’ve come across an add-on that will make your job a little easier.
At least that’s what it’s felt like to me over the years as I’ve discovered add-ons that help streamline processes and get SEO tasks done faster.
The basics first
Excel has long been the go-to place for SEO pros, but Google Sheets is growing in popularity partly because of its robust add-ons and ease of sharing.
If you’re new to Google Sheets, here’s a quick guide on how to get add-ons involved (if you’re a Google Sheets pro, you should skip this section).
Open a blank sheet in Google Sheets to access add-ons.
Then click on Add-ons as shown in the screenshot below.
When you’re ready to add them, just click Get add-ons in the drop-down menu.
Some of the add-ons I’ll mention in the next section require additional installation steps. So be sure to follow the instructions for each add-on.
advertising
Read on below
Google Sheets add-ons for SEO
Below is a list of helpful Google Sheets add-ons for SEO.
Some have overlapping features so you probably won’t need all of them.
Instead, try them out and choose what works best for you.
1. Search Analytics for leaves
Search Analytics for Sheets continues to be one of my go-to places when using Google Sheets.
It will sync with your verified websites in the Google Search Console and pull query, page and click data into your spreadsheet.
What is special about this add-on is that you can filter dates by query, country, page or device and select custom date ranges.
You can also view and sort clicks, impressions, click rate, and position.
You can also set up automatic backups right in Google Sheets.
2. Google Analytics
The Google Analytics add-on is great for running reports and creating data visualizations.
advertising
Read on below
Within the add-on you have the option of doing one of the following:
Start with Create a new report This allows you to customize the metrics that you want to get.
Then click on Run reports.
You can combine data and create your own charts as shown in the following screenshot of the Google Analytics add-on.
There is a video tutorial for this add-on that is a few years old and provides applicable steps for creating and running reports, as well as incorporating charts and other visualizations.
advertising
Read on below
3. Supermetry
Supermetrics has a lot going for it just outside of SEO data.
Just check out the quick screen below which shows all of the latest integrations.
This add-on allows you to pull data from multiple data sources in Google Sheets.
You can customize reports and access the templates already available through Supermetrics.
Note: There is a monthly fee for the Supermetrics add-on, but you can try it for free first.
advertising
Read on below
4. RankTank
RankTank is a good add-on that allows you to track keyword rankings right in Google Sheets.
It’s pretty easy to use.
All you have to do is add the domain and choose the location, language and device.
Then add your keywords.
You can see your rankings in real time, along with the leaderboard and the leaderboards of the competitors above you.
According to RankTank’s description, the tool differs from others in that it uses live keyword rankings.
advertising
Read on below
Here’s a plus: with RankTank, you get a set number of free scans each month.
5. Moz API for leaves
Are you a Moz fan?
In that case, you should check out the Moz API for leaves.
Even if you don’t have an account with Moz, you can still use this sheet by signing up for a free plan that gives you access to domain and page permissions for 200 URLs each.
The Moz add-on also has built-in formulas that you can use to analyze the data.
6. Majestic
To use the Majestic add-on, you need a subscription.
advertising
Read on below
Once you’ve got everything set up (it’s not difficult), you have the option of pulling a ton of data about a domain with the data extractor, similar to the screenshot below, or the Metrics for a group data extender for URLs.
7. SEOmonitor
If you’re already using SEOmonitor, an SEO platform for agencies, you can use your API key to import data into Google Sheets.
advertising
Read on below
After you have accessed campaigns from your SEOmonitor account, you can create dashboards, data visualizations and custom reports.
Using the SEOmonitor add-on, you can generate reports like the following:
Add-ons that are not SEO specific but still helpful
The following Google Sheets add-ons are helpful, but not SEO specific.
However, they are worth checking out as they can help you sort, filter, and analyze your data.
advertising
Read on below
Again, it’s about saving time and optimizing your work.
8. Remove duplicates
Removing Duplicates comes in handy when you’re going through rows and rows of data.
This add-on will help you find duplicates by giving you several options as shown in the “Remove Duplicates” drop-down menu below.
For example, you can use that Look for duplicate or unique lines Ability to identify duplicate or unique rows and then highlight, remove, or move the data to another tab.
advertising
Read on below
You can also use the add-on to compare two sheets or columns to identify changes and identical dates.
In addition, you can use the data to perform many tasks, such as: Examples include copying or moving to another table, marking as duplicate or unique, and merging cells.
9. Power tools
There are certain tasks and functions in Google Sheets that can be repeated.
Power tools should be easy to use.
Once you’ve installed Power Tools, you’ll have access to tons of tools that are divided into different groups based on their intended use.
You can use power tools to:
advertising
Read on below
- Merge and combine cells.
- Find and replace data.
- V-Lookup multiple matches.
- Remove duplicates.
- Sum and count colored cells.
- Remove unwanted data.
- Add text by position.
- And much more.
This add-on alone will help you improve your spreadsheets in no time.
10. Advanced find and replace
Advanced Find and Replace does exactly what the name suggests.
This add-on goes beyond a simple search and replace command and offers the ability to search formulas, notes, values and hyperlinks in all sheets at the same time.
Once you have the list of records found, all you have to do is click to replace them.
The great thing about this add-on is that it looks at everything at once and even checks links that are behind the display text.
advertising
Read on below
If you want to keep track of the entries found, you can export the values or entire rows that contain them.
Final words on add-ons
Remember, you don’t need all of these add-ons.
As I mentioned at the beginning of the article, and as you can tell from the different add-on descriptions, many of them have similar functions.
The purpose of using add-ons is to make things easier when using Google Sheets.
So, think about what you often do in Google Sheets and choose the add-ons that are most relevant.
By the way, there are lots of great add-ons!
Even if they didn’t make this list, it doesn’t mean they aren’t worth checking out.
Other resources:
Photo credit
In-Post Image: TCdesign / Depositphotos
All screenshots by the author, October 2020