![]() This is what we’ll accomplish, but first, we need to chat about file types. We would like to use Power Query to pull data stored in that file. When we open our browser, the Excel file looks like this: Let’s say that we have stored an Excel (or CSV) file in Google Drive. Objectiveīefore we get to the mechanics, let’s be clear on our goal here. ![]() #HOW TO GET EXCEL FILE FROM GOOGLE DRIVE ONLINE HOW TO#One day, I was in Excel and thinking to myself, “I wonder if I could use Power Query to retrieve data from an Excel file stored in Google Drive?” Although Google Drive isn’t listed in Power Query’s Get Data options, this post demonstrates how to use Power Query to pull data from an Excel (or csv) file stored in Google Drive. One of the services I use is Google Drive, and I have a variety of documents stored there. I’m sure that I use services from a dozen different providers every day. ![]() ![]() These days, it is common to use online services from many providers. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |