When opening a CSV file in Excel, some languages may not display properly if the file is opened in the conventional way:
The workaround to display these languages is as follows:
1. Open an empty Excel sheet
2. In the menu bar, click on FILE
3. In the drop-down, click on IMPORT
4. In the pop-up, select 'CSV file'
5. Select the file you want to open
6. You will see a pop-up with the 'text import wizard' (or data text to columns wizard)
7. On the 1st page:
- Select 'delimited' and then click NEXT
- For 'File origin' select 'UNICODE (UTF-8)
8. On the 2nd page, select 'COMMA' and then click NEXT
9. On the 3rd page, click FINISH (unless you also need to reformat columns with long numbers)
10. When prompted to select the cell where to import the date, select cell A1, then click OK
NOTE: Delimiters can be different between different files; some may have 'SEMICOLON'
Comments