MIGRATION: GOOGLE WORKSHEETS TO EXCEL
Budget: $10 – $30 USD
MIGRATION: GOOGLE WORKSHEETS TO EXCEL
We currently have databases on Google Sheets, but the sheets are too heavy and slow. Therefore, we want to migrate our database to Excel.
In the script, only QUERY / IMPORTRANGE are connections between spreadsheets, building databases, but not very heavy database support.
In theory it's simple, but it's getting too loaded on Google Sheets, consuming a lot of memory on our computers.
Is Excel online better in this requirement (no slowdown) with long databases?
We believe that yes, it is possible that the POWER QUERY will solve our problem.
We currently have databases on Google Sheets, but the sheets are too heavy and slow. Therefore, we want to migrate our database to Excel.
In the script, only QUERY / IMPORTRANGE are connections between spreadsheets, building databases, but not very heavy database support.
In theory it's simple, but it's getting too loaded on Google Sheets, consuming a lot of memory on our computers.
Is Excel online better in this requirement (no slowdown) with long databases?
We believe that yes, it is possible that the POWER QUERY will solve our problem.