Update: Version 2.0 of the Excel Interface to the seoMoz API

I’m very happy to announce an updated version of our Excel Interface to the seoMoz LinkScape / Mozscape API. Your suggestions have been heeded and the new version is a great improvement over the first.

What’s new?

  • Run On-Demand: No more auto-updating. Now, just press Alt+F8 to run when YOU want.
  • Rate Limiter: Helps to keep us out of the seoMoz doghouse. Allows 2 URLs to be processed per second. As of early 2012, the rate limit has been changed to 1 URL per 10 seconds. (for free accounts)
  • Cleaner Spreadsheet: Removed the “raw” seoMoz response and handles all parsing within the macro.
  • Conditional Formatting: Automatically compares scores against all others on the sheet. Highlighting opportunities FTW!
  • Stand-Alone Macro: Save the macro to your personal workbook and you can run it against any list of URLs. No need to use *this* spreadsheet every time. (minor tweaks required)

BusinessHut seoMoz LinkScape API Excel Spreadsheet

Please visit this page to download the latest version of the Excel spreadsheet: Excel Interface to the seoMoz API

— Make it more awesome with this post by John Doherty
— And for even more info, check out John’s post on SEOmoz

********* UPDATE 12/13/2011 **********
Rolling out December, 16th, 2011, the SEOmoz Free API will be severely limited.
The new rate limit for the Free API is 1 request every 10 seconds.
(Compared to 2 or 3 per second that we’ve been running.)
And batch requests for the URL Metrics Call has been limited to 10 URLs for every POST request.
You can read the official SEOmoz API update here.

********* UPDATE 9/5/2012 **********
Version 3.0 is now in beta testing.
Rather than a vba macro, this new version is an installable Excel Add-in.
Check it out here: http://www.businesshut.com/seo/seomoz-mozscape-add-in-for-excel/

Suggestions and support are welcome. Thank you to everyone who has given feedback thus far.

16 thoughts on “Update: Version 2.0 of the Excel Interface to the seoMoz API

  1. Thanks for this great sheet, is there anyway to speed up how the text is parsed? the responce from the seomoz API doesnt seem to take long but a lot of time seems to spent parcing the responce… do you know any other way of doing this to speed things up? I removed conditional formatting but this only speeds up a fraction.

    Great work again!

    1. Thanks Dan. There’s a pause built into the code for rate limiting. So, if the parsing takes .3 seconds or more, we could remove the pause. Just delete or adjust the line that says Sleep 500.

      I’ll also do some testing to see if the code can be optimized.

      Thanks for your input!

    1. John,
      First, enter your api credentials from the seomoz api page. http://www.seomoz.org/api
      Then, put a bunch of urls in column A.
      Press Alt+F8 and run the macro.

      It’ll take about 1 second for each url, but you’ll soon have useful data to help you decide which sites to target for links.

      Or…you could populate your current list of backlinks to learn more about your link profile.

      I was reading on John Doherty’s blog about visualizing your link profile with Open Site Explorer. If I can automate the OSE (or similar) data, this could get pretty useful.

  2. You should include a couple of images from the spreadsheet in the article to give people an idea of what to expect. Would probably drive a higher download %. Its a nice sheet!

    1. Sorry everyone! Version 2 doesn’t seem to be working anymore. I’m troubleshooting and will post a new version soon. Until then, I’ve verified that the original version still works. Please give that a try in the meantime.

Leave a Reply

Your email address will not be published.