Clay Icon

Help Needed: Troubleshooting CSV Upload Error

·
·

I've been facing the above error several times today while uploading CSV file. Can anyone here guide me on how to fix/prevent the occurrence of this error?

  • 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 Dhanesh
    Dhanesh
    ·
    ·

    Clay isn't uploading the CSV file, so not possible to send the table url.

  • Avatar of Owen C.
    Owen C.
    ·
    ·

    Hey there, thanks for reaching out! If you're having trouble uploading a CSV file to Clay, here are a few things to check: 1. Ensure the file is UTF-8 encoded, with comma-separated values, and within the limit of 72 columns and 50,000 rows. 2. Remove any 'created at' or 'updated at' columns. 3. Upload the CSV to Google Sheets, then export it back as a CSV to clean up any hidden formatting issues. If the issue persists, feel free to share the Google Sheet with me, and I'll take a look! I hope this helps! Try these quick fixes first, and if none work, don’t hesitate to reach out again—we’ll dig deeper! 😊

  • Avatar of Owen C.
    Owen C.
    ·
    ·

    Amazing! Thanks for sending this over!! Did you have a chance to try re-downloading this Google Sheet as a CSV and uploading the new file?

  • Avatar of Owen C.
    Owen C.
    ·
    ·

    Just tested this out and was able to successfully upload the new CSV that was downloaded from this Google Sheet! Let me know how it goes for you! Feel free to reach out with any other questions! :)

  • Avatar of Dhanesh
    Dhanesh
    ·
    ·

    Owen C. tested your solution and it's working well now. Thank you so much!

  • Avatar of Owen C.
    Owen C.
    ·
    ·

    Of course!! Glad I could help, feel free to reach out with any other questions :)

  • Avatar of Channeled
    Channeled
    APP
    ·
    ·

    Hi Dhanesh! This thread was recently closed by our Support team. If you have a moment, please share your feedback: