Clay Icon

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

  • Avatar of Channeled
    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.

  • Avatar of Channeled
    Channeled
    APP
    Β·
    Β·
  • Avatar of Lazar R.
    Lazar R.
    Β·
    Β·

    That answered my question. for anyone else looking at this - I removed commas and semicolons and then it worked

  • Avatar of Channeled
    Channeled
    APP
    Β·
    Β·

    Thank you so much for sharing your feedback ​Lazar R.​!

  • Avatar of Channeled
    Channeled
    APP
    Β·
    Β·

    Thank you so much for sharing your feedback ​Lazar R.​!