# Manually populating arrays?

**URL:** <https://forum.electromage.com/t/manually-populating-arrays/361>\
**Category:** Patterns and Code\
**Created:** [May 13, 2020, 10:37pm UTC](https://forum.electromage.com/t/manually-populating-arrays/361 "2020-05-13T22:37:35Z")\
**Posts on this page:** 1\
**Showing post:** 3

<div class="post-metadata">

**Author:** ![jasperHawk](https://forum.electromage.com/letter_avatar_proxy/v4/letter/j/b487fb/32.png) [@jasperHawk](https://forum.electromage.com/u/jasperHawk)\
**Post date:** [May 16, 2020, 6:04pm UTC](https://forum.electromage.com/t/manually-populating-arrays/361/3 "2020-05-16T18:04:37Z")

</div>

When I need to “manually” set large arrays in pixelblaze, I’ve been using a spreadsheet to manipulate and store all the data in, then use a CONCAT() fuction to create a column with  
lots of array assignments like  
big\_array[0][0] = 4  
big\_array[0][1] = 2  
big\_array[0][2] = 3  
…

then, just copy the column, and paste it into my code.

---

_[View the full topic](https://forum.electromage.com/t/manually-populating-arrays/361)._