5
If i have a list of URLS (a column in excel), what is the easiest way to test all of them for 404? Currently, I just have to click each one, look at the page, and close the tab/window, and this is a pain.
Thanks!
xdumaine
Posted 2011-04-01T12:55:23.253
Reputation: 2 281
1
Someone posted quite a good VBA solution over on Stack Overflow.
Gaff
Posted 2011-04-01T12:55:23.253
Reputation: 16 863
0
If you have large number of Excel Sheets that contains URLs,You can use this Desktop software Excel Url Validator to validate URLs and find broken links.The software can automatically find URLs from a Bunch of Excel Spreadshets,Validate the links and produce Individual Reports for Each file processed.You can download it from http://excelurlvalidator.com
Disclaimer: I represent the Company that develops the product.
james
Posted 2011-04-01T12:55:23.253
Reputation: 1
@xdumaine pretty sure you could just script that with wget and grep for your new requirements. – Darren – 2017-08-15T19:57:04.973
@darren this was on Windows, using SharePoint and excel, 6 years ago. But thanks. – xdumaine – 2017-08-16T11:53:56.297
@xdumaine oh, haha. I didn’t look at the date. It got bumped to the top of the question list for some reason. I assumed it was new. – Darren – 2017-08-16T12:40:58.653
that does exactly what I originally wanted. Unfortunately, turns out, I don't actually need to look for 404s. I'm using this on sharepoint sites, which doesn't return a 404 for sites not configured, but instead displays a page that says "The Web site that is referenced here is not in the configuration database." - so I'll need to find an alternate solution and potentially ask a new question. – xdumaine – 2011-04-01T13:21:09.187