Forum Discussion
Why is there no option to import Json into Excel?
- 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 assumption
Looking 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.
Don't try text/csv or anything else like that you waste your time
From your screenshot the Blank Query option is probably in the From Other Sources sub-option
- I have opened the Power Query Editor from the "From Other Sources". I don't see any Json options in the "New Source".
I am looking at the article at https://learn.microsoft.com/en-us/power-query/connectors/json.
Again, this article references a "Get Data" option that does not exist in this version of Power Query.