Forum Discussion

Copper Contributor

Oct 26, 2023

Excel issue importing data from the web

I am trying to import data from a website but I do not have the option/button to "get & transfer". I have looked at many Youtube videos and all the Microsoft help articles and every one directs you t...

Excel on Mac

Riny_van_Eekelen

Platinum Contributor

Oct 26, 2023

Simon63 If you are an MS365 subscriber you should have the option on the Data ribbon. The icon name is "Get Data (Power Query)".

But, since you are a Mac, you can't connect to the Web since that connector simply is not (yet) supported in Excel for Mac.

Can't understand why on-line chat suggested to uninstall and reinstall. Total waste of time.

There is no solution other than to wait until MS adds the web connector to PQ for the Mac. Running full version PQ on a Mac requires running Windows with Excel on a virtual PC with Bootcamp or Parallels.

Simon63
Copper Contributor
Oct 26, 2023
Riny_van_Eekelen thank you for that I appreciate you taking the time.
What is weird is that I used to be able to do this and there was a way to do it on a mac, albeit quite convoluted, I just can't remember how!
- Riny_van_Eekelen
  Platinum Contributor
  Oct 26, 2023
  Simon63 That may have been via Run Web Query..., nowadays stashed a way under Data (top menu) then Get Data (Power Query)
  Quite odd as it has nothing to do with Power Query. I have no hands on experience with Web Query.