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.



Someone posted quite a good VBA solution over on Stack Overflow.

  • 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 Apr 1 '11 at 13:21
  • @xdumaine pretty sure you could just script that with wget and grep for your new requirements. – Darren Aug 15 '17 at 19:57
  • @darren this was on Windows, using SharePoint and excel, 6 years ago. But thanks. – xdumaine Aug 16 '17 at 11:53
  • @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 Aug 16 '17 at 12:40

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.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.