Remove Special Characters from Clay CSV Exports

·

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:‰∏≠ÂõΩ Â±±‰∏úÁúÅ ÈùíÂ≤õ

3 comments

Channeled
APP
·
·
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.
Sources: Download as a CSV [Clay 101] - Clay University Download as a CSV [Clay 101] - Clay University Export and Download a File
Maurice O.
·
·
https://app.clay.com/workspaces/487659/workbooks/wb_0swiyi5oavuhRQoeCHN/tables/t_0sx8m0wkpXFZajXitj9/views/gv_0sx8m0xFeYYpVCrGh74
Owen C.
·
·
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. :)