We are pleased to announce that the first set of Power Query features are now available in version 16.29 and greater. At this stage you can refresh from text, CSV, XLSX, JSON and XML files.

Refer to the following blog post for more details:
https://techcommunity.microsoft.com/t5/Excel-Blog/Get-amp-Transform-Power-Query-in-Excel-for-Mac-Phase-1/ba-p/876840

I encourage you to try the new functionality and share your feedback with us via Send a Smile/Frown at the top right corner in your Excel for Mac.

Thanks for supporting this suggestion with your votes. It’s unlikely that we’ll be able to bring PowerPivot to Excel for Mac, because it relies on features of the operating system that don’t exist on Mac OS. We’ll keep tracking votes, since we know that the scenarios made possible by PowerPivot are important, even if the solution will need to be something else.

Thanks for the suggestion and for the support of this feature. If you meant to vote for the Data Form, which is different than VBA UserForms, please change your vote to that suggestion instead. From reading the comments on this one, it seems that some clarification was needed.

I updated the title and description for this one and we’ll continue to monitor for comments and votes.

Here’s the link to the Data Form suggestion – https://excel.uservoice.com/forums/304933-excel-for-mac/suggestions/17930662-restore-data-form-functionality

Steve K [MS Excel]

Thanks for all your comments and votes supporting this suggestion. We are in the planning stages for this feature to be added to Excel for Mac.

Thanks – Steve K [MS Excel]

Hi all – we are evaluating this request, but we want to find the best solution for your data analysis needs. It would be helpful if you would describe what you are trying to accomplish with your data so we can understand whether there’s a better way than by using the PivotTable Wizard to consolidate multiple ranges.

Please add your comments to the suggestion in Excel.UserVoice.com.

Thanks – Steve K [MS Excel]

Thanks for the suggestion about the Data Form. We don’t have plans to implement this in the near future, so we’re marking it “Not at this time”.

We recommend using Tables to make data entry easy. To create a table, just press CMD+T. With a table, you can press TAB to move across the fields and then it will automatically go to the beginning of the next line if you’re at the last field. If you’re on the last record in the table, it will add a new record to the end of the list.

Please comment to let us know what other reasons you’re using the Data Form that make it easier/better than using a Table.

Thanks for supporting this idea with your votes. We don’t have a plan to add this feature in the near future, but we will continue to keep tracking the votes.

Steve K [MS Excel]

Thanks for all your comments and votes supporting this suggestion. Please keep adding votes. We are considering this for a future update.

Thanks – Steve K [MS Excel]

Thanks for the suggestion and the votes about 3D maps. We will continue to monitor the suggestion and prioritize it accordingly.

Steve K [MS Excel]

Thank you all for all of your comments and votes supporting this suggestion. We are now in the final planning stages towards starting the development of this feature.

Steve [MS Excel]

Thanks for the suggestion and the votes. We will continue to monitor the votes to help prioritize this along with other data connection requests. You may want to add a comment about connecting to SharePoint in the thread discussing PowerQuery.

Steve K [MS Excel]

Thanks for this suggestion. The FORECAST.ETS functions are available in version 16.x of Excel for Mac. We will continue to monitor this suggestion and prioritize it as appropriate with the other suggestions here.

Steve K [MS Excel]

Thanks for all your comments and votes supporting this suggestion. It would be very helpful if you would add more information about how you’d like to use fuzzy lookup in Excel.

Thanks – Steve K [MS Excel]

Thanks for all your comments and votes supporting this suggestion. We will continue to monitor this forum.

Thanks – Steve K [MS Excel]

We are investigating the best way to improve the performance of drawing charts after scrolling, and are prioritizing this along with all the other requests here.

Steve K [MS Excel]

This is an interesting idea, and we will consider it, but we are not planning on implementing this in the short term.

Thanks for the suggestions. We will monitor the votes on this to prioritize along with the other suggestions here.

Steve K [MS Excel]