I have a GML file, please find it attached. I was wondering if there is an automated way in Excel to parse the data in the file. So all I need from the GML file is the Source and Destination data. I would like to create two columns in an Excel, one that says Source and once that says Destination. I would like to insert the source and destination data from the GML file into those respective columns in the Excel file. But I have to be sure that they match what is the GML file.
Does anybody know of an automated way to do this, as I am sure there is one.