Combine Data from Excel and Google Sheets
This video shows how to merge or combine (append) data coming from Excel and another one in Google Sheets to create PivotTables or perform other operations in Excel.
This video will show how to publish a Google Sheets document to the web so that it can be accessed in Excel. This video will then show how to use Power Query to append tables.