Hey, I uploaded a CSV with 50k rows. Some columns were misaligned in the process. How can I make sure that htey are aligned properly? I double checked already, they are properly aligned in the excel, it only messes up during upload
To ensure proper alignment of columns when uploading your 50k-row CSV to Clay, try these steps:
1. Use UTF-8 encoding and comma-separated values for best results.
2. Remove commas, colons, and semicolons from your data fields to prevent misinterpretation.
3. Keep the file name short.
4. If issues persist, upload your data to a public Google Sheet, then download it as a CSV and try uploading again.
If you're still experiencing problems after these steps, you can share your CSV file with us for a deeper look. If you need further assistance, please request to talk to a person in this chat.