When exporting article data, a CSV file is created. It follows the language set in the browser.
It is important that the file is not opened directly in Excel by double-clicking or drag-and-drop, as this can lead to incorrect display. Instead, the file should be loaded via Excel's import function.
To do this, please proceed as follows:
-
Open a new, empty workbook in Excel.
-
From the menu, select File → Import → CSV.
-
Excel then asks for the character set. If umlauts (e.g. ä, ö, ü) are not displayed correctly, please select UTF-8.
-
As the separator, please select semicolon (;).
An attached video shows the entire process step by step and helps with the implementation.