Forum Discussion

ankitsingh2063's avatar
ankitsingh2063
Copper Contributor
Nov 09, 2022

Importing Data from Google drive to Excel Power Query

Hello community,

 

I am trying to write a Power Query to 'Get Data' from a Google Drive folder that contains multiple google sheets in the same format and same spreadsheet name across all files.

 

I am not sure where to start and how to start.

 

excel

2 Replies

    • Lorenzo's avatar
      Lorenzo
      Silver Contributor
      Apr 30, 2023

      mychellVALEC 

      If you're looking to combine several Google Sheets documents from Google Drive, that's currently only possible  via the https://learn.microsoft.com/en-us/power-query/connectors/google-sheets

Resources