How to export Google search results

Question

I want a list of the Titles and URLs for the search results of a particular query. In my particular situation, there are only about 20 pages of results so it's not that much data.

Answer 1

I have no experience myself. But I have found that someone suggests Seo FireFox Plugin.

For another option you can have a look at www.marketing2oh.com/scrape-serps-for-seo-analysis/. It describes the export with title, url and even description.

Answer 2

I ended up cutting and pasting HTML from the search results and then using jQuery to pull out the titles and URLs.

Answer 3

I don't know about google but I know bing has an option to export any search page as rss. You simply add format=rss to the query string. For instance

http://www.bing.com/search?q=london&format=rss

This will give 10 result per page so for the second page you add

http://www.bing.com/search?q=london&format=rss&first=11

and the third

http://www.bing.com/search?q=london&format=rss&first=21

and so on...

Answer 4

You could try using Google AJAX Search API. For example querying the URL http://ajax.googleapis.com/ajax/services/search/web?v=1.0&q=Svick will give you results for my username in JSON.

See this blog post for more information.

Answer 5

There's a Firefox plugin available at: http://tools.seobook.com/firefox/seo-for-firefox.html

When you install the plugin (easy), and click on the little SEO logo so that it is in color (not gray), and then do a search in Google, you get a ton of extra data in the results.

Much of the extra information is useful if you are doing search engine optimization. But if you are just looking at how to export the results, there is a tiny 'CSV' link. That will save the results into a CSV format, which you can then open easily with Excel!

You can also try Send to excel option in Internet Explorer.

Answer 6

Lots of answers here, but YQL, although not google out of the box, the following query will help.

select title,url from search.web where query="pizza"

The RESTful URL for those results is:

http://query.yahooapis.com/v1/public/yql?q=select%20title%2Cabstract%2Curl%20from%20search.web%20where%20query%3D%22pizza%22&format=json&diagnostics=true&callback=cbfunc

YQL itself can be found here: http://developer.yahoo.com/yql/ It's a really useful bit of kit by Yahoo.