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.
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.
- How Important will Backlinks be in 2023? - February 20, 2023
- What is in a Link? - October 25, 2022
- An Interview with… Ash Nallawalla - August 23, 2022
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 amIf you want to use GoogleDocs, You can do so using our French Ambassadors’ GoogleDocs spreadsheet.
January 14, 2013 at 11:56 amIs 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 amI 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 amHi,
January 14, 2013 at 12:58 pmthank you for amazing tool. Do you plan to launch Mac version?
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 pmFirst, 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 amWow, 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?
February 7, 2013 at 12:53 amGive 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.
February 7, 2013 at 1:57 amAwesome! Thanks Dixon.
February 16, 2013 at 10:38 pmI’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 pmNice 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 pmDixon 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 amHow do you do?
January 24, 2013 at 5:57 pmI am a Japanese.
Can this be used even in Japan?
Sure.
January 24, 2013 at 9:03 pmNice, I like working with Excel, it gives me a lot of flexibility.
January 30, 2013 at 2:18 pmCould be a good tool for my arsenal.
I agree. It works great for personal sites, but if you have a lot of client sites, that saves us so much time!
February 7, 2013 at 12:54 amWhat 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 pmI 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 amAm 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 pmI am in love with this extension add-on.
February 4, 2013 at 5:18 pmI 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. 🙂