HTML Link Building Using Excel

While building a link list for my blogroll page (see Blogs I Read), I needed a way to create the list of links. The prospect of building all of the links by hand is pretty exhausting (yes, even the thought), so why not leverage Excel's capabilities?

First I took a list of the links and put them in a worksheet in column A. Then I put the site name in column B. Here is the formula to create the link:

=<a rel="nofollow" href=""&A2&" title="&B2&"></a>"

Yes, I nofollow external links (except in comments).

This technique could be very useful, if you have a list of websites and want to turn them into HTML links, just paste in the above formula and adjust the cell references. I created a sample with the sites from that page and the formula filled down to create the links.

Download sample workbook


About JP

I'm just an average guy who writes VBA code for a living. This is my personal blog. Excel and Outlook are my thing, with a sprinkle of Access and Word here and there. Follow this space to learn more about VBA. Keep Reading »

Related Articles:

Share This Article:

Share and bookmark this articledelicious buttonfacebook buttonlinkedin buttonstumbleupon buttontwitter button

comment bubble 4 Comment(s) on HTML Link Building Using Excel:

  1. WordPress has the capability to build a blogroll list. I took the PHP out of the sidebar ans stuck it into the body of a page, did a little formatting (very little), and it was done. No need to build links in another application. I don't know if it does nofollow, but I pretty much let links get followed anyway. I may change this if I read up on SEO and find it makes much difference.

  2. My theme doesn't support widgets, and I don't feel like finding one that does (or trying to fix it), so I have to build the list by hand. And this is one area where I don't mind doing things (at least partially) manually, because the list comes from FeedDemon (my newsreader). When I paste PHP into a page, it just echoes the code to the screen, i.e. it doesn't actually execute. How do you do it?

    The nofollow thing is really to keep your blog juice. It instructs the major search engines (Google, Yahoo, MSN) to not consider the link to be a 'vote' for that page.

    So for those sites (like Wikipedia) that sponge your Pagerank by nofollowing your links, you can do it back to them by not giving them any link credit.

    I remove it in the comments only, so that repeat commenters (i.e. the people adding value to your blog) are "rewarded" with a link to their blog that the spiders will follow.

    So comment away 8)

  3. No widgets necessary, it's straight php. I found the php in the sidebar that listed the links (blogs), and pasted it into the html behind a plain page.

  4. Thank you for this posting. I was stuck with a problem in my formula and this post solved my problem.

    Thank you!

This article is closed to any future comments.
Peltier Tech Charting Utilities for Excel