Hi there!
This issue happens because of Excel settings. Clay exports in UTF-8 format, so please check that your Excel or Sheets is set up to read UTF-8 properly.
1. Open Excel.
2. Go to the āDataā Tab:
⢠Select āGet External Dataā > āFrom Text/CSVā (may vary by Excel version).
3. Import the CSV File:
⢠Choose your file, then select āImport.ā
4. Set File Origin to UTF-8:
⢠In the āText Import Wizardā or Import settings, set āFile Originā to ā65001: Unicode (UTF-8)ā.
⢠This tells Excel to interpret special characters correctly.
After completing these steps, your special characters should appear as expected.
Let us know if thereās anything else youād like help with!