So I have a large data set that is too big for Google Sheets to handle.

I need to be able to sync up the data from excel up to the google sheet...specifically, I'm doing a vlookup to get the 15 or so columns of data I need into the google sheet from the gigantic excel file.

In a perfect world, I would also be able to sync data from the google sheet back to a different excel file where I can then pivot, macro, transform, etc.

I recently downloaded this extension: www.DATAEVERYWHERE.com

It looks like it will do simple table replications, but that will still overload the google sheet I think.

I tried the reverse (kinda) by attempting to create a query from the website where I had some other google sheet data. but all excel got was the information about the sheet, none of the data.

Any ideas out there?