I am using a tool called GPMC to extract Group Policy Objects from the active directory set up at my client.
I can save this information to either an HTML file or an XML file. I have about 37 files that are pretty detailed right now.
What I was hoping to do was either scrap the information from the HTML file or access it from the XML file and put it into a coherent format in Excel where I can document line by line the policy file name, who it acts on, the locaton, the settings and so forth. In some cases the XML data is 3 levels deep, and in some it goes down to 7 levels. Any ideas how to put the data into a usable format in Excel?