Export in CSV

CSV (Comma Separated Values) format is a way of formatting data so that it can be displayed in tabular form and manipulated using a spreadsheet application such as MSExcel. CSV format is widely used for transferring data from one computer program to another. For example, it can be used to transfer data from a database to a spreadsheet. Each element/field of the data is separated from the next and so it can be treated as separate entities rather than as a ‘free text’ string.

Why might you want to use this feature? Once you have the data in a spreadsheet you can manipulate it and organize it. You might want to sort it into date order. You may need it for inclusion in a departmental report of all outputs in ORA by members of that department or research group.

To obtain data in CSV format for all records resulting from a search

1. Go to the ORA search page at http://ora.ox.ac.uk/

2. Type in your search term(s) (eg “climate change” or faculty:philosophy or author:bloggs) and click ‘search’

3. You will see a list of ‘hits’ displayed as short item records

4. To obtain the data from all the retrieved records. In the top right hand corner click on the link ‘CSV (all results). The data will be downloaded to your computer as an Excel file. Each element of the data (eg title, author, faculty, publisher etc) will appear in a separate cell in the spreadsheet.

5. You can manipulate the data in the spreadsheet as you want

To obtain data in CSV format for a single record

1. Go to the ORA search page at http://ora.ox.ac.uk/

2. Type in your search term(s) (eg “climate change” or faculty:philosophy or author:bloggs) and click ‘search’

3. You will see a list of ‘hits’ displayed as short item records

4. Select the record you want by clicking on its title

5. Click on the CSV link on the right hand side. The data will be downloaded to your computer as an Excel file. Each element of the data (eg title, author, faculty, publisher etc) will appear in a separate cell in the spreadsheet.

6. You can manipulate the data in the spreadsheet as you want

Back to top