I have a large Excel (.xlsx) file, about 35-40 MB which is downloaded from a website. Each month there is a new file. I want to download the file every month and list all the rows that meet a certain criteria.
So far I can identify and download the file but I cannot see a way to search an Excel file. I am able to search in a Google Sheets file, but I cannot see a way to automatically convert the .xlsx file to a searchable Google Sheets file. Likewise, if it were in CSV format I’d be able to do it, but again I don’t know a way to make the conversion. I have tried Eyal’s Toolbox, but it fails - I assume because of the large file size.
Does anyone have a cunning way to achieve this?