Fixing Column Misalignment in CSV Uploads

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

5 comments

Channeled
APP
·
·
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.
Channeled
APP
·
·
Lazar R.
·
·
That answered my question. for anyone else looking at this - I removed commas and semicolons and then it worked
Channeled
APP
·
·
Thank you so much for sharing your feedback Lazar R.!
Channeled
APP
·
·
Thank you so much for sharing your feedback Lazar R.!