1. This site uses cookies. By continuing to use this site, you are agreeing to our use of cookies. Learn More.

[Tip] Cool Excel Add-Ons for SEO

Discussion in 'White Hat SEO' started by TheContentAuthority, Jul 24, 2013.

  1. TheContentAuthority

    TheContentAuthority Elite Member Premium Member

    Joined:
    Mar 27, 2012
    Messages:
    1,756
    Likes Received:
    1,060
    Occupation:
    President of The Content Authority
    Location:
    Pittsburgh, PA
    Home Page:
    I?ve been using Excel to work on SEO tasks and have found it to be very useful. I wanted to share some SEO tools for excel that can help.

    SEO Tools for Excel
    This is an addon for excel provided by Niels Bosma and can be found at http://nielsbosma.se/projects/seotools/download/. You can really do a lot of cool stuff with this addon. For instance you can create score card reports, do domain research, perform onpage analysis, and even import data from Google analytics. You can also monitor social media efforts and work with data in MjesticSEO or SEOlytics. The tool is currently free. All that is required is Microsoft Excel and the full .NET framework for it to work. If you don?t have the framework it is conveniently provided on the download page. You must also give an email in order to download the addon.

    ASAP Utilities
    This isn?t marketed as an SEO add-on but it can be used to automate a lot of routine tasks such as finding and removing duplicate keyword phrases or grouping similar keywords together. This is a paid add-on however you can play with the free version to see if you can find any use for it before spending money. You can download and install the utility here http://www.asap-utilities.com/index.php. There is also a great tutorial on how to use the add-on here, http://www.searchenginejournal.com/asap-utilities-seo-and-productivity-addin-for-excel/23745/.

    Make Links Live
    This tool is actually a macro and not an add-on. It is also useful for only one thing; making links live. That may not sound like anything special but if you have thousands of links in a document and for some reason you want to make them all live when they are not, you are in for some tedious work. This macro lets you do it by clicking one button. The macro for versions of excel older than 2007 can be downloaded here http://seoautomatic.com/downloads/make-links-live-macro.xls. The macro for newer versions of excel can be downloaded here http://www.seoautomatic.com/wp-content/uploads/2011/04/LinksLive.xlam

    URL Tools
    While the SEO tools add-on has a URL extraction tool in it, you can also check out this one. With it you can extract the root domain name from URLs in a spreadsheet. This comes in handy when you have a ton of URLs but just want to see the root domains. You can download the add-on here http://connect.icrossing.co.uk/wp-content/uploads/excel/url_tools.xlam and learn more about how to install it here http://connect.icrossing.co.uk/url-tools-addin-excel_5458.

    Useful Excel Functions
    This isn?t an add-on either but John Doherty shares 8 useful excel functions for SEO work. Some of these may save you a ton of time when working with large amounts of data. His post with all function suggestions can be found here http://www.johnfdoherty.com/excel-functions-seo/

    What SEO tips do you have for Excel? Have you ever used Excel for SEO work?
     
    • Thanks Thanks x 7
  2. Traffic Travis

    Traffic Travis Newbie

    Joined:
    Aug 13, 2012
    Messages:
    37
    Likes Received:
    9
    Home Page:
    Thanks for the useful guide... it's always great to be able to automate tasks with Excel. I especially like the function that makes links go live; really useful for when you're trying to get a whole bunch of 2nd tiers at once.
     
    • Thanks Thanks x 1
  3. m2bsolutions

    m2bsolutions Registered Member

    Joined:
    Jun 27, 2013
    Messages:
    63
    Likes Received:
    8
    Occupation:
    Internet Expert
    Location:
    Ancress walk, York YO23 1BU
    Home Page:
    Thanks to sharing such a very informative post. It is really very helpful.
     
    • Thanks Thanks x 1
  4. _Biju_

    _Biju_ Junior Member

    Joined:
    Nov 18, 2010
    Messages:
    168
    Likes Received:
    67
    Location:
    Here
    Home Page:
    Thanks for this. Never thought to look for excel addons, but now it makes sense. This looks promising and it could eliminate a lot import-exports between excel-scrapebox-mysql

    Bookmarked and I will try this
     
  5. morgan456

    morgan456 Jr. VIP Jr. VIP Premium Member

    Joined:
    Nov 26, 2010
    Messages:
    1,935
    Likes Received:
    240
    Gender:
    Male
    Occupation:
    SEO company
    Great share.....! Will be useful for every one in BHW
     
    • Thanks Thanks x 1
  6. iodalg

    iodalg Registered Member

    Joined:
    Jan 2, 2009
    Messages:
    53
    Likes Received:
    123
    Great list! I use seo for excel and asap utilities and they make your job so much easier.
    I'll take a look at the other tools you have shared!

    Thanks
     
    • Thanks Thanks x 1
  7. TheContentAuthority

    TheContentAuthority Elite Member Premium Member

    Joined:
    Mar 27, 2012
    Messages:
    1,756
    Likes Received:
    1,060
    Occupation:
    President of The Content Authority
    Location:
    Pittsburgh, PA
    Home Page:
    No problem,

    Another thing you might be interested in that also involves excel is SEO4Firefox. You can download a ton of information about domains linking to your site or about your URLs and import it into an excel spread sheet. A drawback is that you have to get the data to show up in SERPs by clicking question marks next to respective values but once its in a CSV file, things like PR, Alexa rank, dmoz info, and a bunch of other stuff are all in columns next to URLs.
     
  8. seocrab

    seocrab Senior Member

    Joined:
    May 2, 2013
    Messages:
    969
    Likes Received:
    824
    Occupation:
    seo freelancer
    Location:
    UK
    only just started using excel addons so this is a really useful list for me, thank you for putting it together!
     
  9. natrajseo

    natrajseo Newbie

    Joined:
    Jul 25, 2013
    Messages:
    10
    Likes Received:
    2
    Occupation:
    Associate SEO
    Location:
    Bangalore
    Thanks a lot :) for a wonderful tool to use in excel for SEO professionals. I will get back to you with some question and clarification on the above mention tool.