How can I make a list of all URLs indexed by Google?

[Bryggselv.no]

I started working for this eCommerce site 2 months ago, and my SEO site audit revealed a massive spider trap.

The site should have been 3500-ish pages, but Google has over 30K pages in its index. I'm trying to find a effective way of making a list of all URLs indexed by Google.

Anyone?

(I basically want to build a sitemap with all the indexed spider trap URLs, then set up 301 on those, then ping Google with the "defective" sitemap so they can see what the site really looks like and remove those URLs, shrinking the site back to around 3500 pages)

[Worship_Digital]

If you can get a developer to create a list of all the pages Google has crawled within a date range then you can use this python script to check if the page is indexed or not.

http://searchengineland.com/check-urls-indexed-google-using-python-259773

The script uses the info: search feature to check the urls.

You will have to install Python, Tor and Polipo for this to work. It is quite technical so if you aren't a technical person you may need help.

Depending on how many URL's you have and how long you decide to wait before checking each URL, it can take a few hours.

[Bryggselv.no]

Thanks for your input guys! I've almost landed on the following approach:

1. Use this  http://www.chrisains.com/seo-tools/extract-urls-from-web-serps/ to collect a number (3-600) of URLs based on the various problem URL-footprints.
2. Make XML "problem sitemaps" based on above URLs
3. Implement 301s
4. Ping the search engines with the XML "problem sitemaps", so that these may discover changes and see what the site really looks like (ideally reducing the # of indexed pages by about 85%)
5. Track SE traffic as well as index for each URL footprint once a week for 6-8 weeks and follow progress
6. If progress is not satisfactory, then go the URL Profiler route.

Any thoughts before I go ahead?

[TammyWood]

URL profiler will do this, as well as the other recommend scraper sites.

[vcj]

URL Profiler might be worth checking out:

http://urlprofiler.com/

It does require that you use a proxy, since Google does not like you scraping their search results.

[GastonRiera]

Im sorry to confirm you that google does not want to everyine know that they have in their index. We as SEOs complain about that.

Its hard to belive that you couldnt get all your pages with a scraper. (because it just searches and gets the SERPS)

[Bryggselv.no]

I tried thiss and a few others http://www.chrisains.com/seo-tools/extract-urls-from-web-serps/. This gave me about 500-1000 URLs at a time, but included a lot of cut and paste back and forth.

I imagine there must be a much easier way of doing this...

[GastonRiera]

Well, There are some scrapers that might do that job.

To do it the right way you will need proxies and a scraper.
My recommendation is Gscraper or Scrapebox and a list of (at list) 10 proxies.

Then, just make a scrape whit the "site:mydomain.com" and see what you get.
(before buying proxies or any scraper, check if you get something like you want with the free stuff)

[Bryggselv.no]

I used Screaming to discover the spider trap (and more), but as far as I know, I cannot use Screaming to import all URLs that Google actually has in its index (or can I?).

A list of URLs actually in Googles index is what I'm after

[GastonRiera]

Hi Sverre,

Have you tried Screaming Frog SEO Spider? Here a link to it: https://www.screamingfrog.co.uk/seo-spider/

It's really helpfull to crawl all the pages you have as accesible for spiders. You might need the premium version to crawl over 500 pages.

Also, have you checked for the common duplicate pages issues? Here a Moz tutorial: https://azwa.1clkaccess.in/learn/seo/duplicate-content

Hope it helps.
GR.