How are umlauts and date formats correctly displayed in CSV format?

To ensure Excel opens the CSV file with the correct character encoding, you need to import the file manually – this can be done in a few steps.

---

Import CSV file into Excel

1. Open a blank Excel document.
2. Click on the File tab and then on Import.
3. Select CSV file and click Import.
4. Choose the reimbursement file you received from us and click Import Data.
5. Select Delimited and set the File origin to Unicode (UTF-8).
6. In the next window, select Semicolon as the delimiter.
7. Select the Amount column and format it as Text.
8. Click Finish.

Note: Importing is only necessary if you want to further process the file in Excel. If you open the file directly in a text editor, umlauts and date formats are automatically displayed correctly.

---

Would you prefer to receive the file in Excel format (.xlsx)? 

Under Organization - Payroll File Settings you can adjust the file format of your payroll file.