| 2:54 pm on Jul 17, 2003 (gmt 0)|
I think Rel Link Checker Lite allows you to import a text file of URLs to check. So you may be able to export from Excel in text format and then import the file into Link Checker. HTH.
| 2:59 pm on Jul 17, 2003 (gmt 0)|
You could also export the spreadsheet as a HTML file and run Xenu over it.
| 6:44 pm on Jul 17, 2003 (gmt 0)|
I saved the excel spreadsheet as web page and uploaded via dreamweaver. Then found out the links are not active on the webpage or in the spreadsheet. I know that excel has the ability to have active hyperlinks but have searched to find out how to make this happen with no luck. Since the links aren't active (although they appear blue and underline) xenu can't follow and validate. Anyone know how to get the links on the spreadsheet active? Is this the problem? thanks for any help
| 1:49 pm on Jul 18, 2003 (gmt 0)|
| 1:53 pm on Jul 18, 2003 (gmt 0)|
Also it seems like you could just cut/paste the columns and it converts the urls to hyperlinks.
| 6:07 pm on Jul 18, 2003 (gmt 0)|
Thanks for all the help. Here is what I have found. The links in excel will not become active unless they end with .com The links I am trying to save as webpage have .cfm and when I copy cfm links into excel they do not become hyperlinks. Using the format/type/hyperlinks as you suggest I can make any text in selected cells appear as hyperlinks with blue underline, but they are not hyperlinks. Also, I noticed that if I use a .com link with the http:// prefix, this will also result in no active link. The only way I get the links is with something ending in .com without [....] Does anyone have any suggestions on how to create a html page from a list of links not ending in .com for xenu?
| 9:42 pm on Jul 18, 2003 (gmt 0)|
I once converted an excel sheet from the (old, not HTML aware) Excel 5 into a html table by inserting the HTML into extra columns and then exporting as text, finally taking the tabs out in Word and topping/tailing the HTML:
column A: URL
column B: anchor text
column C: some other text
column A: <tr><td><a href="
column B: URL (originally column A)
column C: ">
column D: anchor text (originally column B)
column E: </a></td><td>
column F: some other text (originally column C)
column G: </td></tr>