External excel file as a query database

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)?
Thank you

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”?
Thank you.

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.

1 Like