I am delighted to be able to tell you that Niels Bosma, the developer of the free SEO for Excel plugin, has incorporated Majestic SEO into Excel, allowing you to bring link data and anchor text data straight into Excel along with the existing ability to use data from our partners at SEOLytics and from Google Analytics, SEO for Excel is now an incredibly powerful way to look at URL data and could save you hours every month analysing and reporting on your search efforts.

SEO Tools for Excel

The tools is designed for paying users of Majestic SEO (this stuff isn’t free to build and maintain you know!) but you do not need an expensive account to make use of the Excel plugin. A silver subscription ($49.99/€44.99/£29.99 a month) will work fine with no long term commitments.

What you get is considerably more than “just link counts”. The plugin brings back lists of back links, starting with the strongest first. You can also bring back the anchor text spread surrounding links to any site or URL and you can even TRACK NEW AND LOST LINKS day by day.

Much of the major functionality you can do on Majestic’s main site can be replicated straight into SEO Tools for Excel. From there, you can augment any data with your own, giving you potentially limitless information about any URL or link.

It is not JUST for links

Bear in mind that for every URL on the internet, Majestic aims to have qualitative “Flow Metrics ™” associated with each one. So if you find important URLs from other places, such as the SEOLytics visibility data or the Google Analytics traffic data, you can augment all of these URLs with Citation Flow and Trust Flow metrics. These are more granular and updated more often than (say) Page Rank and are MUCH easier to import into spreadsheets.

Requirements and Download

In order to use SEO Tools for Excel with Majestic you will need:

  • Excel on a WINDOWS machine with .NET installed
  • SEO Tools for Excel plugin version 4.07+
  • A Majestic SEO subscription – Silver or above – available from within the tool
  • Internet access of course.

You can download SEO Tools for Excel here.

Please note – Majestic SEO does not own or support this tool directly. Please direct support issues directly to Niels or SEO forums.

Comments

  • Bilal Sarwari

    It’s a good update Dixon, but there should be something regarding Google Docs, For Example

    If I have 10+ sites and by integrating Majestic with google spreadsheet it automatically update all records like links count, unique referring domains, new+deleted links etc

    January 14, 2013 at 11:44 am
  • Statistics Freak

    Is it possible to use this to create Excel files wich then could be used in IBM SPSS statistics software ?

    January 14, 2013 at 11:52 am
    • Dixon Jones

      I have no idea. I would assume that SPSS can pull in data fro Excel – but if not, you can always export the data to csv from Excel. But if you are going to do all that, someone should rather just build commands in SPSS that work wit OpenApps. That’s not something Majestic could do though.

      January 14, 2013 at 11:58 am
  • Martin Šimko

    Hi,
    thank you for amazing tool. Do you plan to launch Mac version?

    January 14, 2013 at 12:58 pm
    • Dixon Jones

      We did not build this tool – you will need to ask Niels. I do not think Excel for Mac likes plugins though.

      January 14, 2013 at 1:48 pm
  • Ricky Shah

    First, MajesticSEO google chrome extension, and now this. It seems you guys are on a roll in 2013. This will definitely help many of us to get more insights on the data.

    January 15, 2013 at 3:14 am
  • Farhan Fawzer

    I’ve been a great fan of Majesticseo from the beginning. Great stuff guys and wishing you all the best. Keep up the good stuff.

    January 17, 2013 at 3:34 pm
  • Jonathan

    Nice update to the add-in for Excel. I would love to see an example of a completed workbook with all the relevant functions for a ‘standard’ initial SEO pass. Would be a good tutorial on using the macros in a ‘real life’ situation.

    January 17, 2013 at 9:15 pm
  • sleepinggiant

    Dixon Knows I think the impact of data management process in SEO very well. Majesticseo is the most authenticated SEO tool I have experienced and this new add on for excel now help more than just analysis. Data formatting sometimes get hectic for me. This would help surely.

    January 22, 2013 at 4:35 am
  • kouji imai

    How do you do?
    I am a Japanese.
    Can this be used even in Japan?

    January 24, 2013 at 5:57 pm
  • Simple Seo

    Nice, I like working with Excel, it gives me a lot of flexibility.
    Could be a good tool for my arsenal.

    January 30, 2013 at 2:18 pm
  • andreas

    What is the excel experience with large files? We have large reports > 1 million links. Usually excel does not take more than 100 k lines. I like the feature, but will it work with these numbers?

    January 30, 2013 at 5:53 pm
    • Dixon Jones

      I wouldn’t use Excel for a million lines – although I have loaded the on newer versions of Excel on my Mac Air, so you can if you want.

      January 31, 2013 at 7:42 am
  • Reboot

    Am going to try this first thing on Monday morning as my hubby barred me from using the PC until then :(

    I can see this being very helpful and time saving in helping with penalty removals especially. Can’t wait to give it a go.

    February 1, 2013 at 9:31 pm
  • Ankit M.

    I am in love with this extension add-on.
    I mean its great you can download all your link profiles locally to your excel sheets and then you can create charts, graphs and do anything with this data. This is amazing.
    Thumbs up for Niels. :)

    February 4, 2013 at 5:18 pm

Comments are closed.