[Tip] Cool Excel Add-Ons for SEO
- SEO |
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?
We customize your Blog, eBook, Press Release and Sale Copy content with your message.
--
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