SOLVED

Import data from web

%3CLINGO-SUB%20id%3D%22lingo-sub-2162109%22%20slang%3D%22fr-FR%22%3EImport%20data%20from%20web%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2162109%22%20slang%3D%22fr-FR%22%3EHello!%3CBR%20%2F%3EI'm%20a%20mac%20user%20and%20I%20use%20the%20last%20version%20of%20excel.%3CBR%20%2F%3EI%20would%20like%20to%20import%20data%20from%20web%20but%20the%20option%20that%20is%20available%20on%20the%20data%20section%20is%20not%20here.%3CBR%20%2F%3EI%20just%20have%20those%20three%20option.%3CBR%20%2F%3ECan%20you%20help%20me%20to%20add%20the%20option%20that%20we%20can%20see%20on%20the%20video%3F%20%3CA%20href%3D%22https%3A%2F%2Fsupport.microsoft.com%2Fen-us%2Foffice%2Fimport-data-from-external-data-sources-power-query-be4330b3-5356-486c-a168-b68e9e616f5a%3Fui%3Den-US%26amp%3Brs%3Den-US%26amp%3Bad%3DUS%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%22%3Ehttps%3A%2F%2Fsupport.microsoft.com%2Fen-us%2Foffice%2Fimport-data-from-external-data-sources-power-query-be4330b3-5356-486c-a168-b68e9e616f5a%3Fui%3Den-US%26amp%3Brs%3Den-US%26amp%3Bad%3DUS%3C%2FA%3E%3CBR%20%2F%3E%3CBR%20%2F%3E%20Thanks%20%3CLI-EMOJI%20id%3D%22lia_red-heart%22%20title%3D%22%3Ared_heart%3A%22%3E%3C%2FLI-EMOJI%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2162109%22%20slang%3D%22fr-FR%22%3E%3CLINGO-LABEL%3EExcel%20on%20Mac%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2162201%22%20slang%3D%22en-US%22%3ERe%3A%20Import%20data%20from%20web%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2162201%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F977145%22%20target%3D%22_blank%22%3E%40dodoexc%3C%2FA%3E%26nbsp%3BUnfortunately%2C%20Power%20Query%20is%20NOT%20featured%20in%20Excel%20for%20Mac.%20You%20need%20a%20Windows%20PC%20to%20create%20and%20edit%20queries.%20Some%20queries%20can%20be%20refreshed%20on%20a%20Mac%2C%20though.%3C%2FP%3E%3CP%3EMore%20about%20that%20in%20the%20attached%20link.%3C%2FP%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Fsupport.microsoft.com%2Fen-us%2Foffice%2Fuse-power-query-in-excel-for-mac-7b2f337d-e7d2-4fdf-bf00-3dfbb1e5e9c5%22%20target%3D%22_self%22%20rel%3D%22noopener%20noreferrer%22%3Ehttps%3A%2F%2Fsupport.microsoft.com%2Fen-us%2Foffice%2Fuse-power-query-in-excel-for-mac-7b2f337d-e7d2-4fdf-bf00-3dfbb1e5e9c5%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E
Occasional Visitor
Hello !
I’m a mac user and I use the last version of excel.
I would like to import data from web but the option that is available on the data section is not here.
I just have those three option.
Can you help me to add the option that we can see on the video ? https://support.microsoft.com/en-us/office/import-data-from-external-data-sources-power-query-be4330...

Thanks
1 Reply
best response confirmed by dodoexc (Occasional Visitor)
Solution

@dodoexc Unfortunately, Power Query is NOT featured in Excel for Mac. You need a Windows PC to create and edit queries. Some queries can be refreshed on a Mac, though.

More about that in the attached link.

https://support.microsoft.com/en-us/office/use-power-query-in-excel-for-mac-7b2f337d-e7d2-4fdf-bf00-...