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
-
Huge Drop in External Links
Hello, My total external links dropped from 900 to zero on a site that I've had running for about 10 years. What could possibly cause this? Thanks, Joe
Technical SEO | | Joe20130 -
No PA and no DA and no back links.
Hello Friends, I am having some problem in my website. I hosted this before 4 months. I have done some seo work related to back links. But when I see in opensiteexplorer than it does not show any back links even It shows 1 DA and 1 PA but why?
Technical SEO | | docbeans0 -
Spammy nofollow links
Hello, One of our clients - a cleaning business - has a heck of a lot of spammy nofollow links pointing to their site. The majority of the links are from comments or 'pingbacks', most with the anchor text 'cheap nfl jerseys' or 'cyber monday ugg boots'. After researching the subject of spammy nofollow links, it seems there is a lot of uncertainty regarding the negative affect these could have on your SEO efforts. So I guess my question to the community is: if your site was suddenly hit by a plethora of spammy nofollow links, what would you do and why? Cheers, Lewis
Technical SEO | | PeaSoupDigital0 -
404's in WMT are old pages and referrer links no longer linking to them.
Within the last 6 days, Google Webmaster Tools has shown a jump in 404's - around 7000. The 404 pages are from our old browse from an old platform, we no longer use them or link to them. I don't know how Google is finding these pages, when I check the referrer links, they are either 404's themselves or the page exists but the link to the 404 in question is not on the page or in the source code. The sitemap is also often referenced as a referrer but these links are definitely not in our sitemap and haven't been for some time. So it looks to me like the referrer data is outdated. Is that possible? But somehow these pages are still being found, any ideas on how I can diagnose the problem and find out how google is finding them?
Technical SEO | | rock220 -
Number of links you should have on a taxonomy term??
According to SeoMoz, my taxonomy terms contain more than 100 links (links to articles in my case) and it tells me that I should reduce it. I have seen a video by Matt Cutts, the google software engineer, and in that video he said that Google's engine has dramatically improved ever since and 100 is not the limit anymore. What do you guys think is the best practice here? To clarify the subject even more: I want to learn this from link juice perspective, does it effect how link juice is distributed? Let's say I have 5 taxonomy terms and all of them have 200 articles and these 5 terms are listed on the home page of a PR7 website. In this case some of the PR will be passed to these 5 taxonomy terms. However, if I increase taxonomy terms to 10, then i will reduce links to 100, but the PR will be distributed even more. This means each taxonomy term will have even less PR value. Am I wrong? Any ideas?
Technical SEO | | mertsevinc0 -
Explain Competitive Link Analysis
Hi all...bit of a newbie into the SEO world! So excuse me if this question makes me sound simple 🙂 Basically we have recently had a link analysis done on our site but I'm finding it a little bit difficuilt to actually understand what it all means. What are followed and nofollowed links? What is the sort of ratio needed between the two for best results. And my next question being what are followed linking root domains and nofollowed linking root domains?
Technical SEO | | cttgroup0 -
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