SMS upload errors with +1

Question

Having trouble importing  SMS #’s. When  I have column with “+1” and number, when saved as CSV, the +1 is removed so the file will not upload correctly. Any suggestions?Thanks!

Dov · Accepted Answer

Hi@RainbowsOfLight,Yes, please keep us updated on the status.Also, can you confirm if you have any additional fields in the .csv file aside from the phone number? For example, if you have the SMS consent timestampcolumn, it must be formatted in one ofKlaviyo's accepted datetime formats(e.g.,2019-09-01 13:34:08+00:00) and should use the “Date” data type on the mapping page.The phone number field should be using the “String” data type on the mapping page (depicted below):You can find below the correct data types for the “standard” properties when uploading SMS consent to ensure a match:Email --> Map to "Email" property; data type = stringPhone number --> Map to "Phone Number" property; data type = stringCountry --> Map to "Country" property; data type = stringTimestamp --> Map to "SMS Consent Timestamp" property; data type = date

Dov · Answer

Hello @RainbowsOfLight,Thank you for sharing this with the Klaviyo community.Can you try adding an apostrophe before the +1?(e.g., '+12345678910) and see if that works for you? The file format should not impact the ability to save the +1, but if the +1 is not “holding” in the .csv file, this should resolve it. If you are still having trouble, I would try using another platform to save the file i.e. excel if you are using google sheets or vice versa and also try the apostrophe trick there if necessary.Thanks for being a member of our community.

Sign up

Use your Klaviyo credentials

Log in to the Community

Use your Klaviyo credentials