Turning Excel Into An SEO Productivity Powerhouse!

by Tory McBroom · 6 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! :)

Share this post with your twitter followers:


{ 6 comments… read them below or add one }

Kazsandra April 25, 2012 at 9:48 pm

SEO is definitely a great way to make us into success.. I hope this can be a big help too.. Thanks a lot!
Kazsandra recently posted Cure Panic AttacksMy Profile


Lynell Bumpas August 29, 2013 at 11:59 am

I didn’t know there are SEO tools for Excel. Niiice. I’m going to check them out.
Lynell Bumpas recently posted The Trinity CodeMy Profile


knugo September 16, 2013 at 2:42 pm

Dont work on excel 2013!


Tory McBroom September 16, 2013 at 2:46 pm

Use SeoTools 4.1.1beta
Tory McBroom recently posted Helping Small Businesses Grow Online… Easily And Affordably!My Profile


knugo September 19, 2013 at 1:12 am

SeoTools 4.1.1beta also dont work!
knugo recently posted GuradamajacakMy Profile


Tory McBroom September 19, 2013 at 6:15 am

Then that would be an issue to bring up with the developer…
Tory McBroom recently posted Creating Mobile Apps On A BudgetMy Profile


Leave a Comment

CommentLuv badge