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" function according to some discussion in the forum. But there is no such "new query" there. Please refer to the photo attached. Any suggestion? Thanks.
Jeff
6 Replies
JSON is available to SOME beta testers. The number of beta testers included in the test is likely to grow with each week's update, so make sure you are set up to get the weekly beta channel update.
- 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?- there is no power query either. What happens? I am using a Microsoft 365, it is supposed to be up to date.
