Data Import & Export

Fix Icelandic Characters in Excel CSV Exports

Camila MilosovichCamila Milosovich Nov 22, 2026 868 views

Question details

Preserve Icelandic characters when exporting an Excel workbook to CSV and importing it on Windows.

Fix Icelandic Characters in Excel CSV Exports
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.
Before you start

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.

Solution 1Recommended

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.

1
Open the source worksheet

Open the original XLSX file in Excel and select the worksheet you want to export.

2
Choose the UTF-8 CSV format

Select File > Save As, choose a location, and select CSV UTF-8 (Comma delimited) (.csv) from the file format list.

3
Save the CSV

Click Save and confirm any prompts about saving only the active sheet or losing workbook features.

4
Import with UTF-8

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.

Export the Excel worksheet as UTF-8 CSV
If UTF-8 CSV is unavailable: The CSV UTF-8 option may not be available in older Excel versions. Use a version that offers it or export from another application that supports UTF-8 CSV.
Work with CSV files in WPS

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. 1. Open the workbook: Open WPS Spreadsheets, select Open, and choose the original XLSX workbook.
  2. 2. Select the worksheet: Click the sheet tab containing the Icelandic text and confirm that the characters display correctly.
  3. 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. 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.
Export worksheet data for CSV import workflowsWork with Microsoft Excel XLSX and XLS filesUse a familiar spreadsheet interfacePreview imported text before loading it
microsoft office alternative - wps office

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.