...
- Save the export file on your computer.
- Open an empty spreadsheet in Excel.
- Click on the "Data" tab.
- In the "Get External Data" section, choose "From Text".
- Import the CSV file.
- Choose "Delimited" as file type.
- Choose "65001 : Unicode (UTF8)" as file origin.
- Check to box "My data has headers".
- Click on Next.
- Choose "Comma" as delimiter.
- Click on Next.
- Define the data format for columns that contain a date, especially dc.date.issued, as "Text"
- Click on Finish.
How to remove the author identifiers form the column dc.contributor.author in Excel
...