Shape data with Power Query Editor in Excel for Mac
Power Query is a powerful and time-saving set of tools that helps you get and shape data quickly and easily. When this tool was first released in Excel for Mac, there was incredible excitement around the new capabilities now available on your Mac device. Power Query in Excel for Mac allows you to clean and shape your data from local files, SharePoint, SQL, as well as from tables and ranges.
We’ve heard your feedback and we are excited to share that you can now clean and shape your data with hundreds of transformations available in Power Query Editor in Excel for Mac.
UPDATE (31-Aug-2022) This feature is available to Insiders using either the Current Channel Preview or Beta Channel, running Version 16.64 (Build 22072501) or later. It was previously only available to Insiders on the Beta Channel.
We typically release features over a period of time to ensure that things are working smoothly. This is true for Insiders as well. We highlight features that you may not have because they’re slowly released to larger numbers of Insiders. Sometimes we remove elements to further improve them based on your feedback. Though it is rare, we also reserve the option to pull a feature entirely out of the product, even if you, as Insiders, have had the opportunity to try them.
We’d love to hear from you! Please click Help > Feedback to submit your feedback about this feature.
