Forum Discussion

Brass Contributor

Apr 09, 2019

Get external data from web not showing

Hello, I am trying to link external information from a url to my Excel spreadsheet, but for whatever reason the "Get data from Web" option is not showing up on my menu. Does anyone have any idea ...

Brass Contributor

Mar 10, 2021

Afraid not niyukt , had to eventually give up 😞

Copper Contributor

Apr 25, 2021

pdramorim Same problem! Have you found any other workaround? Thanks

Riny_van_Eekelen
Platinum Contributor
Apr 25, 2021
sferrero As mentioned in one of the previous posts, "Get data from the Web" is part of Power Query and is NOT supported by Excel for the Mac. So you may stop looking for it. If you want to get full Power Query functionality on a Mac, you need to set up a virtual Windows PC on it, via Parallels or Bootcamp, and run Excel from there.
- nike242453
  Copper Contributor
  Jun 11, 2022
  Riny_van_Eekelen im using the windows and on the web version of excel . i dont see "Get Data" either on my data tab..
  - SergeiBaklan
    Diamond Contributor
    Jun 11, 2022
    nike242453
    
    So far it is not implemented for Excel for web.
- nwstephens
  Copper Contributor
  Oct 07, 2021
  I have the same problem, but according to this page, "Excel for the Mac incorporates Power Query":
  
  https://support.microsoft.com/en-us/office/import-data-in-excel-for-mac-power-query-7b2f337d-e7d2-4fdf-bf00-3dfbb1e5e9c5
  - Riny_van_Eekelen
    Platinum Contributor
    Oct 07, 2021
    nwstephens Excel fo the Mac only incorporates a very limited PQ functionality. Connecting to the Web is not part of it.

Resources