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
-
Google UK and the slog of Link building
Background:
Technical SEO | | Brinley
I have a number of sites built using the open eCommerce software zen cart. One of these sites was penalised by the original Penguin algorithm back in April 24, 2012. The reason for the panalty was that two ecommerce sites in Hong kong had a link to the above site in the footer of their 2000 & 4000 product website. I have no idea why the site had these links and even though I did contact them a few months before the Penguin massacre asking them to remove the footer link I was technically unaware of the ticking time bomb that they presented. The result, as is now engrained in SEO history, was that the site was moved to sit alongside Googles equivalent of the restaurant at the end of the universe and stayed there for 2 years until April 2014.
As I had never indulged in link building for the simple reason that I found it laborious I was obviously infuriated with the resulting loss of revenue but that was balanced with an understanding that I had not kept pace with the changing landscape of SEO according to Google. The quest I am now on is to increase my 3 sites profile on the web without getting another spanking from Google in the near future. The problem I have is that white hat today may well be black hat tomorrow. (I can recall the days when Google said links are good and everyone went out and asked other websites to link with them and look where that led.) So do I ignore actively cultivating links as some suggest and look to produce good content (which is quite difficult when you make mugs and candles by the way.) or do you go out and look to intentionally build links by studying competitors links, reviewing link opportunity or get bloggers to review products. For a small lifestyle entrepreneur like myself, the ever changing seo landscape and the amount of time & effort it requires is slowly and inevitably pushing us back out to that restaurant mentioned earlier. If only Google had a little brother that was designed purely for small businesses - like it was in the good old days before the dinosaur that is big business grunt and thought hmmm! whats that?
And if there were such a thing I would add a caveat that it would be illegal to generate pointless amount of cyber content because the web is becoming something akin to a landfill. Which leaves me nowhere really - but I think I am okay with that. Waiter !!0 -
301 and 302 for same link
Just trying to find out if this may be the root of a slight traffic dip and also if we should be redirecting differently. We relaunched and did 301 redirects to the new site, initially. Then, we decided to change from http to https. Our HTTP status now looks like this when using the MozBar: HTTP/1.1 301 Moved Permanently – http://site.com/oldurl
Technical SEO | | MichaelEka
HTTP/1.1 302 Found – https://site.com/oldurl
HTTP/1.1 200 OK - https://site.com/new Should we be changing that 302 to a 301? Are we losing link equity due to this? Thanks.0 -
Removal of all low PR links
I have a lot of old directory links which where done years ago, most I think will be effecting my site. Is there away to find them all ie through open explorer and then remove them in one go?
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 -
How to find out if I have been penalized?
I have launched a new website beginning January this year and have seen slowly more and more traffic coming from google to the website until the 20th of March where suddenly there are no more visitors from the google search engine. The only traffic left is from google images, social networks or other search engines. Without visitors from google search this reduces our overall traffic by ~66%. I can't easily find anymore our website in the search results of google by using terms which we usually ranked quite well. Nevertheless, the website is still indexed as I can find it using the "site:" search query. In google webmaster tools there are no messages and we have only been doing a bit of link building on website and blog directories (nothing excessive and nothing paid neither). Is there any way to find out if google penalized my website? I guess it has... and what would be the best thing to do right now? The website is hellasholiday (dot) com Thanks in advance for your idea and suggestions
Technical SEO | | socialtowards0 -
How do you find bad links to your site?
My website has around 900 incoming links and I have a Google 50 penalty that is sitewide. I have been doing research and from what I can see is that the 50 penalty is usually associated with scetchy links. The penalty started last year. I had about 40 related domains to my main site and each had a simple one page site with a link to the main site. (I know I screwed up) I cleaned up all of those links by removing them. The single page site still exist, but they have no links and several of them still rank very well. I also had an outside SEO person that bought a few links. I came clean with Google and told them everything. I gave them all of my sites and that the SEO person had bought links. I gave them full disclosure and removed everything. I have one site that I can't get the link removed from. I have contacted them numerous times to remove the link and I get no response. I am curious if anyone has had a simular experience and how they corrected the situation. Another issue is that my site is "thin" because its an ecommerce affiliate site and full of affiliate links. I work in the costume market. I'm also afraid that I have other bad links pointing to my site. Dooes anyone know of a tool to identify bad links that Google may be penalizing me for at this time. Here is Google's latest denial of my reconsideration request. Dear site owner or webmaster of XXXXXXXXX.com. We received a request from a site owner to reconsider XXXXXXXX.com for compliance with Google's Webmaster Guidelines. We've reviewed your site and we believe that some or all of your pages still violate our quality guidelines. In order to preserve the quality of our search engine, pages from XXXXXXXXXX.com may not appear or may not rank as highly in Google's search results, or may otherwise be considered to be less trustworthy than sites which follow the quality guidelines. If you wish to be reconsidered again, please correct or remove all pages that are outside our quality guidelines. When such changes have been made, please visit https://www.google.com/webmasters/tools/reconsideration?hl=en and resubmit your site for reconsideration. If you have additional questions about how to resolve this issue, please see our Webmaster Help Forum for support. Sincerely, Google Search Quality
Technical SEO | | tadden0 -
How to find artificial or unnatural links in OSE?
Hi, I just got a message from Google Webmaster Tools telling that there are "artificial or unnatural links" pointing to one of my subdomains, and that I should investigate and submit my site for reconsideration. The subdomain in question has inbound links from 4K linking root domains. We are a certificate authority (we provide SSL certificates) so the majority of those links come from the site seal that customers place on their secure pages. We sell certificates to a full spectrum site types, from all sizes of ecommerce sites to .edu, .gov, and even adult. That said, our linking root domains have always been a mixed bunch, which tells me that these offending links were recently added. Here are my questions: Is it possible to slice my link reports with some sort of time element, so that I can narrow the search to only the newest inbound links? How else might I use OSE to find these "artificial or unnatural links"? Are there any particular attributes I should be looking for in a linking root domain that might suggest it's seen by Google as "artificial or unnatural". Any help with any aspect of this issue would be greatly appreciated. Thanks, Dennis p.s. I should probably state that I've never bought links or participated in link schemes.
Technical SEO | | dennis.globalsign0 -
Optimum Number of Links on Any Given Page
One of the guidelines you provide stipulates: "You should avoid having too many (roughly defined as more than 100) hyperlinks on any given page. When search engine spiders crawl the Internet they are limited by technology resources and are only able to crawl a certain number of links per webpage. In addition, search engine algorithms divide the value of some popularity metrics by the amount of links on a given page. This means that each of the pages being linked to from a given page are also affected by the number of links on the linking page. For these reasons, we recommend you include less than 100 links per page to ensure that they are all crawled, though if your pages have a high page authority, search engines will usually follow more links." As far as these 100 links are concerned, is this in reference to ALL links including outbound, internal, etc? Or is this referring to only outbound links to other sites?
Technical SEO | | johncmmc0