Opening CSV files can be tricky— when you have languages such as Greek, Cyrillic, Arabic, and Hebrew, there is a specific way to deal with them.
The following steps will explain how to open CSV files with special characters in Excel (2019). Other spreadsheet tools (i.e., LibreOffice), probably have similar actions.
- Open a new worksheet;
- Select Data on the top menu;
- Click in From Text/CSV;
- Select your CSV file with special characters and click Import;
- On the File Origin dropdown menu, select 65001:Unicode (UTF-8);
- Select the Delimiter that you want, making sure the table preview fits your needs;
- Click Load.
Other Excel versions may vary slightly, but the primary intention is to import the file instead of opening it like a regular file, making it possible to select Unicode UTF-8, which will display the characters correctly.
If you need any further clarification or help, please reach out to firstname.lastname@example.org.