Clay Icon

Issues with CRM CSV Upload: Data Duplication Errors

·
·

I've tried to upload a CRM CSV with only 1.3 contacts and 35 rows 5 times now and for some reason it keeps uploading data that ISN'T in the original sheet and duplicating data from the last 15 rows making the total 50. I've tried to upload this simple CSV three times now. First time it failed, last two times has been the same issue. It's causing a simple CSV upload to be useless since I have to go in and manually edit 16 rows. https://app.clay.com/workspaces/427003/workbooks/wb_t9DvPkp9yuqJ/tables/t_B74Ypu7odQUC/views/gv_SugHfQjYwp7y

  • Avatar of Bryce
    Bryce
    ·
    ·

    I'm not even sure what these last 15 rows are because they don't exactly mirror other rows.

  • Avatar of Bryce
    Bryce
    ·
    ·

    I tried uploading again and this time got 49 rows. What's weird about it is there is viable data on rows 35 onwards. I'm just not entirely sure waht it is

  • Avatar of Bryce
    Bryce
    ·
    ·

    Yea this is really problematic. Even though I enable headers they just stop appearing after column 35 every time I upload--besides the fact that in my original document there ARE NO COLUMNS after 35 so I have no idea where this data is coming from.

  • Avatar of Bryce
    Bryce
    ·
    ·
  • Avatar of Bryce
    Bryce
    ·
    ·
  • Avatar of Owen C.
    Owen C.
    ·
    ·

    Hey Bryce, thanks for reaching out and seriously sorry to hear this. Can imagine it's super frustrating dealing with data that's not your own in this case. Would love to help and in order to do so, could you upload this CRM CSV with ~1.3 records into a Google Sheet, than share this Google Sheet with us? That way we can take a look at the data you're trying to import to begin to diagnose! :) Don't forget to turn the sharing setting to "anyone with link" so our team can see this as soon as possible and help unblock you here. :)

  • Avatar of Channeled
    Channeled
    APP
    ·
    ·