Turning Spreadsheet Data into an Array: with or without scripting

Scripting is often part of our jobs, and the data we’re using in our scripts is regularly provided to us in spreadsheets. There are a couple different ways to get this data into an array, so we can iterate through it:

  • First: spreadsheets can be downloaded as CSV files — writing a script to open and parse these only takes a few lines of code. This can…