Forum Discussion
JSON to Excel | Apple version of Office subscription
Folks, I am using 2019 version of Microsoft Office with subscription. I wanted to transform the Json data (downloaded in my computer) to excel. I am supposed to use "new query" button under "Data...
I read the website: https://support.microsoft.com/en-us/office/import-and-shape-data-in-excel-for-mac-power-query-7b2f337d-e7d2-4fdf-bf00-3dfbb1e5e9c5
But in my mac version of excel, under the data button, there is nothing like Get Data, Choose data source – Get Data (Power Query) , etc. Why my version of office looks so simple?
But in my mac version of excel, under the data button, there is nothing like Get Data, Choose data source – Get Data (Power Query) , etc. Why my version of office looks so simple?
there is no power query either. What happens? I am using a Microsoft 365, it is supposed to be up to date.
- I just joined and choose the beta channel (preview) and then beta channel and updated the excel. Seems nothing changed, the function under data is still very simple. no power query, no Get Data. I am really confused. What could we do? How could we get those functions?
WANGJ20036 All you can do is wait. You will get it at some point. Can't tell when.
This is what MS says about it in the blog post that announced PQ for the Mac:
