May 13 2017
12:31 PM
- last edited on
Jul 12 2019
10:45 AM
by
TechCommunityAP
May 13 2017
12:31 PM
- last edited on
Jul 12 2019
10:45 AM
by
TechCommunityAP
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 got to?
May 13 2017 02:17 PM
Hi Noel,
I could be wrong but JSON data source was added not a long ago. If except insiders all new functionality goes first to O365 subscribers, and one day in future to other users.
If so i don't think you may add this data connector to menu by changing any settings.
May 14 2017 09:01 PM
Sergi is correct. "New features" like that are only added to Office 365 subscriptions. One-time payment licenses like yours only have the features that were included when they were released in Sept 2015. Eventually, when ever MS gets around to releasing a new version, those missing features will probably be incorporated then. In other words, because you chose not to constantly pay for a subscription MS has decided you are a "second class" customer.
May 15 2017 01:36 PM
Jun 19 2017 05:53 PM
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
Nov 24 2017 01:22 PM
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.
Enjoy!
Jan 14 2019 08:34 AM
Thank you!!
That worked for me
Oct 22 2019 07:25 AM
@Good Boy What about Office for MacOS? I'm trying to query a REST service but I can't format de data.
Jan 22 2020 11:28 AM
@Good Boy What version are you using here. The Excel 2016 we are using doesnt work that way with JSON input. We have Microsoft Office Standard 2016. Thanks