%3CLINGO-SUB%20id%3D%22lingo-sub-1782903%22%20slang%3D%22en-US%22%3EAnnouncing%20Power%20Query%20Data%20Types%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1782903%22%20slang%3D%22en-US%22%3E%3CP%3EWe%20are%20excited%20to%20announce%20a%20new%20and%20exciting%20update%20to%20%3CA%20href%3D%22https%3A%2F%2Faka.ms%2Fgtxl2016%22%20target%3D%22_self%22%20rel%3D%22noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%22%3EGet%20%26amp%3B%20Transform%20Data%20capabilities%3C%2FA%3E%20in%20Excel%20%E2%80%93%20Power%20Query%20data%20types!%20This%20tool%20will%20help%20you%20organize%20your%20data%20better%20and%20consume%20it%20easily.%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EPower%20Query%20data%20types%20are%20available%20as%20part%20of%20an%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Fproducts.office.com%2Fbuy%2Fcompare-microsoft-office-products%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%22%3EOffice%20365%20subscription%3C%2FA%3E.%20If%20you%20are%20an%20Office%20365%20subscriber%2C%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Fsupport.microsoft.com%2Foffice%2Fda36192c-58b9-4bc9-8d51-bb6eed468516%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%22%3Efind%20out%20how%20to%20get%20the%20latest%20updates%3C%2FA%3E.%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EThe%20following%20sections%20describe%20how%20create%20data%20types%20with%20Power%20Query%20and%20how%20to%20consume%20them%20in%20Excel.%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%3CSTRONG%3EPower%20Query%20data%20types%26nbsp%3B%3C%2FSTRONG%3E%3C%2FP%3E%0A%3CP%3EPower%20Query%20is%20a%20powerful%20and%E2%80%AFtime-saving%E2%80%AFtool%26nbsp%3Bused%26nbsp%3Bto%20gather%20and%26nbsp%3Banalyze%20large%20sets%20of%20data%20by%20organizing%26nbsp%3Bthem%26nbsp%3Bin%20a%20way%20that%20will%20make%20its%20consumption%20in%20Excel%20much%20easier.%26nbsp%3BWith%20this%20feature%2C%20you%20can%20create%20custom%20data%20types%20from%20any%20and%20load%26nbsp%3Bthem%26nbsp%3Bin%26nbsp%3Bthe%20Excel%20grid%20as%20rich%20values.%26nbsp%3B%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%3CSTRONG%3EHow%20to%20use%20it%26nbsp%3B%3C%2FSTRONG%3E%3C%2FP%3E%0A%3COL%3E%0A%3CLI%3EStart%20with%26nbsp%3B%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%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%22%3Eimporting%20the%20data%20set%26nbsp%3B%3C%2FA%3Eusing%20Power%20Query.%3CBR%20%2F%3E%3CBR%20%2F%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22Picture1.png%22%20style%3D%22width%3A%20999px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F226949iB8B704EE414267DC%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20role%3D%22button%22%20title%3D%22Picture1.png%22%20alt%3D%22Picture1.png%22%20%2F%3E%3C%2FSPAN%3E%3CBR%20%2F%3E%3CBR%20%2F%3E%3C%2FLI%3E%0A%3CLI%3EIn%20the%20Power%20Query%20Editor%2C%20select%20the%20relevant%20columns%2C%26nbsp%3Band%20then%26nbsp%3Bclick%20the%26nbsp%3B%3CSTRONG%20style%3D%22color%3A%20black%3B%22%3ECreate%20Data%20Type%3C%2FSTRONG%3E%3CSPAN%20style%3D%22color%3A%20black%3B%22%3E%26nbsp%3Bbutton%26nbsp%3Bon%20the%26nbsp%3BTransform%26nbsp%3Btab.%3CBR%20%2F%3E%3CBR%20%2F%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22Picture2.png%22%20style%3D%22width%3A%20999px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F226950iB2BF761161FF2D5D%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20role%3D%22button%22%20title%3D%22Picture2.png%22%20alt%3D%22Picture2.png%22%20%2F%3E%3C%2FSPAN%3E%3CBR%20%2F%3E%3CBR%20%2F%3E%3C%2FSPAN%3E%3C%2FLI%3E%0A%3CLI%3E%3CSPAN%20style%3D%22color%3A%20black%3B%22%3E%3CSPAN%3EDefine%20the%20data%20type%20name%20and%20choose%20a%20display%20column.%3CBR%20%2F%3E%3CBR%20%2F%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22Picture3.png%22%20style%3D%22width%3A%20624px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F226951iF368EC6F5E2521F7%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20role%3D%22button%22%20title%3D%22Picture3.png%22%20alt%3D%22Picture3.png%22%20%2F%3E%3C%2FSPAN%3E%3CBR%20%2F%3E%3CBR%20%2F%3E%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FLI%3E%0A%3CLI%3E%3CSPAN%20style%3D%22color%3A%20black%3B%22%3E%3CSPAN%3ENotice%20the%20selected%20columns%20are%20collapsed%20into%20a%20single%20data%20type%20column%20and%20click%20the%20Close%20and%20Load%20button%20on%20the%20Home%20tab%20to%20load%20the%20query%20into%20Excel.%3CBR%20%2F%3E%3CBR%20%2F%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22Picture4.png%22%20style%3D%22width%3A%20999px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F226952i6B43C3F279F1ED5C%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20role%3D%22button%22%20title%3D%22Picture4.png%22%20alt%3D%22Picture4.png%22%20%2F%3E%3C%2FSPAN%3E%3CBR%20%2F%3E%3CBR%20%2F%3E%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FLI%3E%0A%3CLI%3E%3CSPAN%20style%3D%22color%3A%20black%3B%22%3E%3CSPAN%3EEasily%20consume%20and%20explore%20the%E2%80%AFoutput%20of%20the%20query%20in%20Excel%20with%20interactive%20data%20cards%20and%20formulas%20that%20reference%20your%20rich%20values.%3CBR%20%2F%3E%3CBR%20%2F%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22Picture5.png%22%20style%3D%22width%3A%20557px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F226953i4975BDF15DA5632C%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20role%3D%22button%22%20title%3D%22Picture5.png%22%20alt%3D%22Picture5.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FSPAN%3E%3CBR%20%2F%3E%3CSPAN%20style%3D%22color%3A%20black%3B%22%3E%3CSPAN%3E%3CBR%20%2F%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22Picture6.png%22%20style%3D%22width%3A%20624px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F226954i045192017E301931%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20role%3D%22button%22%20title%3D%22Picture6.png%22%20alt%3D%22Picture6.png%22%20%2F%3E%3C%2FSPAN%3E%3CBR%20%2F%3E%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FLI%3E%0A%3C%2FOL%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%3CSPAN%20style%3D%22color%3A%20black%3B%22%3E%3CSPAN%3E%3CSTRONG%3EScenarios%20to%20try%20%3C%2FSTRONG%3E%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%3E%3CSPAN%20style%3D%22color%3A%20black%3B%22%3E%3CSPAN%3EInteract%20with%20the%20data%20types%3A%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%3E%3CSPAN%20style%3D%22color%3A%20black%3B%22%3E%3CSPAN%3ECheck%20out%20the%20data%20type%20fields%20by%20clicking%20the%26nbsp%3B%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22icon1.jpg%22%20style%3D%22width%3A%2043px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F226956i1D091CC1F62F8406%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20role%3D%22button%22%20title%3D%22icon1.jpg%22%20alt%3D%22icon1.jpg%22%20%2F%3E%3C%2FSPAN%3E%20icon%20the%20cell%2C%20and%20then%20open%20the%20associated%20card.%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%3E%3CSPAN%20style%3D%22color%3A%20black%3B%22%3E%3CSPAN%3EExtract%20fields%20to%20the%20grid%20by%20clicking%20the%26nbsp%3B%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22icon2.jpg%22%20style%3D%22width%3A%2042px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F226958iCD7D962249F33B3A%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20role%3D%22button%22%20title%3D%22icon2.jpg%22%20alt%3D%22icon2.jpg%22%20%2F%3E%3C%2FSPAN%3E%20button.%20Use%20the%20data%20type%20fields%20in%20Excel%20formulas%20by%20referencing%20to%20a%20cell%20with%20a%20data%20type.%20%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%3E%3CSPAN%20style%3D%22color%3A%20black%3B%22%3E%3CSPAN%3ERefresh%20data%20types%20by%20clicking%20the%26nbsp%3B%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22icon3.png%22%20style%3D%22width%3A%2041px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F226957iF4CE546E842ED284%2Fimage-dimensions%2F41x47%3Fv%3D1.0%22%20width%3D%2241%22%20height%3D%2247%22%20role%3D%22button%22%20title%3D%22icon3.png%22%20alt%3D%22icon3.png%22%20%2F%3E%3C%2FSPAN%3E%26nbsp%3B%20button%20%E2%80%93%20from%20the%20data%20type%20context%20menu%2C%20the%20respective%20query%20context%20menu%2C%20or%20the%20Data%20tab%20in%20the%20Excel%20ribbon.%3CBR%20%2F%3E%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%3CSPAN%20style%3D%22color%3A%20black%3B%22%3E%3CSPAN%3E%3CSTRONG%3ERequirements%3C%2FSTRONG%3E%20%3CBR%20%2F%3ETo%20use%20Power%20Query%20data%20types%20in%20Excel%2C%20you%20must%20meet%20these%20requirements%3A%20%3CBR%20%2F%3E%E2%80%A2%20You%20are%E2%80%AFin%20an%20organization%20with%20an%20%3CA%20href%3D%22https%3A%2F%2Fproducts.office.com%2Fbuy%2Fcompare-microsoft-office-products%22%20target%3D%22_self%22%20rel%3D%22noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%22%3EOffice%20365%20subscription%3C%2FA%3E.%20%3CBR%20%2F%3E%E2%80%A2%20You%20are%20using%20Excel%20for%20Windows.%20%3CBR%20%2F%3E%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%3CSPAN%20style%3D%22color%3A%20black%3B%22%3E%3CSPAN%3E%3CSTRONG%3EMore%20Resources%3C%2FSTRONG%3E%3CBR%20%2F%3ECheck%20out%20this%20video%20from%20one%20of%20Microsoft%20Excel%E2%80%99s%20Creators%2C%20Mynda%20Treacy%20from%20%3CA%20href%3D%22https%3A%2F%2Fwww.youtube.com%2Fchannel%2FUCiYjpuUaSfkvdZkmtDU7JRw%22%20target%3D%22_self%22%20rel%3D%22nofollow%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%22%3EMyOnlineTrainingHub%3C%2FA%3E%3A%3CBR%20%2F%3E%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%3CSPAN%20style%3D%22color%3A%20black%3B%22%3E%3CSPAN%3E%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FP%3E%3CDIV%20class%3D%22video-embed-center%20video-embed%22%3E%3CIFRAME%20class%3D%22embedly-embed%22%20src%3D%22https%3A%2F%2Fcdn.embedly.com%2Fwidgets%2Fmedia.html%3Fsrc%3Dhttps%253A%252F%252Fwww.youtube.com%252Fembed%252Fjm_PA1h76vY%253Ffeature%253Doembed%26amp%3Bdisplay_name%3DYouTube%26amp%3Burl%3Dhttps%253A%252F%252Fwww.youtube.com%252Fwatch%253Fv%253Djm_PA1h76vY%26amp%3Bimage%3Dhttps%253A%252F%252Fi.ytimg.com%252Fvi%252Fjm_PA1h76vY%252Fhqdefault.jpg%26amp%3Bkey%3Db0d40caa4f094c68be7c29880b16f56e%26amp%3Btype%3Dtext%252Fhtml%26amp%3Bschema%3Dyoutube%22%20width%3D%22400%22%20height%3D%22225%22%20scrolling%3D%22no%22%20title%3D%22YouTube%20embed%22%20frameborder%3D%220%22%20allow%3D%22autoplay%3B%20fullscreen%22%20allowfullscreen%3D%22true%22%3E%3C%2FIFRAME%3E%3C%2FDIV%3E%3CP%3E%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%3CSPAN%20style%3D%22color%3A%20black%3B%22%3E%3CSPAN%3E%3CBR%20%2F%3EMicrosoft%20%3CA%20href%3D%22https%3A%2F%2Fsupport.microsoft.com%2Fen-us%2Foffice%2Flearn-with-microsoft-creators-5e8000ee-596a-423c-8438-357982c36491%22%20target%3D%22_self%22%20rel%3D%22noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%22%3ECreators%3C%2FA%3E%20are%20community%20experts%20who%20create%20video%20content%20on%20YouTube%20that%20can%20help%20you%20learn%20how%20to%20use%20Microsoft%20products%20and%20services.%20Their%20content%20appears%20in%20the%20following%20playlists%20on%20the%20Microsoft%20365%20channel.%3CBR%20%2F%3E%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%3CSTRONG%3ECustomer%20Feedback%20%3C%2FSTRONG%3E%3CBR%20%2F%3EWe%20hope%20you%20like%20this%20new%20addition%20to%20Excel%20and%20we%E2%80%99d%20love%20to%20hear%20what%20you%20think%20about%20it!%3C%2FP%3E%0A%3CP%3ELet%20us%20know%20by%20using%20the%20Feedback%20button%20in%20the%20top%20right%20corner%20in%20Excel%20-%20add%E2%80%AF%23PowerQuery%E2%80%AFin%20your%20feedback%20so%20that%20we%20can%20find%20it%20easily.%20%3CBR%20%2F%3EFor%20more%20activities%2C%20join%20the%20conversations%20in%20our%20Excel%20Tech%20Community%20at%20%3CA%20href%3D%22https%3A%2F%2Faka.ms%2FExcelCommunity%22%20target%3D%22_self%22%20rel%3D%22noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%22%3Eaka.ms%2FExcelCommunity%3C%2FA%3E.%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EJonathan%20Kahati%3CBR%20%2F%3E~%20Excel%20Team%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-TEASER%20id%3D%22lingo-teaser-1782903%22%20slang%3D%22en-US%22%3E%3CP%3EPower%20Query%20is%20a%20powerful%20and%E2%80%AFtime-saving%E2%80%AFtool%26nbsp%3Bused%26nbsp%3Bto%20gather%20and%26nbsp%3Banalyze%20large%20sets%20of%20data%20by%20organizing%26nbsp%3Bthem%26nbsp%3Bin%20a%20way%20that%20will%20make%20its%20consumption%20in%20Excel%20much%20easier.%26nbsp%3BWith%20this%20feature%2C%20you%20can%20create%20custom%20data%20types%20from%20any%20and%20load%26nbsp%3Bthem%26nbsp%3Bin%26nbsp%3Bthe%20Excel%20grid%20as%20rich%20values.%26nbsp%3B%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-TEASER%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1782903%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EPower%20Query%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1835356%22%20slang%3D%22en-US%22%3ERe%3A%20Announcing%20Power%20Query%20Data%20Types%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1835356%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F671201%22%20target%3D%22_blank%22%3E%40jokahati%3C%2FA%3E%26nbsp%3B%2C%20great%20to%20know%20it's%20GA%20now.%20On%20which%20channels%20this%20functionality%20is%20available%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1835357%22%20slang%3D%22en-US%22%3ERe%3A%20Announcing%20Power%20Query%20Data%20Types%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1835357%22%20slang%3D%22en-US%22%3E%3CP%3EAwesome%20to%20have%20Custom%20Data%20Types%20available%20in%20Excel.%20Congratulations%20to%20the%20Excel%20Team!%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EMynda%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1835363%22%20slang%3D%22en-US%22%3ERe%3A%20Announcing%20Power%20Query%20Data%20Types%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1835363%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F133371%22%20target%3D%22_blank%22%3E%40Mynda%20Treacy%3C%2FA%3E%26nbsp%3B%2C%20everyone%20in%20this%20world%20who%20knows%20something%20about%20Excel%20knows%20you%20as%20Excel%20MVP%2C%20but%20why%20don't%20you%20ask%20%3CA%20href%3D%22mailto%3Atechcommunity%40microsoft.com%22%20target%3D%22_blank%22%20rel%3D%22nofollow%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%22%3Etechcommunity%40microsoft.com%3C%2FA%3E%26nbsp%3Bto%20change%20your%20status%20on%20this%20resource%20accordingly.%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F320924%22%20target%3D%22_blank%22%3E%40cuong%3C%2FA%3E%26nbsp%3B%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1835439%22%20slang%3D%22en-US%22%3ERe%3A%20Announcing%20Power%20Query%20Data%20Types%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1835439%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%26nbsp%3Bgreat%20idea!%20Thanks%20for%20mentioning%20it.%20Hopefully%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F320924%22%20target%3D%22_blank%22%3E%40cuong%3C%2FA%3E%26nbsp%3Bcan%20make%20it%20happen.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1835811%22%20slang%3D%22en-US%22%3ERe%3A%20Announcing%20Power%20Query%20Data%20Types%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1835811%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F133371%22%20target%3D%22_blank%22%3E%40Mynda%20Treacy%3C%2FA%3E%26nbsp%3BDone.%20Thanks%20to%20the%20Tech%20Community%20team!%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1842446%22%20slang%3D%22en-US%22%3ERe%3A%20Announcing%20Power%20Query%20Data%20Types%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1842446%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%26nbsp%3BThanks!%3C%2FP%3E%0A%3CP%3ECurrent%20Channel%20-%20rolling%20to%20Production%20as%20we%20speak.%3C%2FP%3E%0A%3CP%3EMEC%20should%20follow%2C%20so%20estimating%20a%20few%20weeks.%3C%2FP%3E%0A%3CP%3ESemi-Annual%20-%20next%20year%2C%20not%20sure%20yet%20if%20Jan%2FJun%20(depends%20on%20stability%20and%20other%20factors).%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1848651%22%20slang%3D%22en-US%22%3ERe%3A%20Announcing%20Power%20Query%20Data%20Types%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1848651%22%20slang%3D%22en-US%22%3E%3CP%3EThis%20is%20a%20real%20game%20changer.%20Not%20as%20big%20as%20Power%20Query%20(of%20which%20this%20is%20a%20capability%20enhancement)%2C%20but%20bigger%20than%20dynamic%20arrays%20(which%20rocked%20our%20small%20company%E2%80%99s%20world).%20I%E2%80%99ve%20been%20trying%20to%20hold%20my%20breath%20about%20its%20GA%20release%20since%20I%20saw%20Mynda%E2%80%99s%20preview%20on%20YouTube.%20Now%2C%20I%20will%20exhale%20%26amp%3B%20breathe.%20Well%20done%2C%20Excel%20Team!%3C%2FP%3E%3C%2FLINGO-BODY%3E
Microsoft

