[Tip] Cool Excel Add-Ons for SEO

3 replies
  • SEO
  • |
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 with SEO work.

SEO Tools for Excel
This is an addon for excel provided by Niels Bosma and can be found at Download SeoTools for Excel | Niels Bosma. 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 ASAP Utilities for Excel - The essential add-in for Excel users. FREE excel tools and macros to save time. Download Excel tools. There is also a great tutorial on how to use the add-on here, ASAP Utilities - SEO and Productivity Addin for Excel | Search Engine Journal.

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/ma...live-macro.xls. The macro for newer versions of excel can be downloaded here http://www.seoautomatic.com/wp-conte...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-co...url_tools.xlam and learn more about how to install it here URL Tools Add-In for Excel - iCrossing.

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 Eight Useful Excel Functions for SEO | John Doherty

What SEO tips do you have for Excel? Have you ever used Excel for SEO work?
#addons #cool #excel #seo #tip
  • Profile picture of the author Nishat
    NIce tools thanks for share
    {{ DiscussionBoard.errors[8319873].message }}
    • Originally Posted by Nishat View Post

      NIce tools thanks for share
      No problem, glad you found it useful!
      Signature
      Outsource to the experts...

      We customize your Blog, eBook, Press Release and Sale Copy content with your message.

      {{ DiscussionBoard.errors[8321388].message }}
  • Profile picture of the author It Is Me
    Originally Posted by TheContentAuthority View Post

    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/ma...live-macro.xls. The macro for newer versions of excel can be downloaded here http://www.seoautomatic.com/wp-conte...LinksLive.xlam
    This is very useful.
    In my service I have to paste tens of bookmarks in an excel sheet and double click on everyone to make them live.
    Now, I have to just select the links and click on one button and all it done.
    Thanks a lot for sharing this!

    P.S:For others here are the instructions on to install this add in Make Links Live - Excel | SEO Automatic
    Signature

    --
    AdRenter.com, AudioVideoGraphics.Com, ChooseHosts.com, CommentSubmitter.com, CommissionGate.com, CustomBacklinks.com, IncredibleLists.com.... Selling On GetTheseDomains.com
    --
    Internet Marketers Need These Products - IMersNeed.com

    {{ DiscussionBoard.errors[8322727].message }}

Trending Topics