To enter data I use the array editor in C3, because it's convenient and you can copy/paste values from Excel or Google Sheets.
And then on start of the game I convert this data to JSON, because it's much more flexible and easier to work with than arrays.
Here is an example, the ShopStock array, it contains multiple sheets for different shops in the game. The first cell contains the name of the shop - "Blacksmith".
On start of the game I'm loading this data into a temporary array and then parsing it into this neat JSON format:
{
"Blacksmith": {
"copperaxe": {
"Price": 2000,
"Materials": [{"ingotCopper":3},{"axe":1}],
"Quantity": 1
},
"copperhammer": {
"Price": 2000,
"Materials": [{"ingotCopper":3},{"hammer":1}],
"Quantity": 1
},
"ironaxe": {
"Price": 5000,
"Materials": [{"ingotIron":3},{"copperaxe":1}],
"Quantity": 1
}
},
"Greenhouse": {
"plantPurpleHeart": {
"Price": 2100,
"Quantity": 1,
"Randomize": 1
},
.......
I can then access any product in any shop using ShopStock.get("Shop.Product") expression, I can add new keys to JSON, remove products etc.