Clay Icon

Resolving Export Issues: Fixing Special Characters in Email Copy from Clay to Excel

·
·

I am having ChatGPT generate email copy for me in Clay - then I am having that email copy being sent in my emails to people. In Clay the email copy looks fine. But when I export to Excel it gets messed up a bit. Weird symbols being used in place of apostrophes i.e. instead of saying "and I'd be honored to assist you in navigating this next chapter." It will replace the apostrophe with special characters --> " I’d be honored to assist you in navigating this next chapter." - It ONLY shows up like this when I export it from Clay and I open it in Excel. Any ideas on how to solve this issue so when i export it to Excel all my copy doesn't get messed up? It is for thousands of emails so it's not as simple as one email going in and manually changing the special symbols out.

  • Avatar of Channeled
    Channeled
    APP
    ·
    ·

    👋 Hey there! Our support team has got your message - we'll be back in touch within 24 hours (often sooner!). If you haven't already, please include the URL of your table in this thread so that we can help you as quickly as possible!

  • Avatar of Arturo O.
    Arturo O.
    ·
    ·

    Hey Kim, thanks for the reaching out and insights about the situation you're encountering! The formatting issue is likely because Excel has their own way to read CSVs and they default to a specific version of their own. The universal CSV format (referred to as UTF-8) is accepted in almost any other tool, for example, if you open up the file in Google Sheets it should work fine (the issue is how Excel interprets the values). Also, if your messages are being cut off, here's a video addressing that specific issue. Let me know if that helps!

  • Avatar of Channeled
    Channeled
    APP
    ·
    ·

    This thread was picked up by our in-app web widget and will no longer sync to Slack. If you are the original poster, you can continue this conversation by logging into https://app.clay.com and clicking "Support" in the sidebar. If you're not the original poster and require help from support, please post in 02 Support.