Fix Icelandic Characters in Excel CSV Exports
Question details
Preserve Icelandic characters when exporting an Excel workbook to CSV and importing it on Windows.

- Product
- Microsoft Excel
- Device & OS
- macOS and Windows
- Scenario
- A workbook created or exported on a Mac needs to be imported as a CSV file on Windows.
- Observed behavior
- Characters such as ö, ó, í, and æ appear as question marks or incorrect symbols in the CSV, although the XLSX workbook displays correctly.
Open the original XLSX workbook and confirm that the Icelandic characters display correctly before exporting. Identify the worksheet you need, because a CSV export saves only the active sheet.
Export the Excel worksheet as UTF-8 CSV
Use this method when the original workbook displays correctly but a standard CSV export does not preserve Icelandic characters.
Open the original XLSX file in Excel and select the worksheet you want to export.
Select File > Save As, choose a location, and select CSV UTF-8 (Comma delimited) (.csv) from the file format list.
Click Save and confirm any prompts about saving only the active sheet or losing workbook features.
On Windows, open Excel and select Data > From Text/CSV. Choose the exported file, set File Origin to UTF-8, check the preview, and click Load.

Check the Windows import settings
Use this when an existing UTF-8 CSV still displays incorrect characters on Windows.
Export a UTF-8 CSV with WPS Spreadsheets
Open your Excel workbook in WPS Spreadsheets and save the active sheet as a UTF-8 CSV when that format is available in your version. Check the encoding when importing the file on Windows.
- 1. Open the workbook: Open WPS Spreadsheets, select Open, and choose the original XLSX workbook.
- 2. Select the worksheet: Click the sheet tab containing the Icelandic text and confirm that the characters display correctly.
- 3. Save as UTF-8 CSV: Select Menu > Save As and look for CSV UTF-8 in the file type list. Choose it and click Save; if your version does not offer it, use an application that supports UTF-8 CSV export.
- 4. Check the imported file: In the destination application, import the CSV with UTF-8 encoding and confirm that the Icelandic characters appear correctly in the preview.

Frequently Asked Questions
Why do Icelandic characters become question marks in my CSV?
A standard CSV export may use an encoding that cannot represent the characters. Export the original worksheet using File > Save As > CSV UTF-8, then import it using UTF-8.
How do I select UTF-8 when importing a CSV in Excel for Windows?
Choose Data > From Text/CSV, select the file, and set File Origin to UTF-8 in the import preview. Check the characters and delimiter before clicking Load.
Can I recover characters that have already turned into question marks?
Not by changing the import encoding if the characters were replaced during export. Open the original XLSX workbook and export a new CSV using UTF-8.
Does a CSV file contain all worksheets from my workbook?
No. Excel saves only the active worksheet to CSV. Select each required sheet and save it as a separate CSV file.




