Export Seach Results

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

Comments

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

 Flag as offensive