Forum Discussion

Copper Contributor

Jun 19, 2023

Why is there no option to import Json into Excel?

I am using Microsoft Excel 2016. (16.0.5400.1000). My Data Ribbon has no options to open a Json file. Much of the documentation for 2016 looks nothing like my Data Ribbon. There is ...

excel

Detlef_Lewin

Silver Contributor

Jun 19, 2023

Martin Kimzey

I put your question to the Bing chatbot. Here is its answer:

There is an option to import JSON data into Excel 2016. You can do this by opening Excel and going to the `Data` tab. From there, navigate to `Get Data > From File > From JSON`. You can then select how you want your data to be imported and Excel will handle the rest automatically ¹. Is there anything else you would like to know?

Quelle: Unterhaltung mit Bing, 19.6.2023(1) Import JSON Data in Excel 2016 or 2019 or Office 365 using a Get .... https://syntaxbytetutorials.com/import-json-data-in-excel-2016-or-2019-or-office-365-using-a-get-transform-query/ Zugegriffen 19.6.2023.
(2) Can't import JSON in Excel 2016 using "Get & Transform" feature. https://superuser.com/questions/1267768/cant-import-json-in-excel-2016-using-get-transform-feature Zugegriffen 19.6.2023.
(3) How to Convert a JSON File to Microsoft Excel - How-To Geek. https://www.howtogeek.com/775651/how-to-convert-a-json-file-to-microsoft-excel/ Zugegriffen 19.6.2023.
(4) How to Convert JSON to Excel Using Power Query. https://excelunlocked.com/convert-json-to-excel Zugegriffen 19.6.2023.

Martin Kimzey

Copper Contributor

Jun 21, 2023

- If you look at the Data ribbon in the original post, there is no "Get Data" button at all on the tab.

- There is no "Get Data". There is no "From File". There is no "From JSON".

- Additionally, there are no options in Customize Ribbon to add "Get Data" or anything Json related to Excel 2016 (Build 16.0.5400.1000).

- The links cited above do not match this version of Excel 2016.

-There is nothing Json related under the "From Other Sources".

- If I try the "From Web" approach - Excel launches Visual Studio and opens the Json file as a large text string.

- If I try to use "From Text" if launches the Text Import Wizard which does not recognize a Json File.

- The documentation for the Data tab above does not match my version of Excel 2016.

AI Bots are only as good as the information they are working with. If this documentation is wrong, the answer with be wrong.

Detlef_Lewin
Silver Contributor
Jun 21, 2023
Martin Kimzey
I'm sorry that the tips weren't helpful.
From what I read the workarounds should have worked.
I can't check it myself because I use Office 365.
I guess you have to wait for someone who still uses Excel 2016.