Just to give you another rabbit hole, you can also manipulate pretty much any data source, including Excel using powershell. I regularly use powershell scripts to mass import data that the script processes into an Excel workbook that the powershell formats. I find powershell to be faster doing this (if you use .net framework/LINQ, powershell sucks at large scale data object processing natively), especially if it’s large amounts of data, I typically process combined logs of over a million rows.
Just to give you another rabbit hole, you can also manipulate pretty much any data source, including Excel using powershell. I regularly use powershell scripts to mass import data that the script processes into an Excel workbook that the powershell formats. I find powershell to be faster doing this (if you use .net framework/LINQ, powershell sucks at large scale data object processing natively), especially if it’s large amounts of data, I typically process combined logs of over a million rows.