Export Seach Results

AndNewmanGeo
Offline
Joined:
21/09/2010

Hello,

So I have found the data I want...  I have done a search and then refined this using a bunch of filters.  Is there any way for me to now export the results of this search into an excel, CSV, XML (or other) format?

Thanks, Andrew
28/06/2011 19:24 #1
Alexedwards
Offline
Joined:
25/06/2011

Try the RSS feed + Google Docs

Hi,

 

Yes, give this a try: Do your search and run your filters. On the right of the Search Results bar you should see a orange RSS icon. Click this and copy the full url.

 

Open up a Google Docs Spreadsheet. In the first cell type the following:

=importfeed("rss-url",,true)

For example, to get CSV files for the term 'police' you would type:

=importfeed("http://data.gov.uk/opensearch/apachesolr_search/police?filters=type%3Ackan_package%20sm_resource_formats%3ACSV",,true)

 

Hit return and this pulls the data through and formats it perfectly. From there you can export it as Excel or CSV. Hope that helps!

 

Alex