Solved

CSV Import of Array property

  • 4 October 2022
  • 1 reply
  • 141 views

Badge +1

When attempting to bulk CSV load a user property that is of List/Array type, the csv importer fails to work despite following the format recommended by the documentation : https://help.klaviyo.com/hc/en-us/articles/115005237648-About-Data-Types#list6

 

For example the very simple CSV below fails with “column missing” but if I change the property to be a normal string, the upload completes. It looks like the CSV uploader does not actually support List data types despite the documentation.

 

Email,some_property
vim@gmail.com,["A","B"]

 

 

icon

Best answer by Dov 4 October 2022, 19:53

View original

1 reply

Userlevel 7
Badge +61

Hi @vimota,

Thanks for sharing this question with our community.

At this time the upload via copy and paste function with list data types is not available. Instead, you’ll want to upload your .csv file. Here is our guide on achieving that.

And here is a screenshot example of how your .csv would look with list data types:


A CSV file with list data ready to upload

Also, I recommend checking out our List Import Troubleshooting guide as this will show you all error messages, what they mean, and how to solve for them.

Thanks for being a community member.

Reply