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

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.