Clay Icon

Troubleshooting Apollo CSV Upload Error: Solutions and Tips

Β·
Β·

Hi, I'm uploading an apollo csv, and I keep getting this error, why and how do I fix it ?

  • Avatar of Channeled
    Channeled
    APP
    Β·
    Β·

    When uploading Apollo CSVs, errors can occur due to various reasons. Here are some troubleshooting steps: 1. Ensure your CSV is UTF-8 encoded with comma-separated values. 2. Remove any "created at" or "updated at" columns. 3. Check that your file doesn't exceed 72 columns and 50,000 rows. 4. Use a short file name for the CSV. 5. Remove commas, colons, and semicolons from the data itself to prevent mixing up fields. If issues persist, try uploading your data to a public Google Sheet, then download it as a CSV and attempt the upload again. This can help address hidden formatting problems. If you still encounter errors, please share the CSV file here so we can investigate further.

  • 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.

  • Avatar of Bharat D.
    Bharat D.
    Β·
    Β·

    Check row 1089 and see if there are any special characters. Remove them before uploading