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…

--

--

Get the Medium app

A button that says 'Download on the App Store', and if clicked it will lead you to the iOS App store
A button that says 'Get it on, Google Play', and if clicked it will lead you to the Google Play store