Get Google Sheet Data in Excel with Power Query

Learn how to import Google Sheet data into Excel using power query. You'll always have the latest Google sheet data with the click of a refresh button in Excel. 👇

Check out my full courses and ebooks here

DOWNLOAD the example workbook here

SUBSCRIBE & get my 3 FREE eBooks

CONNECT with me on social

Thanks for all your support!

[orikuper]

Thank you so much. For about 2 weeks I've been having issues with web queries that worked fine until then. So it's been a nightmare to deal with. And now after seeing your video I just bring them to a new place in Gsheets, and then bring them into my normal excel from there. Thanks again. So good!!! :-)

[Hatersongs]

Absolutely brilliant!! Saved me a massive headache. Great clear and working tutorial thanks!

[EoinH]

This is brilliant, I had tried one from another video and figured you couldn't do it any more. this will save me about 3 hours a week in scheduling. thanks a million!!!

[alexanderjones]

This has just made my week. This solved all my problems I was having!! Thank you!!!

[nsoans]

Damn!! you made it so simple for me to understand the steps.. Thanks a ton, really helpful, John.

[wayneedmondson]

Hi John. Cool trick! Thanks for sharing :)) Thumbs up!!

[rhayes]

This was incredibly helpful and super concise. Thank you!

[trongpham]

wow, many thanks, so easy to get data from Sheets to Excel =))

[RageDauntlessWinters]

you're a life, time and life saver SIR!

[darrylmorgan]

Wow!I Just Learned Something New To Me!Awesome Tutorial Thank You John :):):)

[hardansofyan]

Supper helpfull, Thank you from Indonesia 🙏🙏🙏

[Struggle]

Thank you a lot, that was very helpful!

[marielnalli]

thanks! this is so helpful... i wonder if there is a way to do this with a whole folder from google drive, which contains several gsheets

[avininyoutuification]

Thanks you John .awesome..one question though : will it import the macros from the original Google sheet?

[longhorneye]

Good job. It was that what I looked for

[georgiivanov]

Great video! How about applying the same process for a private workbook?

[wayneedmondson]

Hi John.. discovered another way to do this. Change the end portion of the shared link from: edit?usp=sharing to: export?format=xlsx. Tried it a few times and it works even if multiple sheets and named ranges in the Google Sheets document. It is an interesting option! Hope you find it useful :))

[OMGdon]

@How To excel, Excellent advice! But how to make reverse operation - Get Excel data in Google Sheet?

[amjadhameed]

Thanks for sharing this usefully trick.
it worked when google sheet contains one tab.
it did not worked with more tab.. I am using 2019 EXCEL version .. thanks so much

[choolwenamoobe]

Thank you for the video.
I managed to create everything and it worked fine. But when I close and open the table (excel), the link is lost and I have to re-link it to be able to sync the data from Google Sheet. Would you have a solution to that so that when I close and open the excel the next day, I can just refresh and the data is imported from Google Sheet to excel?