SEO Tools for Excel

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

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. Erotik film izle

http://www.distilled.net/excel-for-seo/

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.

https://seogadget.co.uk/google-adwords-plugin-excel/

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. bahis

http://www.seomoz.org/blog/competitive-analysis-in-under-60-seconds-using-google-docs-12649

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.

http://www.seerinteractive.com/blog/competitor-backlink-analysis-in-excel/2011/07/28/

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.

http://www.automateanalytics.com/2010/04/solution-for-combining-data-from-many.html

Oh, you thought we were done? No way, Jose. Now we’re to the Excel section. Excel has a few advantages over Google Docs spreadsheets, and Gdocs does better with some things than Excel. The takeaway is that it’s better to use both than to rely on just one. So here are the three best Excel SEO tools I’ve seen.

AdWords API Extension for Excel

AdWords API Extension for Excel – Download
AdWords API Extension for Excel – Instructions

Oh look, SEOgadget again, who could’ve figured? 😉

This tools makes analyzing potential traffic crazy easy; toss in a list of the keywords you’re targeting, mess with the numbers and roll a formula to determine CTR and you’ve got some solid projections. While it does require an AdWords API key (which can be difficult to obtain if you’re not a PPC guy), it’s well worth the effort.

The possibilities with this add-in are immense; you can roll this tool together with OpenSiteExplorer reports and domain-centric keyword suggestions to quickly estimate competitor’s search traffic, or, you can judge the fidelity of Google’s predictions against your own traffic data by pulling Google Analytics reports into Excel.

Inbound Link Categorization

Inbound Link Categorization – Download
Inbound Link Categorization – Instructions

Let’s hear it one more time for SEOgadget! Those guys are awesome.

This tool is a lot like the OSE Link Profile Google Docs tool shared above, but in Excel. It also builds in a categorization element that makes segmenting link profiles easy. Oh, and the reports look super sexy too.

You pull in your link profile CSV from OpenSiteExplorer and this spreadsheet will analyze and categorize your link profile, showing you anchor text distribution, and buckets of links based on known directories, article distributors, blog networks and so on. Sexy, sexy data.

Niels Bosma’s SeoTools for Excel

Niels Bosma’s SeoTools for Excel – Download (32-bit OS)
Niels Bosma’s SeoTools for Excel – Download (64-bit OS)
Niels Bosma’s SeoTools for Excel – Instructions

This is the holy grail of Excel SEO extensions. It has one of the most robust feature sets I’ve seen in an extension, and Niels is updating it constantly. It has mind-boggling scraping capabilities (get a proxy if you plan on using them a lot) and a ton of on-page analysis tools.

I don’t think I can say enough about this extension; it’s one of the best free SEO tools out there, and you can use its functions to roll your own tools. I don’t need to waste your time talking about it. Go download it and have fun!

Excel and Google Docs can be some of the best agile tools around, and these are some of the best I’ve found.

What are your favorite Excel/Google Docs SEO tools? Did I miss one?