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
-
Too Many On-Page Links?
How much would this affect my page ranks performance? There are many Too Many On-Page Links? warning on my campaign. should I address this issue right away to fix it or leave it as it would not matter seriously ? I've looked at some of the pages and think all of them are necessary. Could someone help me? Thanks!
Technical SEO | | LauraHT0 -
How do I remove Links to my website???
Hi Guys, Please can anyone help!! Can anyone tell me how on earth I can remove links to my website? My website has been hit by the new penguin update and the company that was doing my SEO seems to have built a lot of spammy links!! How can I remove these links??? Please can anyone help Thanks Gareth
Technical SEO | | GAZ090 -
Nofollow links if you have more than one link on a page to the same destination.
Hi, I am wondering if someone can confirm that its best practice to have nofollow on secondary links on a page. For instance the contact page may have a link in the navigation and in the the blurb down the page have another link to the contact page saying contact us here etc.. So in this instance i would put a nofollow on the secondary link in the blurb would this be the best way to impliment this. Many thanks Chris
Technical SEO | | InteractiveRed670 -
When criteria do you use for external linking?
When linking out to external sources what criteria do you use? Also, do you ever add the URL in plain text instead to conserve link juice?
Technical SEO | | Charlessipe0 -
If people link to you incorrectly, does it hurt you?
In Google WM tools I'm seeing so many 404 crawl errors but they're all from other sites linking to us incorrectly, which I can't do anything about. Will this hurt us somehow as far as SEO goes? The logical thing would be that it would hurt the site doiing the linking but it does come up in OUR WM tools, so it makes me wonder.
Technical SEO | | UnderRugSwept0 -
OSE - still showing me links are there when they are not?
Has anyone else had the issue for a couple of months now where ose is showing links that are live when they are not. I am doing seo for a big e-commerce website so it is important i can find out what the anchor text distribution is for the domain. How is this possible when ose shows me links which are not live? There's been 2 or 3 updates and still showing expired links in our back-link profile. This is very frustrating and has led me to see if anyone else can recommend an alternative which is more up to date? And yes before seomoz reply, i know you only update a certain percentage of the web.
Technical SEO | | pauledwards0 -
Link Building Advice
Hi Everyone, I have just joined the community and am looking for some help regards Offsite SEO and Link Building. I have done some basic SEO on my website 'Marketing Quotes' Added to web directories (although I am told they do not carry much weight) I have written content and articles around them (on ezine, squidoo etc.) I have written unique content for the site I have done guest posting on blogs Not sure what to do next though for high power links. I did notice a Q&A on contacting webmasters and asking for links (after building a relationship) but wondered if there was anything (offsite wise) that I have missed out? Appreciate any advice. Regards, David
Technical SEO | | Marketingquotes0 -
No. of links on a page
Is it true that If there is a huge number of links from the source page then each link will provide very little value in terms of passing link juice ?
Technical SEO | | seoug_20050