When I export any data from Clay as a CSV, it always contains special characters. Is there a way to change this? Title: 营销总监 First Name: 程 Last Name: 程子扬 Location:中国 山东省 青岛
To export data without special characters, create a dedicated "CSV Export View": 1. Duplicate your current view 2. Hide or delete columns with special characters 3. Keep only the raw values you need 4. Go to Actions > Export > Download CSV This creates a cleaner export with only essential data, avoiding object fields that might display differently in CSV format.
Hey Maurice, thanks for reaching out! When exporting data from Clay as a CSV, special or odd characters may appear due to encoding issues. Clay exports CSV files in UTF-8 format, so it's important to ensure your spreadsheet application is set to read UTF-8 encoding properly. To resolve this, follow these steps: For Excel: ** Go to the "Data" tab. ** Select "Get Data" or "From Text/CSV." ** Choose your file and select "Import." ** In the import wizard, set "File Origin" to "65001: Unicode (UTF-8)." For Google Sheets: ** Use "File > Import > Upload." ** Select "UTF-8" as the encoding. These steps should ensure that special characters display correctly. The issue is not with the Clay export itself, but with how your application reads the file. :)