Some time ago, we had a Microsoft Excel macro developed that would automatically make up to 10,000 rows of links “live” in a spreadsheet, the way they should work in Excel anyway.
In 2011 we released this free Add-in for Excel, putting a one-click button (Excel 2007 or 2010) right on the data tab. One click makes dozens, or even thousands of links all “clickable”. No signup, no opt-in, no mailing list – just free.
All you do is highlight the cells containing the text (which should have been links in the first place, Microsoft!) and press the button. It’s pretty easy and is guaranteed to save you a TON of time if you check a lot of backlinks from spreadsheets.
The wait it USED to work, before a recent Microsoft Office update, was that it would do the whole spreadsheet with one click, even if you had in multiple sections within multiple columns, etc. but now you have to highlight each link batch and press the button. Oh well.
Detailed steps for installation and use are below (or watch the 3 minute video in the top right):
2. After downloading the Add-in, to install it, open Microsoft Excel 2007 or 2010, and go to the top left “Office” circle, and then to the bottom for Excel Options
3. Go to the add-ins button, ensure that Excel Add-ins is selected, and hit GO
4. Browse to wherever you saved it, and install it
5. Access the new Make Links Live button on the data tab, and enjoy!
Older Macro Version for Excel 2k – 2003:
(For those that use older versions of Office, you can still get the macro and all of the original instructions and the macro download are below… It will NOT add a button, and the macro is tedious by comparison, since you have to install it for on every spread sheet)
Isn’t it a shame that MS Excel is just “too stupid” to do this automatically? That’s why we’ve made a spreadsheet with the embedded macro for our members.
Directions for use:
1. Download the spreadsheet (at the bottom of this page after login). When you open it, note the “security” warning that will appear (in Excel 2007) above column A.
This “warning” simply tells you there’s a macro that you need to enable.
2. Hit “Options” to enable the macro by choosing “Enable This Content” and checking the radio button that says “Enable macros in this document”.
3. Import or paste your links into an empty version of the spreadsheet. Currently, in the file you download, column A is labeled for URL’s, but thats not a requirement, so feel free to change it.
4. Then all you have to do is click on the top link in the column that you wish to “activate”, and press the button to make all of your links instantly live.
5. Feel free to leave comments about this tool here and/or Stumble, Digg, etc. below.
Download the OLD MACRO HERE for the above instructions.