SEO Tools For Excel now with Majestic SEO

By Dixon Jones January 14, 2013

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.

22 Responses to “SEO Tools For Excel now with Majestic SEO”

  1. Bilal Sarwari said:

    January 14, 2013 at 11:44 am

    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

    • Dixon Jones said:

      January 14, 2013 at 11:56 am

      If you want to use GoogleDocs, You can do so using our French Ambassadors’ GoogleDocs spreadsheet.

  2. Statistics Freak said:

    January 14, 2013 at 11:52 am

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

    • Dixon Jones said:

      January 14, 2013 at 11:58 am

      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.

  3. Martin Šimko said:

    January 14, 2013 at 12:58 pm

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

    • Dixon Jones said:

      January 14, 2013 at 1:48 pm

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

  4. Ricky Shah said:

    January 15, 2013 at 3:14 am

    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.

    • JW said:

      February 07, 2013 at 12:53 am

      Wow, I didn’t know Majestic SEO had a Google chrome extension. I just signed up for the silver plan, so I’ll have to check that out. What exactly does it do?

      • Dixon Jones said:

        February 07, 2013 at 1:57 am

        Give it a whirl! gives you Link insights straight into your browser. Thanks for signing up – you can use the full power of the Chrome plugin with Silver.

      • Jeroen said:

        February 16, 2013 at 10:38 pm

        Awesome! Thanks Dixon.

  5. Farhan Fawzer said:

    January 17, 2013 at 3:34 pm

    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.

  6. Jonathan said:

    January 17, 2013 at 9:15 pm

    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.

  7. sleepinggiant said:

    January 22, 2013 at 4:35 am

    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.

  8. kouji imai said:

    January 24, 2013 at 5:57 pm

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

    • Dixon Jones said:

      January 24, 2013 at 9:03 pm

      Sure.

  9. Simple Seo said:

    January 30, 2013 at 2:18 pm

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

    • JW said:

      February 07, 2013 at 12:54 am

      I agree. It works great for personal sites, but if you have a lot of client sites, that saves us so much time!

  10. andreas said:

    January 30, 2013 at 5:53 pm

    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?

    • Dixon Jones said:

      January 31, 2013 at 7:42 am

      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.

  11. Reboot said:

    February 01, 2013 at 9:31 pm

    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.

  12. Ankit M. said:

    February 04, 2013 at 5:18 pm

    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. :)