Posts

Showing posts with the label how to check hyperlinks in excel

Amazon offers

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