Turning Excel Into An SEO Productivity Powerhouse!

by Tory McBroom · 2 comments

I’m about to show you how to be 30x more productive with your SEO efforts…

And like a lot of the methods I use, this little tip/tool is absolutely FREE!

But, first I want to bore you with a quick story about myself.

I’m very meticulous (nice way of saying I suffer from OCD – thanks mom) in that I track and plan most everything I do.

For example:

I have a spreadsheet set up for all of my workouts which detail every rep and pound I’ve lifted over the last ten years…

I have my diet plan written out in detail, displaying my caloric, carb, protein and fat goals for each day, displayed in my kitchen…

*In all fairness, I’m not a total prude…I do have a spontaneous side, which usually just gets me in trouble…

Now, this may seem crazy to most, but it helps me analyze what works, what doesn’t and to identify patterns so I can spend my time more efficiently.  It may take a little work upfront, but it pays off tenfold in the end.

This meticulous tracking of data has helped in countless ways with improving my conversion optimization and SEO productivity, as well.

For every site I’ve owned and still own, I have an excel sheet set up to track certain backlinks like my web 2’s, guest posts, anchor text’s I used, etc.  I also track what services I used to backlink these anchor sites.

But, this is where the fun part comes in!

Introducing SEO Tools For Excel

This little add-in to Microsoft Excel can make tracking your campaigns and analyzing data a snap.  In fact, it has saved me countless hours…and more importantly my sanity.

SEO Tools For Excel was created by Niels Bosma and turns a simple Excel sheet into a powerful SEO tracking tool.

So, how can SEO Tools For Excel help YOU?

  • It allows you to monitor and analyze your back links
  • Check if you’re backlinks, or your site’s links, are indexed
  • Check Google pagerank for sites
  • Count the number of Facebook likes, Google + and Tweets for any URL
  • Research a sites Alexa popularity
  • Scrape any website or web service and pull that data directly into Excel
  • Conduct domain research, for example, find out when a domain expires, etc.
  • Pull data from Google Analytics
  • Avoid duplicate content
  • Onpage SEO analysis

And that’s just a few of the features of this popular tool!

Installation is easy.  Just visit the downloads page and download either the 32 bit or 64 bit version, depending on what version of Excel you’re using.  If you’re not sure what version your Excel program is then simply click File ==> Help and over on the right hand side you’ll see your version.  It looks like this in Office 2010:

excel 32bit

Once you’ve downloaded the file and have it installed, which is as simple as dragging and dropping the SeoTools.xll file into an open spreadsheet, then you’ll now have the Seo Tools tab at the top:

SeoTools Tab

Simply click that tab and it will display the full suite of tools you can use:

SeoTools Bar

How you use the extensive suite of tools is up to you and your unique situation. But, don’t be afraid to jump in and test all the different features.

And since you’re soon to have all this extra free time on your hands now, feel free to comment below! 🙂