I’m trying to import a CSV file and when I do, I get mismatched data all over. So I have gone and review the data type, and tried a different one with no avail. I won’t import and it doesn’t matter the data type I choose.
Anyone has an answer to fix this?
Best answer by elisegaines
I’m so sorry to hear you’re having trouble importing. When this happens, it’s almost always because of a “data type” that doesn’t match the data in your file. Here are some common areas where I’ve seen this happen:
Dates: our upload tool can only accept certain date formats. Check out this guide and make sure all dates are in an accepted format.
Consent: The consent data type requires a very specific “array” format, and can only hold certain values as well, like this: ["sms","push","directmail"]
If you have a “consent” field and it uses true/false values, select “Boolean” as the data type instead.
We have a guide with a lot more detail about troubleshooting list uploads as well.
I hope this is helpful! If you’re still having trouble, feel free to share more detail here and we can take a look (for example, a list of the columns in your spreadsheet and the type of data in each).