Clay Icon

Troubleshooting CSV Import Issues in Clay

Β·
Β·

I'm trying to import a CSV into Clay but it messes up all the columns and the things inside them What could be the problem?

  • Avatar of Daniel K.
    Daniel K.
    Β·
    Β·

    Hi there! Sorry about that. When uploading CSVs to Clay, you should ensure the following: ** The CSV file should not include "created at" or "updated at" columns. ** The CSV upload feature supports a maximum of 72 columns and 50,000 rows. Ensure your file is within these limits. ** Use UTF-8 encoded CSV files with comma-separated values for the most reliable results. ** If you encounter issues, try uploading your data to a public Google Sheet, then download it again as a CSV and attempt the upload once more. * Make sure the CSV file name is short. These steps help address common issues such as incorrect column separators and hidden formatting problems that can prevent successful uploads. If the issue still persists after going the above points, please share the CSV (ping us at support@clay.com for more privacy) and I'm happy to dive in deeper :) If there's anything else I can assist you with, please let me know! 😊 Have a great one, Daniel

  • Avatar of Channeled
    Channeled
    APP
    Β·
    Β·