16 May 2016

5 Awesome Google Spreadsheet Addons for Keyword Research

Who doesn’t love Google Spreadsheets? For their awesome live collaboration features, fast performance and usability I consider them to be one of the best Google’s products.

I have already listed Google Docs addons. In this article, I am listing some of the most useful Google Spreadsheet addons that can help you with keyword research:

1. Text Analysis Addon

Text Analysis Addon Google Spreadsheet Addons

This is a freemium addon that comes with a ton of free credits for you to play with it and make up your mind whether you’ll need it on a regular basis. Some of the best features:

  1. Extract the article title, body and author information from any URL
  2. Extract entities such as placespeople, products and organizations (Named Entities) from any text
  3. Extract concepts: similarly to the above but with more precision. This option extracts different types of notable entities from a document, using Wikipedia as context.
  4. Find best hashtags: Generate a list of highly-relevant hashtags that will help you get more exposure for your content on Social Media
  5. Find related phrases: Get a list of phrases and words that are related to the input phrase or word based on semantic similarity.

A great alternative for entity and sentiment analysis: Text Mining addon. I recommend trying both.

2. Omni Translator

Omni Translator Google Spreadsheet Addons

For international keyword research and content research. This addon makes translation a breeze and improves your productivity.

3. Remove Duplicates

Remove Duplicates Google Spreadsheet Addons

If you combine keyword lists from different sources, this one may come in handy.

It does more than removing the duplicates though: You can color the cells with the common core terms to dig deeper into your keyword sets:

Use the “Compare columns or sheets” tool to quickly scan any columns in your tables for the same values. It will take you five simple steps to mark duplicates with colour or status, copy or move them to another sheet, clear repeating cells, or delete entire rows that contain dupes from your main table.

4. Advanced Find and Replace

Advanced Find and Replace

Another great addon for huge keyword lists.

You can look for the record you need in hyperlinks hidden behind the display text, formulas, and even notes. The search in values is performed with advanced parameters as well: you can match case, retrieve the cells that contain only the exact entry, or get any text occurrences.

***If you work with large combined lists, bookmark this tool too: Smart URL List Cleaner Tool

5. Twitter Archiver

Twitter Archiver is a great Google Spreadsheet addon that lets you import Twitter search result into a Google Spreadsheet.

I use it to monitor Twitter questions around my core term. It’s a great way to collect content ideas and better understand your audience.

The search query I use: [keyword ? -http]

Twitter Archiver

Twitter Archiver

Bonus: Search Analytics for Sheets

Search Analytics for Sheets

This one is a cool spreadsheet addon that lets you archive (and play with) data from Webmaster Tools’ / Search Console’s Search Analytics (including queries).

See more details here: Search Analytics for Sheets

Adding this one from the comments! Keep ’em coming!

Are there Google Spreadsheet addons you are using? Please share!

Comments

  1. May 16, 2016 at 9:43 AM

    Hey Ann! I’ve actually built a small Google Sheets add-on myself which you can use to grab and backup data from Search Console’s Search Analytics. I use it to get all the data available for a given website, grouped by Keyword and Page, which helps me with kw research, monitoring positions and reporting.

    Was planning to keep this under wraps a little while longer to make sure it’s bug free, but people seem to have already found it in the add-on store. Anyway, you can find it over at https://searchanalyticsforsheets.com

    Let me know if you find it useful, would love any feedback you might have!

    1. Ann Smarty May 16, 2016 at 1:43 PM

      Thanks for the heads-up! Looks like a cool addon! I’ve added it to the list!

  2. Ville May 16, 2016 at 12:24 PM

    5/5 new to me! This was really great article, thanks!

  3. Puja Roy May 20, 2016 at 1:00 PM

    I had never used these add ons for Google Spreadsheets. Duplicate remover option is great and will help while keyword research.

  4. Nidhi Shah May 21, 2016 at 8:22 AM

    Hi Ann,

    Great article on Addonns for keyword research. Keyword research is the most important thing in SEO and it becomes very easy through this addons. Enjoyed reading the whole post. Thanks for sharing this with us.

  5. Akash Jain June 2, 2016 at 11:51 PM

    Hi Ann!
    I love Twitter Archiver. It is one of my favourite add-ons. It totally makes my work easy while handing many twitter accounts simultaneously.
    Thank you for the rest!

Leave a Reply