[Tip] Cool Excel Add-Ons for SEO

 

Results 1 to 9 of 9
Iíve been using Excel to work on SEO tasks and have found it to be ...
  1. #1
    TheContentAuthority's Avatar
    TheContentAuthority is offline Elite Member
    Join Date
    Mar 2012
    Location
    Pittsburgh, PA
    Posts
    1,758
    Thanks
    169
    Thanked 1,020 Times in 688 Posts

    Default [Tip] Cool Excel Add-Ons for 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.

    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/a...r-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/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 http://connect.icrossing.co.uk/url-t...din-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?

  2. The Following 7 Users Say Thank You to TheContentAuthority For This Useful Post:

    crusher (07-25-2013), natrajseo (07-26-2013), notyourmatey (07-25-2013), phracktl (07-25-2013), seocrab (07-26-2013), Treeofl1 (07-24-2013), _Biju_ (07-25-2013)




  3. #2
    Join Date
    Aug 2012
    Posts
    37
    Thanks
    2
    Thanked 8 Times in 7 Posts

    Default Re: [Tip] Cool Excel Add-Ons for SEO

    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.

  4. The Following User Says Thank You to Traffic Travis For This Useful Post:

    TheContentAuthority (07-25-2013)

  5. #3
    m2bsolutions's Avatar
    m2bsolutions is offline Registered Member
    Join Date
    Jun 2013
    Location
    Ancress walk, York YO23 1BU
    Age
    27
    Posts
    64
    Thanks
    0
    Thanked 7 Times in 7 Posts

    Default Re: [Tip] Cool Excel Add-Ons for SEO

    Thanks to sharing such a very informative post. It is really very helpful.

  6. The Following User Says Thank You to m2bsolutions For This Useful Post:

    TheContentAuthority (07-25-2013)

  7. #4
    _Biju_'s Avatar
    _Biju_ is offline Junior Member
    Join Date
    Nov 2010
    Location
    Here
    Posts
    165
    Thanks
    34
    Thanked 63 Times in 41 Posts

    Default Re: [Tip] Cool Excel Add-Ons for SEO

    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

  8. #5
    morgan456's Avatar
    morgan456 is offline Jr. VIP
    Join Date
    Nov 2010
    Posts
    1,473
    Thanks
    424
    Thanked 196 Times in 132 Posts

    Default Re: [Tip] Cool Excel Add-Ons for SEO

    Great share.....! Will be useful for every one in BHW

  9. The Following User Says Thank You to morgan456 For This Useful Post:

    TheContentAuthority (07-25-2013)

  10. #6
    iodalg is offline Registered Member
    Join Date
    Jan 2009
    Posts
    53
    Thanks
    11
    Thanked 123 Times in 14 Posts

    Default Re: [Tip] Cool Excel Add-Ons for SEO

    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

  11. The Following User Says Thank You to iodalg For This Useful Post:

    TheContentAuthority (07-25-2013)

  12. #7
    TheContentAuthority's Avatar
    TheContentAuthority is offline Elite Member
    Join Date
    Mar 2012
    Location
    Pittsburgh, PA
    Posts
    1,758
    Thanks
    169
    Thanked 1,020 Times in 688 Posts

    Default Re: [Tip] Cool Excel Add-Ons for SEO

    Quote Originally Posted by _Biju_ View Post
    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
    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.

  13. #8
    seocrab's Avatar
    seocrab is offline Senior Member
    Join Date
    May 2013
    Location
    UK
    Posts
    969
    Thanks
    698
    Thanked 763 Times in 299 Posts

    Default Re: [Tip] Cool Excel Add-Ons for SEO

    only just started using excel addons so this is a really useful list for me, thank you for putting it together!

  14. #9
    natrajseo's Avatar
    natrajseo is offline Newbies
    Join Date
    Jul 2013
    Location
    Bangalore
    Posts
    10
    Thanks
    6
    Thanked 2 Times in 2 Posts

    Default Re: [Tip] Cool Excel Add-Ons for SEO

    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.


Similar Threads

  1. Help with Excel.
    By deathlyreaver in forum Black Hat SEO
    Replies: 4
    Last Post: 05-19-2011, 05:29 AM
  2. Need some help in Excel
    By virtualc08 in forum BlackHat Lounge
    Replies: 4
    Last Post: 02-14-2011, 02:55 AM
  3. $20 Excel Help
    By chaser232 in forum Black Hat SEO
    Replies: 1
    Last Post: 12-10-2010, 05:26 AM
  4. Need Some Excel Macros Made (VBA for Excel)
    By curiosity in forum Hire a Freelancer
    Replies: 5
    Last Post: 11-12-2009, 03:41 AM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  




BlackHatWorld on Twitter BlackHatWorld on FaceBook


1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108