Troubleshooting Apollo CSV Upload Errors: Solutions and Tips

·

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

Hunain F.
·
·
Scarlett M. Open CSV in Notepad++ or VS Code Go to line 1089 Remove or fix unclosed quote " in that row Save as UTF-8 CSV Re-upload to Clay it will work now
Clay
APP
·
·
Since I can't see the specific error, here are common CSV upload fixes: • Remove "created at" or "updated at" columns • Ensure file has ≤72 columns and ≤50,000 rows • Use UTF-8 encoding with comma separators • Remove commas, colons, and semicolons from data • Try uploading to Google Sheets first, then download as CSV • Use a shorter file name If you're seeing green triangles, download and re-upload instead of copy-pasting. What specific error message are you seeing?
Scarlett M.
·
·
Thank you - hunain it's worked
Clay
APP
·
·
Perfect! That's exactly the right fix for unclosed quote errors in CSV files. Opening the CSV in a text editor like Notepad++ or VS Code to locate and fix the problematic quote on line 1089 will resolve the parsing issue. After fixing the quote, make sure to save as UTF-8 encoding when re-uploading to Clay for best results. This type of formatting issue with quotes and special characters is a common cause of CSV upload problems.
Hunain F.
·
·
Welcome.
1
Stefano
·
·
Hi, thank you for reaching out. Glad you were able to solve this issue. Closing this ticket now but feel free to reach out if you have any more issues.