Forum Discussion
Why is there no option to import Json into Excel?
(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
- My product is Microsoft Office Standard 2016 Build 16.0.5400.1000 32-bit, Product Id: 00340-93334-98401-AA044.
- When I open the "PQ_IsJsonDocumentAvailable.xlsx", I get the ""You CAN import Json Documents with the in used product"
- Json is not mentioned anywhere on the Data Tab or Ribbon bar commands that are not shown.
- I have a Query Tab in my spreadsheet - but every item is grayed out (so I cannot start a Power Query session in my new or existing Excel files).
- They are enabled in your "PQIsJasonDocumentAvailable.xlsx". How did you enable the Query tab items? The Unhide button on the View tab is grayed out.
- There is no "Get Data" item on my Data tab. This is referenced in the documentation to launch a new query.
- I think I am going to create an application using NewtonSoft and EPPlus. This would probably be quicker and more straightforward.I have a Query Tab in my spreadsheet - but every item is grayed out...They are enabled in your "PQIsJasonDocumentAvailable.xlsx". How did you enable the Query tab items?
Not sure at all as I don't see what you see but your Query tab (and its options) is probably only available (not grayed out) when at least one query exist in your workbook. The fact that the Query tab is active with the file I shared seems to confirm this assumptionLooking at the initial picture you posted, in the Data tab there's a New Query option:
If you natigate in the sub-options you should find something like Blank Query. If you find this select that option and the Power Query Editor will be lauched to create a new query from scratch
From there I can get your started...
Lorenzo There is nothing like "Blank Query" under New Query.
I have tried the "From Text" item. But this launches the CSV text import wizard.
I also tried the "From Web" item in the "From Other Sources". When I specify the Json file instead of a URL, it opens the Json file in Visual Studio.
- The version of Excel 2016 that I am using is stamped with Office 365. On my Account page it tells me "Product Activated Microsoft Office Standard 2016"
