I have a CSV that’s 100+ MB, so it takes a long time to load.
In Microsoft Excel for Mac Version 16, I’d like to use the “Get data” or a similar functionality to load data from that CSV into an Excel workbook that adds some logic on top of that data. I’d like the ability to easily refresh that source CSV data either automatically or with a single click.
But I’d only like to load a couple of specific columns from the source CSV, rather than all of its columns, which will hopefully help speed up the process.
All my Googling has led nowhere on this topic. Any suggestions?
