When I open a CSV file in excel, there are special characters that do not display correctly, what do I do? ← Population Landscape and Climate Estimates You can overcome this limitation of CSV files related to Microsoft code pages by using Excel’s data import functionality and setting the code page to UTF-8.