You know how sometimes when you’re fighting with data in various formats and you wish you could just throw your hands in the air and download it all to an excel spreadsheet?
You’re in luck. When it comes to SEO, you can!
Here at the BrainTrust, we do something called ‘Action Teams’. During a recent ‘Google Analytics Action Team’, a member mentioned a tool that he uses to export data into excel for easier manipulation. We invited the tool developer in for a very interesting demo (see step-by-step video below).
Tool Name: SEO Tools For Excel
Primary Purpose: An add-on with several useful functions for working with SEO and other web metrics directly in Excel.
Price: Free (accepts donations)
Developer: Neils Bosma
Perfect For Whom?: “There’s something for everyone”, as Neils says.
Link: http://nielsbosma.se/projects/seotools/
Ease of Use? Medium. It’s easy to learn one piece at a time, and Neils has an active forum where he and others provide support.
Important Caveat: It’s ‘Windows only’ at this point in time.
Just start with the bits you need, become familiar with it, and work your way up from there.
Here’s what it can do:
- Onpage analysis and debugging
- Works with your MajesticSEO or SEOlytics account
- Get any data out of Google Analytics
- 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
- Monitor social media efforts
- Avoid duplicate content when writing texts
Use this free tool for one, some, or all of these, depending on your needs and skill level with Excel. It’s well worth checking out.
Title: Tool Review: SEO Tools For Excel
Date: January 7, 2013
Author: Niels Bosma & Andrea Warner
Run Time: 00:45:01 (0 hour, 45 minutes, 01 second)
[S3VIDEO file=”Andrea/Tool-Review-SEO-Tools-For-Excel.mp4″]
Download Video – [S3FILE file=”Andrea/Tool-Review-SEO-Tools-For-Excel.mp4″]
Now this is a useful tool!
Thank you so much for great post.. Lots of useful info here. I am sending it to several friends also sharing in delicious. And of course, thank you for your effort!
But work not on excel 2013 i get error message!
Hi Knugo, I check with Neils Bosma, and he said this:
SeoTools should already be working with Excel 2013? I’m guessing you need to install the latest “full” version of .Net http://seotoolsforexcel.com/links/dotnet
Please try that? It’s such a useful tool.
Hi
Do you know why after installing the add-in on excel 2010, i don’t see any plugin tab appear
Thanks