homepage Welcome to WebmasterWorld Guest from 54.205.106.111
register, free tools, login, search, pro membership, help, library, announcements, recent posts, open posts,
Become a Pro Member
Home / Forums Index / Advertising / Pay Per Click Engines
Forum Library, Charter, Moderator: open

Pay Per Click Engines Forum

    
Need to validate urls on spreadsheet?
Is there a free url checker for mass upload spreadsheet?
latimer




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

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.

 

mattur




msg:1229015
 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.

tschild




msg:1229016
 2:59 pm on Jul 17, 2003 (gmt 0)

You could also export the spreadsheet as a HTML file and run Xenu over it.

latimer




msg:1229017
 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

MrSpeed




msg:1229018
 1:49 pm on Jul 18, 2003 (gmt 0)

Format/Style/Hyperlink....

MrSpeed




msg:1229019
 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.

latimer




msg:1229020
 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?

tschild




msg:1229021
 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:

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>

Global Options:
 top home search open messages active posts  
 

Home / Forums Index / Advertising / Pay Per Click Engines
rss feed

All trademarks and copyrights held by respective owners. Member comments are owned by the poster.
Home ¦ Free Tools ¦ Terms of Service ¦ Privacy Policy ¦ Report Problem ¦ About ¦ Library ¦ Newsletter
WebmasterWorld is a Developer Shed Community owned by Jim Boykin.
© Webmaster World 1996-2014 all rights reserved