Forum Discussion
Missing JSON option at Data > New query > From File
There is allegedly an option to import JSON data in XL 2016, but the option is missing in my copy. It isn't there in Customize the ribbon, so it can't be added from there, either. Any ideas where it ...
There is an easy workaround. Go to Data Tab on Ribbon and follow these steps:
1. New Query -> From Other Sources -> From Web;
2. Type in (or Copy-Paste) an url to you Json data and hit OK button;
3. After Query Edit opens, right-click a document icon on a query dashboard and select JSON and your data is transformed to a table data format.
Step 1.Step 2.Step 3.Result.
Enjoy!
