POWER QUERY: 3 Way Import Data from Google Drive to Excel (All Excel Version)
HTML-код
- Опубликовано: 22 авг 2024
- 3 AWESOME PROCESS TO IMPORT DATA OR PULL FROM GOOGLE DRIVE TO EXCEL (ALL EXCEL VERSION). Google Drive और GOOGLE Sheet के लिए डेटा कैसे प्राप्त किया जाए, Excel और POWER BI, डाउनलोड किए गए हर समय के बिना
3 PROCESS TO IMPORT DATA FROM GOOGLE DRIVE TO EXCEL WITHOUT ANY DOWNLOAD.
Import or Upload Google Drive Data into Excel and Auto Refresh of Data
How to Connect and Auto Refresh Google Data into Excel
Power Query for Excel Automation
Import Google Drive Sheet data into Excel
How do I automatically import data from Google sheets to excel
How to Use Google Drive as Local Drive
Article Link for this VIDEO (Get File Download Link HERE)
www.myaccounti...
WEBSITE - www.MyAccountingTricks.com
★ JOIN and GET ALL UPDATE & NOTIFICATION ★
✔ Linkedin ► bit.ly/mat_l
✔ RUclips ► bit.ly/may_y
✔ Facebook ► bit.ly/mat_f
✔ Twitter ► bit.ly/mat_t
✔ Email NewsLetter ► bit.ly/mat_email
STEP BY STEP POWER QUERY TUTORIAL LIST
www.myaccounti...
Activate and Install Power Query in Excel 2010, 2013, 2016 and Office 365 | Power Query option not available in excel menu | POWER QUERY not in COM ADD-INS
www.myaccounti...
Find Power Query Editor in Excel 2010 2013 2016 2019 Office 365
www.myaccounti...
Which Process You Like and Want to Try First?
You save my life with the last step... Thank you I was not aware of the Drive File Stream, instead of download the google drive app this option is more simple and very helpfully... Saludos desde Mexico
You are welcome!
the first video which helps thx from germany
Thanks, If it is helpful, please share, it will helps me lots
Thank you so much, from Vietnam.
Welcome
Hi, thank you for the video, it was really helpful. Do you know if it is possible to do method 1 with restricted access as well? I tried method one and it worked for unrestricted access but sadly not for restricted access. However to ensure the data safety at my company I need to use the restricted access. It would be great if you had a solution for this. Thank you. :)
I need to import data from a drive folder to power query (excel). do you have any method for this?
Yes, It is possible
I will upload this process and let you know the link
Subscribe, Like and Share to support this channel
@@MyAccountingTricksright, subscribed :) tks
Your Google Drive contains excel files or google sheet?
@@MyAccountingTricks excel files (.xlsm)
@@MyAccountingTricks Excel files :)
This video is the solution to a basic problem.
The real question and challenge is: How do I connect a Google Drive Folder to PowerQuery / PowerBI?
There doesn't seem to be a real answer to this....
I will upload video on this solution soon
Dear Mr Pijush Roy@@MyAccountingTricks _ i thank you for your instructive video on importing single excel. Like Lara on the above, i have been searching for the same query in the website but to no avail. I eagerly await your new video on how to power query multi numbers of excel files from Google Drive. Thank you. From Tan LC
Hi Lara, sorry for the delayed
Your Google Drive contains *excel files* and you want to Combine them in Power Query
or
Your Google Drive contains *Google Sheet* and you want to Combine them in Power Query
Please let me know,
@@MyAccountingTricks it was CSV files sitting in a Google Drive folder
@@laravanwyk5474 did you find a solution for your query??
It seems that I need "download" right for the document from the Google Drive. "View only" is not enough.
Please use Points 3, you can use Google Drive file without download them
Please let me know