We are excited to announce a new and exciting update to Get & Transform Data capabilities in Excel – Power Query data types! This tool will help you organize your data better and consume it easily.

 

Power Query data types are available as part of an Office 365 subscription. If you are an Office 365 subscriber, find out how to get the latest updates.

 

The following sections describe how create data types with Power Query and how to consume them in Excel.

 

Power Query data types 

Power Query is a powerful and time-saving tool used to gather and analyze large sets of data by organizing them in a way that will make its consumption in Excel much easier. With this feature, you can create custom data types from any and load them in the Excel grid as rich values.  

 

How to use it 

  1. Start with importing the data set using Power Query.

    Picture1.png

  2. In the Power Query Editor, select the relevant columns, and then click the Create Data Type button on the Transform tab.

    Picture2.png

  3. Define the data type name and choose a display column.

    Picture3.png

  4. Notice the selected columns are collapsed into a single data type column and click the Close and Load button on the Home tab to load the query into Excel.

    Picture4.png

  5. Easily consume and explore the output of the query in Excel with interactive data cards and formulas that reference your rich values.

    Picture5.png


    Picture6.png

 

Scenarios to try

Interact with the data types:

Check out the data type fields by clicking the icon1.jpg icon the cell, and then open the associated card.

Extract fields to the grid by clicking the icon2.jpg button. Use the data type fields in Excel formulas by referencing to a cell with a data type.

