Is it possible to connect in Spreadsheet an external .xls or .csv file as a query as well as in Excel (that when I update the external excel file automatically update in spreadsheet worksheet)?
I have not tried it out yet - however I have the feeling this may work :
Without using Zapier, can you provide a worksheet showing a simple example of “excel file as a query database”?
Ability to reimport excel files and update existing worksheets that were created from said Excel files is on our near term roadmap.
Will share on this thread when we have a date.