Home

Get external data from web not showing

%3CLINGO-SUB%20id%3D%22lingo-sub-414906%22%20slang%3D%22en-US%22%3EGet%20external%20data%20from%20web%20not%20showing%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-414906%22%20slang%3D%22en-US%22%3E%3CP%3EHello%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20am%20trying%20to%20link%20external%20information%20from%20a%20url%20to%20my%20Excel%20spreadsheet%2C%20but%20for%20whatever%20reason%20the%26nbsp%3B%22Get%20data%20from%20Web%22%20option%20is%20not%20showing%20up%20on%20my%20menu.%20Does%20anyone%20have%20any%20idea%20why%20this%20might%20be%20happening%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ESee%20attached%20a%20screenshot%20of%20what%20I'm%20getting.%20Shouldn't%20that%20option%20be%20appearing%20between%20the%20%22From%20HTML%22%20and%20%22From%20Text%22%20options%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI'm%20on%20Microsoft%20Excel%20for%20Mac%2C%20version%2016.23%20(19.03.09)%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThanks%20in%20advance%2C%3C%2FP%3E%3CP%3EPedro%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-414906%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EExcel%20on%20Mac%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-419095%22%20slang%3D%22en-US%22%3ERe%3A%20Get%20external%20data%20from%20web%20not%20showing%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-419095%22%20slang%3D%22en-US%22%3EHave%20you%20tried%20%22From%20html%22%3F%20Seems%20to%20me%20that%20is%20the%20one%20you%20need%3F%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-419118%22%20slang%3D%22en-US%22%3ERe%3A%20Get%20external%20data%20from%20web%20not%20showing%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-419118%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F22322%22%20target%3D%22_blank%22%3E%40Jan%20Karel%20Pieterse%3C%2FA%3E%26nbsp%3Bthat%20was%20my%20first%20thought%2C%20but%20%22from%20HTML%22%20just%20prompts%20me%20to%20select%20an%20HTML%20file%20from%20a%20local%20folder.%20It%20doesn't%20give%20me%20the%20option%20to%20select%20a%20web%20link%2C%20which%20is%20what%20the%20%22from%20Web%22%20option%20allows.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThis%20is%20so%20frustrating%2C%20every%20single%20tutorial%20I've%20been%20able%20to%20find%20clearly%20points%20users%20to%20the%20%22from%20Web%22%20option%20specifically%2C%20but%20it's%20simply%20nowhere%20to%20be%20found%20on%20my%20menu.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-419136%22%20slang%3D%22en-US%22%3ERe%3A%20Get%20external%20data%20from%20web%20not%20showing%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-419136%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F315250%22%20target%3D%22_blank%22%3E%40pdramorim%3C%2FA%3E%26nbsp%3B%2C%20Get%20Data%20from%20Web%20is%20Power%20Query%20connector%2C%20I'm%20not%20sure%20it%20is%20supported%20for%20Mac%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-419180%22%20slang%3D%22en-US%22%3ERe%3A%20Get%20external%20data%20from%20web%20not%20showing%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-419180%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F521%22%20target%3D%22_blank%22%3E%40Sergei%20Baklan%3C%2FA%3E%2C%26nbsp%3BI%20see.%20That%20would%20certainly%20explain%20why%20I%20can't%20see%20it%20on%20my%20end.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EIf%20that%20is%20indeed%20the%20case%2C%20that's%20actually%20even%20more%20frustrating.%20Is%20there%20no%20other%20way%20to%20have%20live%20information%20being%20fed%20from%20a%20website%20into%20my%20spreadsheet%20if%20I'm%20working%20off%20a%20mac%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-419320%22%20slang%3D%22en-US%22%3ERe%3A%20Get%20external%20data%20from%20web%20not%20showing%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-419320%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F315250%22%20target%3D%22_blank%22%3E%40pdramorim%3C%2FA%3E%26nbsp%3B%2C%20sorry%2C%20I%20never%20worked%20with%20Mac.%20Please%20check%20this%20user%20voice%20discussion%20if%20some%20comments%20help%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Fexcel.uservoice.com%2Fforums%2F304933-excel-for-mac%2Fsuggestions%2F19688344-add-import-from-web-to-the-mac-excel%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%20noopener%20noreferrer%22%3Ehttps%3A%2F%2Fexcel.uservoice.com%2Fforums%2F304933-excel-for-mac%2Fsuggestions%2F19688344-add-import-from-web-to-the-mac-excel%3C%2FA%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E
pdramorim
Occasional Contributor

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 why this might be happening?

 

See attached a screenshot of what I'm getting. Shouldn't that option be appearing between the "From HTML" and "From Text" options?

 

I'm on Microsoft Excel for Mac, version 16.23 (19.03.09)

 

Thanks in advance,

Pedro

5 Replies
Have you tried "From html"? Seems to me that is the one you need?

@Jan Karel Pieterse that was my first thought, but "from HTML" just prompts me to select an HTML file from a local folder. It doesn't give me the option to select a web link, which is what the "from Web" option allows.

 

This is so frustrating, every single tutorial I've been able to find clearly points users to the "from Web" option specifically, but it's simply nowhere to be found on my menu.

@pdramorim , Get Data from Web is Power Query connector, I'm not sure it is supported for Mac

@Sergei Baklan, I see. That would certainly explain why I can't see it on my end.

 

If that is indeed the case, that's actually even more frustrating. Is there no other way to have live information being fed from a website into my spreadsheet if I'm working off a mac?

@pdramorim , sorry, I never worked with Mac. Please check this user voice discussion if some comments help https://excel.uservoice.com/forums/304933-excel-for-mac/suggestions/19688344-add-import-from-web-to-...

Related Conversations
Tabs and Dark Mode
cjc2112 in Discussions on
38 Replies
Extentions Synchronization
Deleted in Discussions on
3 Replies
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies
flashing a white screen while open new tab
Deleted in Discussions on
14 Replies
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
29 Replies
Security Community Webinars
Valon_Kolica in Security, Privacy & Compliance on
13 Replies