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 responses to “Update: Version 2.0 of the Excel Interface to the seoMoz API”

  1. […] To follow along, download the latest Excel macro-enabled spreadsheet below: (Enable macros after opening.) Excel Spreadsheet (Beta1) 4/19/2011 (Original Version) Excel Spreadsheet (Beta 2) 9/22/2011 View the Updates in Version 2 […]

  2. Dan Avatar

    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. Jason Green Avatar

      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!

  3. J Avatar

    I just dwnloaded the files, but not sure what to do next.

    1. Jason Green Avatar

      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.

      1. Alex @SEO (Search Engine Optimisation) Avatar

        Any news on trying to automate the OSE? I am trying the same but finding it a bit tricky!

  4. Tom Avatar

    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!

  5. […] would probably add to the list the SEO Tools For Excel by Niels Bosma and the Business Hut Excel'SEOMoz Mashup to give your sheets more actionable […]

  6. jant Avatar

    Thank you
    There’s a pause built into the code for rate limiting. So, if the parsing takes .3 seconds or more

  7. Joshua Avatar

    Does this sheet this only work with Excel for Windows?

    1. Jason Green Avatar

      It appears that way. We haven’t found anyone who’s able to get it working on a Mac.

  8. Alex @SEO (Search Engine Optimisation) Avatar


    Really trying to get this to work but struggling a bit.

    Where do I find the signature and timestamp info for moz api?

    I only have secret key and member ID on my page?


    1. Alex @SEO (Search Engine Optimisation) Avatar

      I have used the sample signature and timestamp but it’s still not working.

    2. Jason Green Avatar

      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.

  9. Tony Avatar

    Just hoping this sends me an auto update when your done updating the code so i dont have to keep checking back or figure it out myself…..

  10. riley Avatar

    Holy crap! This is awesome. I was literally using python script to do all this work and this is so much easier! Thanks!

Leave a Reply

Your email address will not be published. Required fields are marked *