Skip to main content
Solved

CSV Import of Array property

  • October 4, 2022
  • 1 reply
  • 215 views
V
Contributor I
Forum|alt.badge.img+2

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"]

 

 

Best answer by Dov

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.

View original
Did this topic or the replies in the thread help you find an answer to your question?

1 reply

Dov
Forum|alt.badge.img+61
  • Dov
  • Klaviyo Alum
  • 1493 replies
  • Answer
  • October 4, 2022

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.

DD

Reply


Terms & Conditions

Links & Resources

Platforms

Partners

Useful Things

About

  • Terms and Privacy |
    © 2024 Klaviyo All rights reserved. Klaviyo and the Klaviyo logo are trademarks or registered trademarks of Klaviyo, Inc. or its affiliates.