You are viewing an old version of this page. View the current version.

Compare with Current View Page History

« Previous Version 5 Next »

Export limit

You can export results lists with a maximum of 500 items.

If you need an export of a search result with more items, please contact us and let us know which content the required export file should comprise. We will then send you the file via email.

How to import CSV files to Excel

To open a CSV file exported from the Research Collection with Excel, proceed as follows:

  1. Save the export file on your computer.
  2. Open an empty spreadsheet in Excel.
  3. Click on the "Data" tab.
  4. In the "Get External Data" section, choose "From Text".
  5. Import the CSV file.
  6. Choose "Delimited" as file type.
  7. Choose "65001 : Unicode (UTF8)" as file origin.
  8. Check to box "My data has headers".
  9. Click on Next.
  10. Choose "Comma" as delimiter.
  11. Click on Next.
  12. Define the data format for columns that contain a date, especially dc.date.issued, as "Text"
  13. Click on Finish.
  • No labels