I'm using the klaviyo guide to upload the file, it looks like this:
but every time I try it tells me: “There are columns missing from the selected file. Please check your file and try again.”
| Firts Name | Last Name | Consent | Phone | Country | Timestamp | |
| ingvaloluisa@gmail.com | Luisa | Avalo | 0'email', 'sms'] | +18019184259 | USA | 2021-15-11 18:00 |
Hello
Thanks for sharing your question with the Klaviyo Community!
That’s a really interesting error you are seeing as it does appear the .CSV example you provided does seem to have all the required columns needed to import the list into Klaviyo with SMS consent.
From my experience, this may sometimes be caused by having blank columns within your .CSV you are importing. I’ve seen this happen if you’ve copied and pasted this data from a different source and some latent formatting has been brought over including those blank column/fields. To resolve this, I would suggest copy and pasting the data into a new .CSV file while pasting the data without any formatting.
Another common mistake I’ve seen occur when importing lists to Klaviyo is inappropriately mapping the data which would throw a variety of errors.
In addition, I’ve included some other Community posts below that may be able further help you import a list:
I hope this helps!
David
I can confirm that copy and paste without formatting to a new CSV resolves this issue.
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.