SeoTools for Excel
Real SEOs work in Excel!
SeoTools is an Excel add-in that adds a bunch of useful functions for working with SEO and other web metrics directly in Excel.
For example you can use SeoTools for:
- Onpage analysis and debugging
- Create your own SEO scorecard/report
- Monitor and analyze back links
- Scrape any website or web service and get data directly into Excel using regular expressions or XPATH
- Domain research
- String templating
- Get any data out of Google Analytics
- Monitor social media efforts
- Avoid duplicate content when writing texts
- Work with your MajesticSEO or SEOlytics account.
- And much more…
Functions
See all functions included in SeoTools.
Download
Sounds awesome right? Go to the download page!
If you like SeoTools, please donate a buck or two and join Donators Club.
Help
Read blogposts about SeoTools.
Get help in the SeoTools Community Forum.
Got ideas for further development? Post your ideas on http://seotools.uservoice.com.
SeoTools for Excel
FACEBOOK



@KaleidoMatt:
- Are you sure they are in the same directory?
- Have you made any changes in the config file?
- How did you install SeoTools?
- Do you use the latest version?
- What version of Excel?
I’ve been looking for a tool to help me get a better handle on backlink analysis…giving SEOTools for Excel a try!
Is there any chance to put it open-source and get community participations ?
@Tomas: No plans for this at the moment. I have some ideas for a plugin framework.
Hi Niels,
It appears that I didn’t install SEOTools correctly. All is now in working order.
Thanks for your help,
Matt
Why isn’t this tool working correctly? Normally I get a “couldn’t retrieve from URL” error. Please help! I want this to work badly!!! haha
@Trent: please submit you question to http://seoforums.nielsbosma.se. Include formula, version of SeoTools and version of Excel.
[...] [...]
I went through your site and couldn’t find a compatibility list for which versions of Excel work with your SEOtools.
I am currently using Excel 2007 (12.0.6654.5003) on Windows 7 (32 bit)
Will SEOtools work for my version of Excel?
@Dave: yes this is the setup I use myself.
/Niels
Does this work with Excel 2010? Thanks.
@Grind: Yes
Hey Niels,
first i have to say its a great tool!
I have a question about the =CheckBacklink function. I really like this, so I can see simply which Backlinks are active. But how often are they checked? Only once or every time I start Excel? Do i have execute that function everytime I want to check, if a backlink is still alive or it get triggered on its own?
cheers
@Phil: Yes, you need to run the function to make a new check. If you reopen a document it usually recalculates all functions depending on the settings on the document.
Thanks for your answer. Unfortunately it doesnt recalculate when i reopen the document. Can u tell me which settings i have to edit?
cheers
Hi,nielsbosma. Thank you for this tool, however, I have one question about installing.
My PC with Win7 64bit + Office 2010 + SeoTools 3.3.4 for Excel 32bit is OK.
Another PC with XP sp3 + Office 2010 + SeoTools 3.3.4 for Excel 32bit can not work. I have tried method A&B. No error prompt, no SEOlytics logo.
Thanks
Thank you, nielsbosma, it seems like a great tool
and I am looking forward to see it in action.
Cheers,
Useful tool for a bit of Excel jiggery-pokery, thanks Niels.
Really Nice tool.thanks for share and I will use definatly..keep it up
Thanks a lot,
Using this tool daily from the day i found it and it’s saving me a lot of precious time…
Thanks Nielsbosma.
Very interesting tool
I’ve written a little post on my seo blog about it
Freakin’ cool! Have been wanting to build an excel seo app for a few years now but this going to do the job in an awesome way! Thanks!
First impressions are good, I will write a review on our Blog to help spread the word!
a useful tool which should be developed further! works fine in excel 2010!
Very interesting tool
Interessantes Tool als SEO arbeite ich bereits mit anderer Software, werde Deins gerne testen.
very useful tools
thanks
Awesome competitive and strategic SEO tool!
Definitely a sweet tool for day to day SEO. What a great share.
It’s because of this tool that I’m actually going to force myself to learn Excel. I’ve been doing very similar functions via Google Docs and other tools, but nothing that can even compare to what this offers.
Thanks for sharing, very much appreciated =)
WOW! Thank you, this tool is great.
You saved me hours of manual labour.
This tool is loaded with practical features if you know how to use them, very powerful!
My donation is well deserved
I was Ctr+C and Ctrl+V data from GA to excel from reports…You don`t have idea how much time i saved , thanks to you ^^
This is absolutely amazing! Not as pretty as mainstream seo apps but way faster and more powerful- thank you!
Awesome tool
Thank you so much. This tool is great!