Home

Missing JSON option at Data > New query > From File

%3CLINGO-SUB%20id%3D%22lingo-sub-314660%22%20slang%3D%22en-US%22%3ERe%3A%20Missing%20JSON%20option%20at%20Data%20%26gt%3B%20New%20query%20%26gt%3B%20From%20File%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-314660%22%20slang%3D%22en-US%22%3E%3CP%3EThank%20you!!%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThat%20worked%20for%20me%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-131154%22%20slang%3D%22en-US%22%3ERe%3A%20Missing%20JSON%20option%20at%20Data%20%26gt%3B%20New%20query%20%26gt%3B%20From%20File%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-131154%22%20slang%3D%22en-US%22%3E%3CP%3EThere%20is%20an%20easy%20workaround.%20Go%20to%20Data%20Tab%20on%20Ribbon%20and%20follow%20these%20steps%3A%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E1.%20New%20Query%20-%26gt%3B%20From%20Other%20Sources%20-%26gt%3B%20From%20Web%3B%3C%2FP%3E%0A%3CP%3E2.%20Type%20in%20(or%20Copy-Paste)%20an%20url%20to%20you%20Json%20data%20and%20hit%20OK%20button%3B%3C%2FP%3E%0A%3CP%3E3.%20After%20Query%20Edit%20opens%2C%20right-click%20a%20document%20icon%20on%20a%20query%20dashboard%20and%20select%20JSON%20and%20your%20data%20is%20transformed%20to%20a%20table%20data%20format.%3C%2FP%3E%0A%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20style%3D%22width%3A%20999px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F24690i26166C5379D0FA98%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20alt%3D%22Step-1.png%22%20title%3D%22Step-1.png%22%20%2F%3E%3CSPAN%20class%3D%22lia-inline-image-caption%22%20onclick%3D%22event.preventDefault()%3B%22%3EStep%201.%3C%2FSPAN%3E%3C%2FSPAN%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20style%3D%22width%3A%20701px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F24691iA8557C8FC94AEE53%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20alt%3D%22Step-2.png%22%20title%3D%22Step-2.png%22%20%2F%3E%3CSPAN%20class%3D%22lia-inline-image-caption%22%20onclick%3D%22event.preventDefault()%3B%22%3EStep%202.%3C%2FSPAN%3E%3C%2FSPAN%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20style%3D%22width%3A%20999px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F24692i769D20701B3B8FDD%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20alt%3D%22Step-3.png%22%20title%3D%22Step-3.png%22%20%2F%3E%3CSPAN%20class%3D%22lia-inline-image-caption%22%20onclick%3D%22event.preventDefault()%3B%22%3EStep%203.%3C%2FSPAN%3E%3C%2FSPAN%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20style%3D%22width%3A%20999px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F24693iED14E6C41CE8E350%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20alt%3D%22Result.png%22%20title%3D%22Result.png%22%20%2F%3E%3CSPAN%20class%3D%22lia-inline-image-caption%22%20onclick%3D%22event.preventDefault()%3B%22%3EResult.%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%3EEnjoy!%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-79032%22%20slang%3D%22en-US%22%3ERe%3A%20Missing%20JSON%20option%20at%20Data%20%26gt%3B%20New%20query%20%26gt%3B%20From%20File%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-79032%22%20slang%3D%22en-US%22%3E%3CP%3EI%20don't%20have%20an%20Office%20365%20suscription.%3C%2FP%3E%3CP%3EI%20used%20%22From%20Text%22%20intead%20of%20%22From%20JSON%22.%26nbsp%3BThen%20select%20All%20filetypes%2C%20and%20you%20can%20open%20de%20JSON%20file.%20Hope%20it%20works%20for%20you%20too.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ERegards%2C%3C%2FP%3E%3CP%3EFabi%C3%A1n%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-70073%22%20slang%3D%22en-US%22%3ERe%3A%20Missing%20JSON%20option%20at%20Data%20%26gt%3B%20New%20query%20%26gt%3B%20From%20File%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-70073%22%20slang%3D%22en-US%22%3EThanks%20to%20you%20both.%20It%20certainly%20looks%20as%20if%20this%20is%20a%20'new'%20feature%20only%20available%20to%20O365%20customers%2C%20although%20I've%20been%20unable%20to%20find%20any%20reference%20to%20it%20in%20the%20monthly%20changelogs%20for%20XL2016.%20It%20seems%20to%20have%20been%20around%20for%20a%20long%20time%20(since%20last%20October%20at%20least).%20This%20isn't%20the%20first%20time%20I've%20been%20caught%20out%20by%20this%20discrimination%20between%20'buyers'%20and%20'subscribers'.%20The%20last%20time%2C%20though%2C%20was%20when%20I%20enquired%20about%20the%20black%20theme.%20Same%20story%3A%20O365%20only.%20Nevertheless%2C%20I%20seem%20to%20have%20been%20able%20to%20apply%20it%20to%20my%20'bought%20and%20paid%20for'%20installation%3A%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-69847%22%20slang%3D%22en-US%22%3ERe%3A%20Missing%20JSON%20option%20at%20Data%20%26gt%3B%20New%20query%20%26gt%3B%20From%20File%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-69847%22%20slang%3D%22en-US%22%3E%3CP%3ESergi%20is%20correct.%20%22New%20features%22%20like%20that%20are%20only%20added%20to%20Office%20365%20subscriptions.%26nbsp%3B%20One-time%20payment%20licenses%20like%20yours%20only%20have%20the%20features%20that%20were%20included%20when%20they%20were%20released%20in%20Sept%202015.%26nbsp%3B%20Eventually%2C%20when%20ever%20MS%20gets%20around%20to%20releasing%20a%20new%20version%2C%20those%20missing%20features%20will%20probably%20be%20incorporated%20then.%26nbsp%3B%20In%20other%20words%2C%20because%20you%20chose%20not%20to%20constantly%20pay%20for%20a%20subscription%20MS%20has%20decided%20you%20are%20a%20%22second%20class%22%20customer.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-69758%22%20slang%3D%22en-US%22%3ERe%3A%20Missing%20JSON%20option%20at%20Data%20%26gt%3B%20New%20query%20%26gt%3B%20From%20File%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-69758%22%20slang%3D%22en-US%22%3E%3CP%3EHi%20Noel%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20could%20be%20wrong%20but%20JSON%20data%20source%20was%20added%20not%20a%20long%20ago.%20If%20except%20insiders%20all%20new%20functionality%20goes%20first%20to%20O365%20subscribers%2C%20and%20one%20day%20in%20future%20to%20other%20users.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EIf%20so%20i%20don't%20think%20you%20may%20add%20this%20data%20connector%20to%20menu%20by%20changing%20any%20settings.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-69747%22%20slang%3D%22en-US%22%3EMissing%20JSON%20option%20at%20Data%20%26gt%3B%20New%20query%20%26gt%3B%20From%20File%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-69747%22%20slang%3D%22en-US%22%3E%3CP%3EThere%20is%20allegedly%20an%20%3CA%20title%3D%22Import%20JSON%20Data%20Into%20Excel%202016%20Using%20a%20Get%20%26amp%3B%20Transform%20Query%22%20href%3D%22https%3A%2F%2Fwww.youtube.com%2Fwatch%3Fv%3DCjnsX81qWUg%22%20target%3D%22_blank%22%20rel%3D%22nofollow%20noopener%20noreferrer%20noopener%20noreferrer%22%3Eoption%20to%20import%20JSON%20data%3C%2FA%3E%20in%20XL%202016%2C%20but%20the%20option%20is%20missing%20in%20my%20copy.%20It%20isn't%20there%20in%20%3CEM%3ECustomize%20the%20ribbon%3C%2FEM%3E%2C%20so%20it%20can't%20be%20added%20from%20there%2C%20either.%20Any%20ideas%20where%20it%20got%20to%3F%3CBR%20%2F%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-left%22%20style%3D%22width%3A%20720px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F14538i50A9524CAB672BF6%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20alt%3D%22XL2016-JSON-option-missing.png%22%20title%3D%22XL2016-JSON-option-missing.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-69747%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EBI%20%26amp%3B%20Data%20Analytics%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3ENeed%20Help%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
Noel Burgess
Contributor

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?
 

XL2016-JSON-option-missing.png

6 Replies

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.

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.

Thanks to you both. It certainly looks as if this is a 'new' feature only available to O365 customers, although I've been unable to find any reference to it in the monthly changelogs for XL2016. It seems to have been around for a long time (since last October at least). This isn't the first time I've been caught out by this discrimination between 'buyers' and 'subscribers'. The last time, though, was when I enquired about the black theme. Same story: O365 only. Nevertheless, I seem to have been able to apply it to my 'bought and paid for' installation:

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

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.pngStep 1.Step-2.pngStep 2.Step-3.pngStep 3.Result.pngResult.

Enjoy!

 

 

Thank you!!

 

That worked for me

Related Conversations
Tabs and Dark Mode
cjc2112 in Discussions on
22 Replies
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies
flashing a white screen while open new tab
cntvertex in Discussions on
13 Replies
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
28 Replies
IIS extension is not working - WAC 1909
HotCakeX in Windows Admin Center on
11 Replies