...

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.

...

How to remove the author identifiers form the column dc.contributor.author in Excel

1. Mark the column
   
   
2. Ctrl+H
   Find What: ::*||
   Replace With: ;
   then "Replace All"
   
   
3. Ctrl+H
   Find What: ::*
   Replace With:    (empty)
   then "Replace All"