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 ...
I don't have an Office 365 suscription.
I used "From Text" intead of "From JSON". Then select All filetypes, and you can open de JSON file. Hope it works for you too.
Regards,
Fabián
Thank you!!
That worked for me
