how do i get .json capability in w/ ms products to convert to excel

To open and convert a .json file to Excel using Microsoft products, use Power Query in Excel.

For a single JSON file:

1. In Excel, go to the Data tab.
2. Select Get Data > From File > From JSON.
3. In the Import Data dialog, browse to the .json file and select Open.
4. The data loads into Power Query. Use the Expand icons in the columns to drill into records/lists until the data is in tabular form.
5. When ready, select Close & Load to load the data into a worksheet.

If using the newer Get Data (Power Query) experience:

1. Go to Data > Get Data (Power Query).
2. In Choose data source, select JSON.
3. Select Browse, choose the .json file, then Get Data and Next.
4. In the preview, shape the data as needed, then select Close & Load.

If the JSON is stored as multiple files in a folder:

1. Go to Data > Get Data > From File > From Folder.
2. Select the folder containing the JSON files.
3. Choose Combine > Combine & Transform.
4. In Power Query, expand the Value column to new rows, then expand records to columns.
5. Remove unwanted columns and select Close & Load.

If Excel shows an error that it “can’t connect” to the JSON file, the file may be malformed or in JSON Lines format. In that case, it must be converted to a standard JSON structure before import.

Once loaded, the JSON data is available as a normal Excel table for analysis, formulas, charts, etc.

References:

• Import data from data sources (Power Query)
• JSON
• Import data from a folder with multiple files (Power Query)