About me

Friday, February 18, 2011

Check external links in excel

I thought
Testing or checking the hyperlinks which are navigating to external web page is a tedious task.

Searched for a tool very seriously which can test all the hyperlinks in excel and produce a report of the broken links.

Did not found any tool which can take excel with hyperlinks as the input and produce report.

Requirement was - An excel is available with many hyperlinks. I need to check each link and prepare a report of which one is working and which one is not working.

Finally got a solution

1. Copy only links from the excel which are to be tested to new excel sheet.
2. New excel sheet should not have any labels or any cells containing values other than hyperlinks type.
3. Save the excel as web page.
4. It will be saved as .html page.
5. Input this html page to any link checker which takes the web page as input.
6. See that "checking local links" option is set in the link checker.
7. This HTML page should be given as a file input to link checker rather than giving it with http protocol.
8. Obviously you will get the report from the link checker.
9. If the link checker has the option to save the report in excel then its good and best for you.

Enjoy.............


3 comments:

Chris said...

"5. Input this html page to any link checker which takes the web page as input."

Any recommendation as to which link checkers do this type of command?

Thanks

Joshna Samala said...

Hi Chris,

Link checker tool Xenu can take the html page as input

Software Testing said...

Very Nice and useful article. Thanks for sharing this.
Thanks for the article Ian, excellent stuff.
You can get info on cross browser testing tools as well with some guidelines with different.

Post a Comment