# Array Data upload format

**URL:** <https://forum.wixstudio.com/t/array-data-upload-format/2479>\
**Category:** Ask the community\
**Tags:** question, code, wix-stores\
**Created:** [March 26, 2023, 4:41pm UTC](https://forum.wixstudio.com/t/array-data-upload-format/2479 "2023-03-26T16:41:02Z")\
**Posts on this page:** 1\
**Page:** 1

<div class="post-metadata">

**Author:** ![founder53806](https://sea1.discourse-cdn.com/wix/user_avatar/forum.wixstudio.com/founder53806/32/25911_2.png) [@founder53806](https://forum.wixstudio.com/u/founder53806)\
**Post date:** [March 26, 2023, 4:41pm UTC](https://forum.wixstudio.com/t/array-data-upload-format/2479/1 "2023-03-26T16:41:02Z")

</div>

Ok, so basically I’m uploading a database of ski areas.  
Each ski area has between 1 and 7 towns associated with it.  
Right now in my excel each town is in a separate column  
(see attached screenshot)

 ![](https://us1.discourse-cdn.com/wix/original/3X/9/7/97b48ada34eab5d2ca5b15f140cf9c9598188e1c.png)

Am I right in thinking that it’s best to combine these into an Array to store this data?  
Ie So I can code to display the array as a string of text on the Ski area dynamic page. Not have to link 1 text to 1 field for each one?

If so, does anyone have a Macro to combine these columns into JSON format?  
Would it be like  
[  
“Val Thorens”,  
“Les Menuires”,  
]

That I’d then put in an array field?

Would this still let me put in a search function for towns on a repeater page?

Any help much appreciated.
