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. 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 support@ubersuggest.com.