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
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
-
Several hreflang links pointing to same URL
Hi, Does anyone know whether hreflang links can be used using the following markup? I can't seem to find any info on this particular usage, but it "feels" incorrect to me. (duplicate content issues)
Technical SEO | | dimitrihuyghe
Our development team tells me this is the way the markup should be, since languages are initially set using a cookie and all different languages are using the same URL. Thanks! <link rel="<a class="attribute-value">alternate</a>" href="<a class="attribute-value">https://www.littlethingz.be</a>" hreflang="<a class="attribute-value">nl</a>"/><link rel="<a class="attribute-value">alternate</a>" href="<a class="attribute-value">https://www.littlethingz.be</a>" hreflang="<a class="attribute-value">x-default</a>"/><link rel="<a class="attribute-value">alternate</a>" href="<a class="attribute-value">https://www.littlethingz.be</a>" hreflang="<a class="attribute-value">fr</a>"/><link rel="<a class="attribute-value">alternate</a>" href="<a class="attribute-value">https://www.littlethingz.be</a>" hreflang="<a class="attribute-value">en</a>"/><link rel="<a class="attribute-value">alternate</a>" href="<a class="attribute-value">https://www.littlethingz.be</a>" hreflang="<a class="attribute-value">de</a>"/>0 -
Link in my blog to external pages - no follow?
Hi everyone. I'm quite new to SEO (started 6 months ago, but I'm very lucky to work the company that is willing to pay while I'm learning). I also create some content for the website - I write wood flooring industry blog. Following some advise from few SEO experts around the world whom I follow I have decided to write 1-2 off topic blogs/month but I have found the way of writing off topic but in reality bringing together wood flooring industry and let's say fashion industry. My question is - if I want to link to one or two pages (let's say bug fashion brands) shall I use no-follow link? I do not want to harm my website or theirs. Can those type of posts be the part of building my position within my industry and in general, building authority of my website? Of course appart from getting links TO my website. Tom
Technical SEO | | ESB0 -
Too Many Internal Links?
Hi Guys, I'm completing a overhawl of our website at the moment have a certain penguin killed our site for our main keyword. I'm currently working on our internal linking as most of our blog posts have a link back to our home page with the main money keyword. At present we have 3,331 internal links and our site has only 1,000 pages. Can you get penalised for having too many internal links with exact match anchors. Thanks, Scott
Technical SEO | | ScottBaxterWW0 -
Clickable links in video?
Hi, I am creating a website for mobile devices and have planned to use videos at certain places. I want to have a clickable url inserted at the end of the video. Any suggestions how may i do it? Regards
Technical SEO | | IM_Learner0 -
Different links to to the same page
Hi, Based on the user's actions we post activity into users Facebook timeline. And each activity has link back to our particular page on our website. For example if original page was: www.Domain.com from Facebook timeline it would be like this: www.Domain.com?Ffb_action_ids=101508953168 Do you think this will have a negative effect on our page rankings as we will eded up having a lot of different URL's to the same page? www.Domain.com?Ffb_action_ids=101508953168 www.Domain.com?Ffb_action_ids=456788765609 etc.. Thank you, Karen Bdoyan
Technical SEO | | showme0 -
Exchange Links - Problem or Not ?
There's a company that sells a real estate portal sites ready for several companies.
Technical SEO | | imoveiscamposdojordao
And when they install this system they always leave each site in a file calledimobiliarias.php that lists all properties that use your system, so there is a hugeexchange of links between the same sites.
So you can see with the Open Site Explorer that all sites have the same Backlinks.
This would not cause problems with regard to exchange links?
Loss of position or something? Thank you guys.! Sorry. 😛 Google Translator.0 -
Linking to unrelated content
Hi, Just wanted to know, linking to unrelated content will harm the site? I know linking to unrelated content is not good. But wanted to know weather any chances are there or not. I have a site related to health and the other one related to technology. The technology site is too good having PR 6 and very good strong backlinks. And the health related site has very much tough competition, So i wanted to know may be i could link this health site to technology site to get good link from it. Can you suggest me about it. waiting for your replies...
Technical SEO | | Dexter22387874870 -
First link count - passing of pagerank
I am asking this question after reading similar post. My question is does the first link count rule - Only the first link is counted, if we point to same page with two different anchor texts - applies to anchor text only. Does the PR is passed to the second link ?
Technical SEO | | seoug_20052