Viewing Results in Excel
- Open Microsoft Excel.
- Open a new document and browse to the XML file.
- When prompted, select to open As an XML table:
- If prompted with a schema warning, click OK:
- The results will be displayed in Microsoft Excel where you can remove columns and sort as required: