Page tree

Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

How to import CSV files to Excel

To open a the CSV export file exported from the Research Collection with Excel, proceed directly with Excel, you must set the default list separator in your Windows system settings to "," (comma) instead of ";". (semicolon).

Alternatively, you can import the export file into Excel 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.