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