Windows 7 Forums is the largest help and support community, providing friendly help and advice for Microsoft Windows 7 Computers such as Dell, HP, Acer, Asus or a custom build. How do I open.json files.
You can create a dynamic connection between an Excel workbook and a JSON file, then refresh the connection whenever the JSON data changes.
Newer versionsOffice 2010 – 2013
Use Excel's Get & Transform (Power Query) experience to connect to a JSON file.
- Click the Data tab, then Get Data > From File > From JSON.
- Browse to your JSON file location, select it, and click Open.
- Once the Query Editor has loaded your data, click Convert > Into Table, then Close & Load.
You can also use the Query Editor to create formulas to connect to JSON files. If you don't see the Get Data button, you can go to New Query > From Other Sources > Blank Query, then go to Advanced Editor and input your custom query string.
![Open json file java Open json file java](/uploads/1/2/5/5/125542144/784619145.png)
let
Source = Json.Document(File.Contents('C:UsersNameDesktopJSONTest.json')), #'Converted to Table' = Record.ToTable(Source)
in
#'Converted to Table'
You can also use the Query Editor to create formulas to connect to JSON files. In the Power Query ribbon tab, click From Other Sources > Blank Query, then go to Advanced Editor and input your custom query string.
let
Source = Json.Document(File.Contents('C:UsersNameDesktopJSONTest.json')), #'Converted to Table' = Record.ToTable(Source)
in
#'Converted to Table'
Need more help?
You can always ask an expert in the Excel Tech Community, get support in the Answers community, or suggest a new feature or improvement on Excel User Voice.