All Collections
Haystack for Business features
Converting Exported CSVs to Show Special Characters correctly in Excel
Converting Exported CSVs to Show Special Characters correctly in Excel

Special language characters can sometimes appear incorrectly in Excel. Here are the steps to show all of your contacts' data correctly.

Savanna Allen avatar
Written by Savanna Allen
Updated over a week ago

How to Fix Special Language Characters in Excel

If you have ever exported your contacts as a CSV file and opened it in Excel, you may have noticed that special language characters, such as accents or umlauts, can sometimes appear incorrectly. This can be frustrating, but luckily there is an easy fix.

Step 1: Open Excel and select “Blank Workbook”

Step 2: Select “Data,” then select “From Text/CSV”

Step 3: Locate your contacts export file, click “Import,” and click “Load”

Step 4: Your contacts CSV export will appear like below with all special characters showing correctly

Step 8: Save Your File

Finally, save your file by clicking on the "File" menu and selecting "Save". Your special language characters should now be displayed correctly in Excel.

Conclusion

Exporting contacts as a CSV file and opening it in Excel can sometimes cause special language characters to appear incorrectly. However, by following these simple steps, you can easily fix this issue and have your data displayed correctly. Happy exporting!

Did this answer your question?