Exporting Google and Bing Search Results

[JohnW-UK]

Is there away to get a spreadsheet of the pages indexed for a certain domain in google and bing? i.e. I search google for  Site:www.domain.com and I want to export a .csv file of all those domains/pages.

Cheers

[matbennett]

There is a chrome extension called "scrape similar" that is useful for doing small batches of stuff like this. However it does have a couple of limitations in that you have to view each page & google will not show you all pages of a large domain. However it is quite easy and effective for sites with under 1000 pages.

https://chrome.google.com/webstore/detail/mbigbapnjcgaffohmbkdlecaccepngjd

The process can be sped up using other tools.  I use tool that is designed for black hat forum/comment spamming to do SERP scrapes like that.  Even if I did such spamming (I don't), I don't actually think this is a very good tool to do it with. However it is rather good at scraping results from google. However, again you are limited to how many results Google/Bing choose to show you.

If you need a bigger list then log files might be the way to do.  You can get a list of all crawled URLs for any particular agent (including the likes of googlebot) from your server logs.  Some hosts limit the size of these, so it might be worth checking before you start.  However the data does get collected.  The downside here of course is that you need access to the logs.

Of course crawled is not the same as indexed. Once you have that list you might need a further step to see which is indexed. Possibly cross-referencing it against google analytics landing pages or querying the google cache for that page (SEOtools for Excel from Biels Bosma is good for this).

Similarly, if you have a definitive list of the URLs on site you could start with that list and query which are cached.

Harder than it seems isn't it? Hopefully one of those methods will put you on the right track.