Loading arrays from external spreadsheet

You may use a List View. It's a list with columns, and have also methods to save an load data, usually a plain text file, which can be easily edited with a text editor. The values should be separated from a char separator, usually tab, but you can also use a comma or a semicolon.
You can set the columns also at design time.
Here a screenshot of a List View in action:
Please login to see this attachment.

Perhaps you could copy the data from your spreadsheet and paste it into a text file. This way you can load all the data later in a List View, and have access to the value from within it.

Quote from DrPumpkinz

plus as a bonus I think the player being able to go in and mod stuff is charming

Bare in mind that the player could insert values that you don't expect, for example chars instead of numeric values. You have to handle all this cases in your code, and this could be daunting.
Instead I would provide a small mod editor from within your application, where the player does not enter any value, but moves value bars or presses "+" or "-" buttons. My two cents.

I hope it helps and makes sense for you.
Sergio

You can also Save as CSV and use String tokeniser

Split 2d "," and newline$

Quote from fnkycoldmadeanr

You can also Save as CSV and use String tokeniser

Split 2d "," and newline$

This..

I believe you can also use the Data Grid Object for converting to/from CSV & MMF Array format, but its been a while since I've tried this. I tend to just copy spreadsheets into a blank text document and then work with the .txt file.