5 Valuable SEO Spreadsheets Resources

SMS Text

Alex Adekola

As we all know Excel and Google Docs can be great tools for any SEO consultant. Hook Google Docs or Excel up to API’s from Google, SEOMoz, SEMRush or any other tool you like to pull in data and you can begin to automate some key tasks like keyword research, ideas for content generation, and competitive research, backlink analysis, rank monitoring, reports, etc. It’s important to understating how these spreadsheet tools work.


Distilled offers an awesome starting place for getting familiar with using excel to manipulate data.  They have a handy guide – Excel for SEO that covers a wide range of tasks, tables, time savers, and shortcuts. Be prepared to spend a decent amount of time getting through the workbook and example pdf. This is time well spent as you will gain the knowledge to create your own tools and worksheets that suite your needs best.


AdWords API Key

This next tool will require you to sign up for an AdWords API Key in order to pull in data. It may take a few weeks for Google to grant access to an API Key. Once up and running this is a great tool for KW research as it grabs exact, broad, and phrase match keywords. You also can see local search volume for mobile and desktop and generate related queries using Google suggest all in an excel sheet.


SEOmoz’s API

Once you have boiled down the keyword traffic and selected the keywords that you are looking to rank for this tool will help you quickly figure out which websites are ranking most frequently for the terms you want to rank for. This tool is great for quickly finding out the top competing websites in your vertical. This tool requires access to SEOmoz’s api to work. Once you have figured out your competitors in the SERP you can start researching their backlinks.


SEER interactive

This third example comes from SEER interactive. Once you identify the websites that rank for the terms you want to compete for it’s a good idea to reverse engineer their link patters and backlink profile. This excel example shows you how to break down large amounts of link data into actionable steps.  Analyze anchor text, domain type, and link category. This is a great tool for figuring out the link profile of the top ranking competitors.


Bring GA and AdWords straight into Excel

After you begin any SEO campaign you are going to need to look at the effects of your efforts and one of the most popular web analytics software in existence is Google Analytics. My final link is a tool that can bring any data form GA and AdWords straight into Excel. This presents a great way to create a dashboard of your favorite metrics right in Excel that you can share with your client if desired. You can also make some nice 3D Bar graphs for some nice eye candy in your reports.


Alex Adekola
Alex Adekola is a search engineer at Incept Design located in Tampa, FL and Marketing Chair for Voice for Children Tampa.
Alex Adekola
Alex Adekola

Latest posts by Alex Adekola (see all)

Get the latest news from Search Engine Journal!
We value your privacy! See our policy here.
  • http://www.alltribes.com Dean Adams

    Hi Alex, Just out of curiosity, exactly what do these applications offer that cannot already be done in Google Analytics? Being a DATA addict, I hate getting addicted to more of it. Before Google provided all the tools I was analyzing data on my own created spreads, way before SEO kicked in. LOL!

  • http://www.otimizacaodesites.tv Rodrigo

    Very good, spreadsheets are resources very cool and cheap. I make my own.

  • http://www.inceptdesign.com Alex Adekola

    The SEOMoz tool will have data not found in analytics as will the AdWords tool. SEER’s tool is also going to help you determine what kind of links your competition has.

  • http://goldenspeedseo.com/ Seo Vietnam

    Hello Alek, thanks for sharing all these very useful ressources. Regarding SEER, can you tell us where they pull their backlinks data from as many similar applications depended on Yahoo until recently they shut down this service? Does seer have it’s own crawlers or does it request data from other search engines?

    • http://inceptdesign.com Alex Adekola

      They grab their data from SEOmoz’s Opensiteexplorer tool. Check it out at opensiteexplorer.org

      • http://goldenspeedseo.com/ Seo Vietnam

        OK, will do, thanks

  • http://www.360-webmarketing.com Référencement Tunisie

    Hello Alek, thanks for sharring. Great tools !

    • Xe dap dien

      OK, will do

  • http://www.dirtyseagulls.org The Dirty Seagulls

    Great tools thanks looking forward to trying out the ones that I haven’t used already.

  • http://secretstowebsuccess.com Dali Burgado


    Thank you so much for gathering these resources together. I’ve stumbled this to come back to!


  • http://www.buzzedu.com Logesh


    This is really great thanks for helping us…..