Excel for Mac: Get Data --From Table/Range

%3CLINGO-SUB%20id%3D%22lingo-sub-2596975%22%20slang%3D%22en-US%22%3EExcel%20for%20Mac%3A%20Get%20Data%20--From%20Table%2FRange%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2596975%22%20slang%3D%22en-US%22%3E%3CP%3EPlease%20include%20the%20following%20info%20to%20help%20others%20answer%20your%20question%3A%3C%2FP%3E%3CUL%3E%3CLI%3E%3CSTRONG%3EDevice%20and%20OS%20platform%3C%2FSTRONG%3E%2C%20Mac%2FmacOS%20Big%20Sur%2011.5.1%3C%2FLI%3E%3CLI%3E%3CSTRONG%3EExcel%20product%20name%20and%20version%20number%2C%20%3C%2FSTRONG%3E365%20subscription%2F16.51%20(20171101)%3C%2FLI%3E%3CLI%3EI%20am%20looking%20for%20Get%20Data%20--%26gt%3B%20From%20Table%2FRange%20to%20Get%20to%20use%20Power%20Query%2C%20but%20Excel%20does%20not%20give%20me%20this%20option%20that%20I%20could%20see%20from%20Microsoft%20for%20Windows.%26nbsp%3B%3C%2FLI%3E%3CLI%3E%3CSTRONG%3EExpected%20result%3C%2FSTRONG%3E%3CSPAN%3E%26nbsp%3B%3C%2FSPAN%3Eand%3CSPAN%3E%26nbsp%3B%3C%2FSPAN%3E%3CSTRONG%3Emethod%3A%20%3C%2FSTRONG%3ESaw%20this%20instruction%20but%20not%20very%20instructional%3A%20%3CA%20href%3D%22https%3A%2F%2Fsupport.microsoft.com%2Fen-us%2Foffice%2Fimport-data-from-a-database-in-excel-for-mac-e127365a-02a5-47b5-8278-16dd65edbe61%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%22%3Ehttps%3A%2F%2Fsupport.microsoft.com%2Fen-us%2Foffice%2Fimport-data-from-a-database-in-excel-for-mac-e127365a-02a5-47b5-8278-16dd65edbe61%3C%2FA%3E%3CBR%20%2F%3EI%20also%20have%20Microsoft%20365%20Apps%20for%20enterprise.%20If%20I%20change%20my%20license%20on%20my%20Mac%2C%20will%20I%20have%20that%20functionality%20activated%20in%20Excel%3F%26nbsp%3B%3CBR%20%2F%3EThank%20you!%3C%2FLI%3E%3C%2FUL%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2596975%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%20on%20Mac%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2597345%22%20slang%3D%22en-US%22%3ERe%3A%20Excel%20for%20Mac%3A%20Get%20Data%20--From%20Table%2FRange%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2597345%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1117281%22%20target%3D%22_blank%22%3E%40Frances2021%3C%2FA%3E%26nbsp%3BDon't%20really%20know.%20Am%20just%20user%20like%20you.%20But%2C%20I'm%20hopeful.%20Right-click%20inside%20the%20table%20and%20choose%20%22Table%22.%20Then%20you%20will%20see%20this%3A%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22Screenshot%202021-08-01%20at%2020.34.51.png%22%20style%3D%22width%3A%20191px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F299767i4CC8FED1024E4CC3%2Fimage-size%2Flarge%3Fv%3Dv2%26amp%3Bpx%3D999%22%20role%3D%22button%22%20title%3D%22Screenshot%202021-08-01%20at%2020.34.51.png%22%20alt%3D%22Screenshot%202021-08-01%20at%2020.34.51.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3EThis%20tells%20me%20that%2C%20at%20some%20point%20of%20time%2C%20queries%20and%20DAX%20measures%20can%20be%20edited%20and%20parameters%20defined%2Fused.%20Wait%20and%20see.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2597313%22%20slang%3D%22en-US%22%3ERe%3A%20Excel%20for%20Mac%3A%20Get%20Data%20--From%20Table%2FRange%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2597313%22%20slang%3D%22en-US%22%3EIs%20creating%20or%20editing%20queries%20on%20Microsoft's%20roadmap%3F%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2597037%22%20slang%3D%22en-US%22%3ERe%3A%20Excel%20for%20Mac%3A%20Get%20Data%20--From%20Table%2FRange%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2597037%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1117281%22%20target%3D%22_blank%22%3E%40Frances2021%3C%2FA%3E%26nbsp%3BGet%20Data%20%2F%20From%20Table%2FRange%20(or%20%3CEM%3EFrom%20Sheet%3C%2FEM%3E%20in%20newer%20versions)%20is%20NOT%20available%20in%20Excel%20for%20Mac.%20It's%20part%20of%20the%20full%20PowerQuery%20functionality%20that%20comes%20with%20Excel%20for%20the%20Windows.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThe%20%3CSTRONG%3EGet%20Data%20(PowerQuery)%3C%2FSTRONG%3E%20button%20in%20Excel%20for%20Mac%20lets%20you%20connect%20to%20data%20in%20a%20workbook%20or%20a%20Txt%2FCsv%20file%2C%20but%20you%20can%20not%20(yet)%20create%20or%20edit%20queries.%20For%20the%20moment%2C%20all%20you%20can%20do%20is%20refresh%20certain%20queries%20that%20were%20created%20on%20the%20PC%20version.%3C%2FP%3E%3C%2FLINGO-BODY%3E
New Contributor

Please include the following info to help others answer your question:

  • Device and OS platform, Mac/macOS Big Sur 11.5.1
  • Excel product name and version number, 365 subscription/16.51 (20171101)
  • I am looking for Get Data --> From Table/Range to Get to use Power Query, but Excel does not give me this option that I could see from Microsoft for Windows. 
  • Expected result and method: Saw this instruction but not very instructional: https://support.microsoft.com/en-us/office/import-data-from-a-database-in-excel-for-mac-e127365a-02a...
    I also have Microsoft 365 Apps for enterprise. If I change my license on my Mac, will I have that functionality activated in Excel? 
    Thank you!
3 Replies

@Frances2021 Get Data / From Table/Range (or From Sheet in newer versions) is NOT available in Excel for Mac. It's part of the full PowerQuery functionality that comes with Excel for the Windows.

 

The Get Data (PowerQuery) button in Excel for Mac lets you connect to data in a workbook or a Txt/Csv file, but you can not (yet) create or edit queries. For the moment, all you can do is refresh certain queries that were created on the PC version.

Is creating or editing queries on Microsoft's roadmap?

@Frances2021 Don't really know. Am just user like you. But, I'm hopeful. Right-click inside the table and choose "Table". Then you will see this:

Screenshot 2021-08-01 at 20.34.51.png

This tells me that, at some point of time, queries and DAX measures can be edited and parameters defined/used. Wait and see.