I have a ppc spreadsheet with several thousand urls that was created some time ago. Due to changes, some of the urls are not working anymore. Rather than manually check each one, is there a free program out there that will run through the sheet and list the bad urls for me? Any help on this appreciated.
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
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?
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>