Google Webmaster Tool - Extracting to Excel

by 13 replies
15
Hey, so....

I'm having a little dilemma. I really like the fact that I can extract all the crawl errors to Excel. I'm more efficient, and I can go through the links MUCH faster than using Webmaster tool..


Here's the problem.

I can only download the TOP 1,000 pages with errors. So if you see that tab that says "NOT FOUND" 5,851 errors? I can only get 1,000. Does that mean the rest of the 4,851, I need to go through manually?

Is there a way to download ALL of it? I really don't want to use the fetch tool cause 1) it takes too long 2) you're only allowed 500 fetches a week. 3) I rather use excel and go through each manually and mark it as fixed on my own.

Or some kind of trick? Thanks.
#search engine optimization #excel #extracting #google #tool #webmaster
  • Banned
    My question is, why do you have 5,851 errors on a single domain, are those 404s?

    If those are all 404s you need better management of the site, redirects from dead pages/URLs to live pages/URLs, etc...
    • [1] reply
    • This is the company I work for. A lot of problems. There's 300 employees, so I have to work with the IT. And they're the worst.

      But anyways, back to my question. How do we go about with that?
  • Yes, there is, actually. Fix the errors first (or mark 1000 of them) and another 1000 will pop up. Most likely one "fix" on your site will fix a lot of errors that you can mark as fixed.
    • [1] reply
    • That's not going to work. I have to manually go through each link. Not going to mark them without going through each one.
  • Banned
    I don't have thousands of errors so I have no way to test GWT export.

    I searched on Google & found this tutorial for exporting errors. Not sure If that helps? Might want to read the entire page including any problems in the comments below the tutorial.

    hxxp://luckyboost.com/exporting-data-from-google-webmaster-tools/

    The tutorial is dated April 2, 2013, so it should be up to date.
  • So how are you going to fix them anyway?

    When I've seen sites that have lots of errors like this, it's typically been an issue that can be an easy fix that affected tons of internal links to bad pages.

    Google gives us the top 1000. Yeah, there are 5000+ errors, but you just aren't going to get it all. Just like Google gives us the links to our site--but they only give us 100,000 links. If you have over a million links, you'll only get 10 percent. Google says "tough luck", pretty much, that's what they give us.
    • [1] reply
    • I'm manually going through each link through Excel. I mark down red if it isn't fixed. The fetch tool like I said only gives us 500 once a week. If the page is working and there is no 404 I then mark it as fixed.

      The ones that are NOT fixed, I send it over to IT and have them work on it.


      Edit: I have gone through 20,000 links already within the past month(s). So this isn't even a big # for me.
      • [1] reply
  • I don't know, I just do what they tell me to do and that's that.
Join the discussion

Next Topics on Trending Feed