Power Query in Google Sheets

[snaplink22]

Hello,

I am attempting to run a power query in google sheets, but I am struggling to find online content to aid myself. I have multiple Google Sheet folders that contain multiple Google Sheet spreadsheets with data. I notice that inside the Google Sheet there is no "Get Data" option. Is it possible to run a power query in Google Sheets alone?

 

[alansidman]

Power Query is a Microsoft Excel function. Until Google comes up with its own version, you will need to do this exclusively within Excel. You could import your Google Sheets to Excel and then run a PQ.