Welcome to WebmasterWorld Guest from 54.145.208.64

Forum Moderators: open

Message Too Old, No Replies

Need to validate urls on spreadsheet?

Is there a free url checker for mass upload spreadsheet?

   
2:37 pm on Jul 17, 2003 (gmt 0)

10+ Year Member



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.
2:54 pm on Jul 17, 2003 (gmt 0)

WebmasterWorld Senior Member 10+ Year Member



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)

10+ Year Member



You could also export the spreadsheet as a HTML file and run Xenu over it.
6:44 pm on Jul 17, 2003 (gmt 0)

10+ Year Member



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)

WebmasterWorld Senior Member 10+ Year Member



Format/Style/Hyperlink....
1:53 pm on Jul 18, 2003 (gmt 0)

WebmasterWorld Senior Member 10+ Year Member



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)

10+ Year Member



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)

10+ Year Member



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:

Example:

column A: URL
column B: anchor text
column C: some other text

expanded to

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>