Forum Discussion
Why is there no option to import Json into Excel?
I am using Microsoft Excel 2016. (16.0.5400.1000). My Data Ribbon has no options to open a Json file. Much of the documentation for 2016 looks nothing like my Data Ribbon. There is ...
(I don't run 2016). Please download the attached file and Refresh the query as documented
If you get "You CAN import Json Documents with the in used product" I can help to get you started assuming you can share 2016 screenshots
If you get "You CANNOT import Json Documents with the in used product" this means PQ function https://learn.microsoft.com/en-us/powerquery-m/json-document isn't available in your product :-(( in which case you will have to look for alternatives