Find broken links in Excel?
-
Hello,
I have a large list of URL's in an excel sheet and I am looking for a way to check them for 404 errors. Please help!
- Adam
-
If this is something you check for often (which it probably should be), you might want to check out a program like Screaming Frog. That makes it really easy to find 404s and any other response codes.
-
If you want to use Excel, check out this macro which should be what you're looking for - http://stackoverflow.com/questions/1118221/sort-dead-hyperlinks-in-excel-with-vba
-
Do a Google Search for "bulk url checker" and a ton of results come up (most you can export back to excel).
Also, possible solution here: http://www.mrexcel.com/forum/excel-questions/507688-excel-url-check-help.html
Got a burning SEO question?
Subscribe to Moz Pro to gain full access to Q&A, answer questions, and ask your own.
Browse Questions
Explore more categories
-
Moz Tools
Chat with the community about the Moz tools.
-
SEO Tactics
Discuss the SEO process with fellow marketers
-
Community
Discuss industry events, jobs, and news!
-
Digital Marketing
Chat about tactics outside of SEO
-
Research & Trends
Dive into research and trends in the search industry.
-
Support
Connect on product support and feature requests.
Related Questions
-
Broken URL Links
Hi everyone, I have a question regarding broken URL links on my website. Late last year I move my site from an old platform to Shopify, and now have broken URL links giving out 4xx errors. When I look at Moz Pro>Campaigns>Insights>links, I can see the top broken URL links, however there is a difference if copy & paste URL directly from Moz Pro and by Export CSV file. For example below, If I copy and paste links direct from Moz Pro, it has the “http://” in front as below: http://www.thehairhub.com.au/WebRoot/ecshared01/Shops/thehairhub/57F3/1D8F/D244/C675/E27D/AC10/003F/35AD/manic-panic-colours.jpg But when I export the list of links as an CSV file, the http:// is removed. www.thehairhub.com.au/WebRoot/ecshared01/Shops/thehairhub/57F3/1D8F/D244/C675/E27D/AC10/003F/35AD/manic-panic-colours.jpg Another Example below: By copy & paste URL direct from Moz Pro
Technical SEO | | johnwall
http://thehairhub.com.au/Shop-Brands/Vitafive-CPR/CPR-Rescue By export CSV file.
thehairhub.com.au/Shop-Brands/Vitafive-CPR/CPR-Rescue Which one do I use to enter into the “Redirect From” field in Shopify URL Redirects? Do I need to have the http:// in front of the URL? Or is it not required for redirects to work? Kind Regards, John Wall
The Hair Hub0 -
No follow links on a blog
Hi On our blog, we have a section called 'Tags'. I have just noticed that these links are all "no follow" links. The tags section does appear on every single page on the blog - is this recommend to have them as 'no follow' links or should I get our developer to change them. Thanks
Technical SEO | | Andy-Halliday0 -
Links in a Flash document
How do I tell if a link in a Flash document is follow or nofollow? Or doesn't it matter? (I just found out that my company placed an advertorial in a Flash publication and I want to make sure it doesn't wind up as a paid, followed link.) Thank you!
Technical SEO | | Linda-Vassily0 -
Hot Linking
We recently noticed that our website www.efurniturehouse.com is being hot linked by axsoris.com a Dutch website with many malware issue. Any suggestions how to proceed? Thanks in advance Tony
Technical SEO | | OCFurniture1 -
How do you take down a link
Salut from Sunny wetherby UK 🙂 Having just watched a whiteboard fri clip all about the "Penguin Update" i want to know how to take down a link. I feel a site ive been working on has been pecked by the penguin. I did build inbound links on a specific commercial term and shiver me timbers is dropped oof the SERPS from top 5 to ziltch, yiles!! So my questiuon is please:
Technical SEO | | Nightwing
if you find an inbound link using a target term how do you kill it? Thanks in advance :_)0 -
How not to lose link juice when linking to thousands of PDF guides?
Hi All, I run an e-commerce website with thousands of products.
Technical SEO | | BeytzNet
In each product page I have a link to a PDF guide of that product. Currently we link to it with a "nofollow" <a href="">tag.</a> <a href="">Should we change it to window.open in order not to lose link juice? Thanks</a>0 -
Link to overall brand pages
On our website we have two ways to get in a brand environment. We have general brand pages and brand pages divided by category. At this moment the category brand pages get the most SEO value, because we have a link on our homepage to these pages (via the mega dropdown). The problem is that we would like to assign the SEO value to the general brand pages (with all the articles) instead of the category brand pages (with only articles within a category). We prefer to optimize the general brand page without a link to this page on the homepage for now. for example; Those two pages have the most SEO value
Technical SEO | | eCommerceSEO
www.debijenkorf.nl/herenmode/diesel
www.debijenkorf.nl/damesmode/diesel but we would like to assign value to;
www.debijenkorf.nl/diesel Do you have a solution for this problem? Thank you in advance! Kind regards,0 -
Links from Youtube Channel
I stumbled across this blog post: http://garyreid.com/youtube-removes-nofollow/ and also this one : http://www.kevin-barnes.com/youtube-secret-authority-loophole/ which talks about no-follow links from your Youtube Channel Page. We've setup a Youtube channel, and have begun updating it regularly, however the link appears to be a redirect-type link -presumably this means no link juice is passed? The code of the link on our Youtube channel: http://www.pretavoir.co.uk The second blog mentions building PA on your Youtube channel by commenting on other videos which then links back to your channel page - if that juice can't go to your site, then I assume the technique is of limited use? Apart from boosting your Youtube Channel's rankings of course, which I guess can't hurt.
Technical SEO | | seanmccauley0