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
-
How to Break Up a Page with Too Many Links
My client has a live page with 100+ links subdivided into 10 categories that each have great potential keyword targeting opportunities. I'd like to improve this page and my intuition is to split it into 11 pages, one page with links to all the others and a bit of content about each. Here's an example of the potential IA: Dog Rescue Groups
Technical SEO | | elenarox
Golden Retriever Rescue - description
Poodle Rescue - description
Cocker Spaniel Rescue - description
Poodle Rescue - description
Labrador Retriever Rescue - description
etc. --------- Golden Retriever Rescue
Link 1 - description
Link 2 - description
Link 3 - description Is this a good idea and will I see a big traffic drop overall at first? Also, these are all internal links, not external.0 -
Link juice and max number of links clarification
I understand roughly that "Link Juice" is passed by dividing PR by the number of links on a page. I also understand the juice available is reduced by some portion on each iteration. 50 PR page 10 links on page 5 * .9 = 4.5 PR goes to each link. Correct? If so and knowing Google stops counting links somewhere around 100, how would it impact the flow to have over 100 links? IE 50 PR page 150 links on the page .33 *.9 = .29PR to each link BUT only for 100 of them. After that, the juice is just lost? Also, I assume Google, to the best of its ability, organizes the links in order of importance such that content links are counted before footer links etc.
Technical SEO | | sprynewmedia0 -
Removing links - Best practice
Hi I have noticed on webmaster that I have a lot of links to my sites from link building directories. Either I did this many years a go or somehow they've linked to me. Would links to link building directories harm my site? i.e linkspurt.com pingerati.net I have quite a few and just wondering what to do with them. Also I have some customer sites which are massive one site has 38,000 links coming to my site as I have put a credit that I built the site with a link back to mine. It has a low score in Google would this also harm my site? Any advise would be appreciated.
Technical SEO | | Cocoonfxmedia0 -
Forms and link juice
On product listing page on e-commerce site We use POST forms as 'Add To Cart' buttons. Because of that We have dozens (~40-80) forms on any product listing page, and two questions regarding them: Does these forms affect link juice of other links on the page? Are there cases when forms are somehow counted by Google as links? Regards, Lucek
Technical SEO | | lucek0 -
Drop Down Menu - Link Juice Depletion
Hi, We have a site with 7 top level sections all of which contain a large number of subsections which may then contain further sub sections. To try and ensure the best user experience we have a top navigation with the 7 top level sections and when hovered a selection of the key sub sections. Although I like this format for the user as it makes it easier for them to find the most important sections / sub sections it does lead to a lot of links within every page on the site. In general each top section has a drop down with approx 10 - 15 subsections. This has therefore lead to SeoMoz's tools issuing its too many internal links warning. Then alongside this I am left wondering if I shouldn’t have to many links to my subsections and whether I would be better off being more selective of when I link to them. For instance I could choose the top 5 sub sections and place a link to them from our homepage and by doing so I would be passing a greater amount of link juice down the line. So I guess my dilemma is between ensuring the user has as easy a time traversing the site as possible whilst I try to keep a close watch on where, and how, our link juice is distributed. One solution I am considering is whether no-follow links could be utilised within the drop down menus? This way I could then have the desired user navigation and I would be in greater control of what pages link to which sub sections. Would that even work? Any advice would be greatly appreciated, Regards, Guy
Technical SEO | | guycampbell1 -
Track outbound links
I would like to track outbound links at http://bit.ly/yYHmbf 1. Shall i add the following code before at the above page What does 100 means in above code ? 2. Then use this for each outgoing link ``` [onClick="recordOutboundLink(this, 'Outbound Links', 'example.com');return false;">](http://www.example.com) ``` [](http://www.example.com) ```[``` http://www.example.com is the outbound link Am i right on both counts ? where should i look for report in GA ? ```](http://www.example.com)
Technical SEO | | seoug_20050 -
IFRAME WIDGET - FOLLOWED LINKS
<iframe style="border: 2px #CCCCCC solid;" src="http://www.cpsc.gov/cgi-bin/javascripts/cpscrss.aspx" title="CPSC RSS Feed" frameborder="0" scrolling="auto" width="224" height="258"></iframe> That is the code my client wants to add to an internal page where we can keep updated news on a specific subject. Only problem is this widget has links within it, these links are "followed". Should i worry about these links being followed? There are quite a few, does anyone know if they will be counted if within an iframe or is there a way to add "no-follow" attribute to them. Can i somehow tell the HTACCESS to add no follows to all links on specific pages? Any thoughts, solutions are greatly appreciated.
Technical SEO | | waqid0 -
Open Site Explorer - Showing No links
Hello, I have ran Link Analysis report in Site Explorer for my client qtmoving.com http://www.opensiteexplorer.org/comparisons?site=www.qtmoving.com These competitors are the top 3 that consistently appear in the Local
Technical SEO | | CohesiveMarketing
Search top 7 or the Local Search Blended SERP. I don't understand why I have No Internal Followed Links, no Internal Links, and only 2 external followed and external links. This doesn't make sense to me because I know there are links internally and that there are some sites that link back to us: I'm not sure how this can happen when we have the following sites that
link to us:
http://www.bbb.org/manitoba/business-reviews/moving-storage-companies/quick-transfer-ltd-in-winnipeg-mb-14125
http://www.yelp.ca/biz/quick-transfer-ltd-winnipeg
http://www.ourbis.com/617657-quick-transfer-ltd-winnipeg Your help is greatly appreciated. Thank you, Lyn0