Refresh data types by clicking the icon3.png  button – from the data type context menu, the respective query context menu, or the Data tab in the Excel ribbon.

 

Requirements
To use Power Query data types in Excel, you must meet these requirements:
• You are in an organization with an Office 365 subscription.
• You are using Excel for Windows.

 

More Resources
Check out this video from one of Microsoft Excel’s Creators, Mynda Treacy from MyOnlineTrainingHub:

 

 


Microsoft Creators are community experts who create video content on YouTube that can help you learn how to use Microsoft products and services. Their content appears in the following playlists on the Microsoft 365 channel.

 

Customer Feedback
We hope you like this new addition to Excel and we’d love to hear what you think about it!

Let us know by using the Feedback button in the top right corner in Excel - add #PowerQuery in your feedback so that we can find it easily.
For more activities, join the conversations in our Excel Tech Community at aka.ms/ExcelCommunity.

 

Jonathan Kahati
~ Excel Team

7 Comments

@jokahati , great to know it's GA now. On which channels this functionality is available?

Awesome to have Custom Data Types available in Excel. Congratulations to the Excel Team!

 

Mynda

@Mynda Treacy , everyone in this world who knows something about Excel knows you as Excel MVP, but why don't you ask techcommunity@microsoft.com to change your status on this resource accordingly. @cuong ?

@Sergei Baklan great idea! Thanks for mentioning it. Hopefully @cuong can make it happen.

Microsoft

@Mynda Treacy Done. Thanks to the Tech Community team!

Microsoft

@Sergei Baklan Thanks!

Current Channel - rolling to Production as we speak.

MEC should follow, so estimating a few weeks.

Semi-Annual - next year, not sure yet if Jan/Jun (depends on stability and other factors).

New Contributor

This is a real game changer. Not as big as Power Query (of which this is a capability enhancement), but bigger than dynamic arrays (which rocked our small company’s world). I’ve been trying to hold my breath about its GA release since I saw Mynda’s preview on YouTube. Now, I will exhale & breathe. Well done, Excel Team!