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 not to lose internal link juice?
Hi, I just added some photography content to my site to showcase my skills, specifically 360 virtual tours. I first tried to have those on regular pages and have the 360s in responsive iframes, but it caused usability problems. So I've chosen instead to have a master page with thumbnails that lead to individuals 360's. https://gregmoinephotography.com/360-virtual-tours-hdr-vr-ready/ Links look like that: http://gregmoinephotography.com/wp-content/uploads/2017/11/360/maverick-helicopters/ Each pano takes over the whole page. My concern is losing internal link juice as each pano page doesn't link anywhere. Also, external link juice when people start linking to each 360. What should I do to fix that? Should I just link back to the master page in the body & noscript area, even though content won't be visible? Fine with Google? Lack of content problem? Thank you for reading, and for your help!
Technical SEO | | GregMoine0 -
Trying to find all internal links to a specific page (without index)
Hi guys -- Still waiting on Moz to index a page of mine. We launched a new site over two months ago. In the meantime, I really just need a list of internal links to a specific page because I want to change its URL. Does anybody know how to find that list (of internal links to 1 of my pages) without the Moz index? I appreciate the help!
Technical SEO | | marchexmarketingmcc1 -
Do you still loose 15% of value of inbound links when you redirect your site from http to https (so all inbound links to http are being redirected to https version)?
I know when you redesign your on website, you loose about 15% internally due to the 301 redirects (see moz article: https://mza.seotoolninja.com/blog/accidental-seo-tests-how-301-redirects-are-likely-impacting-your-brand), but I'm wondering if that also applies to value of inbound links when you redirect your http://www.sitename.com to https://www.sitename.com. I appreciate your help!
Technical SEO | | JBMediaGroup0 -
Competitors link building surely link farming ? but no punishment?
Hi there added a competitors metrics to see what they were doing and to my amazement they seem to have 1000+ links surely this is link farming considering we stay in a very remote area. also why would he be rewarded for this not punished? imgur.com/18dUqNL 18dUqNL 18dUqNL
Technical SEO | | ShauniBROWN2 -
Optimizing internal links or over-optimizing?
For a while I hated the look of the internal links page of Google Web Master Tools account for a certain site. With a total of 120+K pages, the top internal link was the one pointing to "FAQ". With around 1M links. That was due to the fact, on every single page, both the header and the footer where presenting 5 links to the most popular questions. The traffic of those FAQ pages is non-existent, the anchor text is not SEO interesting, and theoretically 1M useless internal links is detrimental for page juice flow. So I removed them. Replacing the anchor with javascript to keep the functionality. I actually left only 1 “pure” link to the FAQ page in the footer (site wide). And overnight, the internal links page of that GWT account disappeared. Blank, no links. Now... Mhhh... I feel like... Ops! Yes I am getting paranoid at the idea the sudden disappearance of 1M internal links was not appreciated by google bot. Anyone had similar experience? Could this be seen by google bot as over-optimizing and be penalized? Did I possibly triggered a manual review of the website removing 1M internal links? I remember Matt Cutts saying adding or removing 1M pages (pages) would trigger a flag at google spam team and lead to a manual review, but 1M internal links? Any idea?
Technical SEO | | max.favilli0 -
Remove Links or 301
Howdy Guys, Our main site has been hit pretty hard by penguin and we are just wondering what steps we should now take. For the past 2 months we have been working through our back link profile removing spammy / un-natural links, we have documented everything in a spreadsheet... We recently submitted a reconsideration request to Google and they have now responded saying we still have bad links. I'm just wondering would be it easier just to 301 redirect our site to another TLD we have for our main site? Or Do we keep working through our links 1 by 1 and removing them? Has anyone had any success in 301ing? Thanks, Scott
Technical SEO | | ScottBaxterWW0 -
Reciprocal links / seo satellite
Hi guys, I am reasonably new to SEO. We operate a site. Lets call it brand.com. I would like to build up SEO juice and traffic for our site reasonably quickly, but with a view to not harming us in the long term. There are a large number of very small blogs in our space (> 100). Many of them are private blogs. I would like to gain links from these blogs. None of these blogs will send large amounts of traffic to our site on an individual basis, but in sum they provide both decent traffic and SEO juice. Leaving SEO out of mind I would offer them all returning links in exchange for linking to our blog (brand.com/blog) or our main domain (brand.com). They are decent quality sites that may be of interest to our users. They are not competitors and will not take any of our business away. Problem: I want to avoid being punished by Google for link exchange. In an ideal world I would event like to profit from these links from a SEO perspective. I have thought of a work around, but am not sure whether this will work at all. I will create 3 satellite pages: brand-partners.com, brand-tips.com and brand-blog-roll.com. I will feature links to these three sites prominently on my main site and my blog. This will provide these three sites with some SEO juice and trust from bloggers. In return for linking to my site, I will offer the small blogs links from these three "satellite" pages. I will try to diffuse the picture by adding some random links and obtaining some random links that I don't link back to. My approach is to always provide value to our users. Apart from the diffusing bit above I would say that creating these small hubs provides value (as we recommend valuable sites), while still enabling us to have some SEO effect. As I am reasonably new to SEO, I don't know whether the above is already a standard tactic employed or whether it contains some horrible pitfall that I should be aware of. I would be very thankful for any tips or feedback! Thank you and all the best, Daan
Technical SEO | | daan.loening0 -
Can I reduce link count by no following links?
Hi, A large number of my pages contain over 100 links. This is due to a large drop down navigation which is on every page. To reduce my link count could I just no follow these navigation links or would I have to remove the navigation completely?
Technical SEO | | moesian0