Exporting Google and Bing Search Results
-
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
-
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.
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
-
Google Site search operator showing different results than Search Console
Hey everybody, I am seeing some confusing results. I am seeing that in the back of our Search Console we are showing around 4,500 sites indexed. If I use the "site" operator in google, only 2820 show up... any thoughts as to why that happens?
Moz Pro | | HashtagHustler1 -
Listing of all Google Indexed Pages
I started managing a site that has about 391,000 indexed pages. I want to get to the bottom of why there are so many in preparation for a ecommerce Migration and improving SEO. Anyone know of a tool? Many tools I have came across can only take 100 at a time. I would love to get them in excel or a database. I look forward to the suggestions.
Moz Pro | | dhands170 -
Traffic from Google analytics compared to traffic in Moz, quick question.....
When I look at the campaign for my website in MOZ it shows me my 'organic search visits' are radically different than when I look at Google analytics. In Moz I have 10 visits the week of 10/24 but using 'visits' in Google analytics I have 320 visits the same week. In Moz I have 20 visits the week of 11/1 (following the gold total line) but according to Google I have almost 500 visits that week. I just totally redid my site (www.sawwebmarketing.com) and posted a bunch of new content and looking to see what it did to my traffic and according to Google my visits have fallen dramatically but according to Moz my 'organic search visits' have multiplied by 6. Any guidance would be greatly appreciated! Thanks, Matthew
Moz Pro | | Mrupp440 -
Website not being indexed by Google - does seomoz have a index checker?
i have been to a couple of index checking websites that are saying my website is not being indexed, my developer and seo team have been making a lot of changes recently and I think it is because of that. Also my first byte grade is D. Can I check here on seomoz if my site is being indexed by Google here in the UK?
Moz Pro | | Malx0 -
On page analysis showing old results
Hi, My on page crawl analysis is showing that I have 38 duplicate content issues. These issues are because we had used tags in our blog. We remove all the tags 10+ day ago but the crawl that was done 5 days ago is still showing the tags as causing a duplicate content issue. Why would this be? We cannot correct is as it is already corrected. How do we get moz to crawl the correctly? Thanks Andrew
Moz Pro | | Studio330 -
Anyone tried Google Page Speed Service in you Blog or Website ?
Using CDN services are ok for Websites or Blog. But recently heard that there is a service like this from Google and they might charge for that ?
Moz Pro | | Esaky0 -
Is there a report I can run to get a list of all pages indexed by Google for my website?
I want to get a CSV file of all the pages that are indexed by Google and other search engines so I can create and .htaccess file of 301 redirects
Moz Pro | | etraction0 -
Google rankings dropped for some keywords
http://www.funktiongolf.co.uk uk google Our site ranked well for these words funky golf trendy golf clothes Now these keywords do no rank at all for my website. I have not been penalised by google as i emailed them. The only thing I did was add best seller products to my main page. Now my about us page ranks far higher than my index page Please Help
Moz Pro | | funktiongolf0