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:
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.
An error occurred while saving the commentRy commented
It's just ONE function. ONE click. For the WHOLE internet!
I should be able to pull data from anywhere, any website, any time, without effort.
Whether it's an obscure blog, or Bing, or Google, I should be able to click PULL DATA, enter in the website, and then press GO, and the entire data feed should be placed in my sheet, or below the column I am highlighting, if it's just a few columns of data.
This function should be UNBREAKABLE and that will probably involve giving website a single unified simple API from which to make their data streamable to excel. Simple as that.
Then you can put in features such as a start date and end date in the ADVANCED part of this feature, wherein we can choose the constraints to place on the data we want to pull.
So for example,
I should be able to click PULL DATA
Then type in Weather.com/NYC
And get the entire data of NYC weather that Weather.com has.
Then I can in the advanced box, place dates only between this week and the forecasts of next week, and reduce the data pulled to just those two weeks, and other criteria can be under the advanced box.
This is a KEY FEATURE, and it needs to be "Click n Type" easy or easier to do this, and the function needs to be UNIFIED so that any participating website can have data pulled just as easily, as any other.
It's ONE function. ONE click. For the WHOLE internet!
Thanks for this suggestion. We will monitor the votes here and consider this suggestion along with the other requests.
Steve K [MS Excel]
17 votes1 comment · Excel for Mac » Charting, Mapping and Visualizations · Flag idea as inappropriate… · Admin →