Fixing '???' Symbols in CSV Exports from Clay Table

·

Hi, when we export the Clay table to a CSV, sometimes the Symbol apostrophe ' returns ??? (Question mark symbols with black background) in the CSV file.... Is there any fix to this?

2 comments

· Sorted by Oldest

Tal Sionov
·
·
this is an example
Loading attachments
Channeled
APP
·
·
When exporting a Clay table to CSV, special characters like apostrophes (') may appear as question mark symbols if there are encoding issues. To address this, ensure your CSV files are encoded in UTF-8, as this encoding reliably supports special characters. If you still encounter the issue, try uploading your data to a public Google Sheet, then download it again as a CSV and re-import or export as needed. This process can help resolve hidden formatting or encoding problems that cause character display issues in CSV files.

Tal Sionov
·
·
this is an example
Loading attachments
Channeled
APP
·
·
When exporting a Clay table to CSV, special characters like apostrophes (') may appear as question mark symbols if there are encoding issues. To address this, ensure your CSV files are encoded in UTF-8, as this encoding reliably supports special characters. If you still encounter the issue, try uploading your data to a public Google Sheet, then download it again as a CSV and re-import or export as needed. This process can help resolve hidden formatting or encoding problems that cause character display issues in CSV files.