Automatically Import Data From Google Sheets to Excel | Link Google Sheets to Excel in Real Time

Описание к видео Automatically Import Data From Google Sheets to Excel | Link Google Sheets to Excel in Real Time

👍👍If you have found this content useful and want to show your appreciation, please use this link to buy me a beer 🍺.
https://www.paypal.com/donate/?hosted...
Thank you! 👍👍
In this Google Sheets and Microsoft Excel video tutorial I explain how to connect or link Excel to Google Sheets, so that Excel automatically imports data. This can be done with one or more sheets in your Google Sheets document. You can update the Excel import with any changes in Google Sheets periodically and/or whenever you open the Excel workbook.

Table of Contents:

00:00 - Introduction
00:14 - Create the 'share' URL in Google Sheets
01:26 - Import into Excel Using Power Query
03:08 - Refresh the import periodically or whenever the workbook is opened
04:45 - Make changes to the import query where necessary
------------------------

Комментарии

Информация по комментариям в разработке