Need Help Converting a JSON file to new format

[trevor2524]

Hello,

Need a little help as I have about 90 Json files i need to extract information from to a new format. On the example is a portion of a sample Json file that I am using. The expected outcome page is how the information should look after the reformat. On the Json file the only information I'm looking to grab is the Name, Value and the Machines associated with those two values. If no machines are listed, it would just be blank as row 1 on the expected outcome sheet shows. Any help is greatly appreciated.Json Example.xlsx

[Paul_Hossler]

You have ~90 JSON files

Q1. In same folder?
Q2. Do you want to do all of them at once?
Q3. Where do you want the 'filtered' data to go: into a new sheet in each workbook? On a 'master' list with all ~90 results on one sheet?

[Aussiebear]

Have you had a look here. https://www.gigasheet.com/post/import-json-to-excel