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 does link juice flow through hreflang?
We want to use the hreflang tag on our site (direct users searching for the Spanish version of spanishdict.com to spanishdict.com/traductor). Before doing so, we were wondering how link juice flows through hreflang? Any insight or resources on this would be very helpful. Thanks!
Technical SEO | | CuriosityMedia0 -
Site rebuild without HTML extension = broken links?
I have a client and his site is pure HTML. He made huge amount of link building with some hundreds of links point to example.com/target.HTML Now we decided to use WordPress with the same site structure. If we use the exact same URLs but without the HTML ending will it cause broken links? Is there any best practice for this kind of change? Many thanks for any idea!
Technical SEO | | seozoltan0 -
Find where the not selected pages are from
Hi all Can anyone suggest how I can find where gtoogle is finding approx. 1000 pages not to select? In round numbers I have 110 pages on the site site: searech shows all pages index status shows 110 slected and 1000 not selected. For the life of me I cannot fingure where these pages are coming from. I have set my prefered domain to www., setup 301 's to www. as per below RewriteCond %{HTTP_HOST} ^growingyourownveg.com$
Technical SEO | | spes123
RewriteRule ^(.*)$ "http://www.growingyourownveg.com/$1" [R=301,L] site is www.growingyourownveg.com any suggestions much appreciated Simon0 -
What are the best tools for back links?
I am a new to SEO, please help me in choosing the right tools for back links. I am thinking to buy Ultimate demon, Should I buy it or not? I have a range of you tube videos to rank.
Technical SEO | | Sajiali0 -
How do you take down a link
Salut from Sunny wetherby UK 🙂 Having just watched a whiteboard fri clip all about the "Penguin Update" i want to know how to take down a link. I feel a site ive been working on has been pecked by the penguin. I did build inbound links on a specific commercial term and shiver me timbers is dropped oof the SERPS from top 5 to ziltch, yiles!! So my questiuon is please:
Technical SEO | | Nightwing
if you find an inbound link using a target term how do you kill it? Thanks in advance :_)0 -
Modifying urls cause broken links?
I want to modify my urls for the purpose of creating clean, informative urls that can be pasted directly for backlink purposes. Instead I have urls with long, garbled, strange characters. When I change the URL it breaks existing back links! Any way around this?
Technical SEO | | natearistotle0 -
Too many on page links
Hello I have about 800 warnings with this. Example of one url with this problem is: http://www.theprinterdepo.com/clearance?dir=asc&order=price I was checking and I think all links are important. But I suppose that if I put a nofollow on the links on the left which are only for navigation purposes I can get rid of these warnings. Any other idea?
Technical SEO | | levalencia10 -
Link title with anchor text
Will there be any additional SEO value if we add link title in addition to anchor text.? Can you compare link title with image title? Thanks.
Technical SEO | | gmk15670