Turning Spreadsheet Data into an Array: with or without scripting
2 min readJun 24, 2021
--
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…