Is there a tool that converts a plain vanilla XML document into anExcel

[Roger L Costello <costello@mitre.org>]

Hi Folks,

I have a plain, vanilla XML document with a root element that contains a bunch of <row> elements and each <row> element contains fields, e.g.,

<document>
    <row>
        <field1>ABC</field1>
        <field2>DEF</field2>
        <field3>GHI</field3>
    </row>
    ...
</document>

To display that XML document in Excel requires a bunch of steps:

1. Click on the Developer tab
2. Click on the Source icon
3. Click on the XML Maps button
4. Click on the Add button
5. Navigate to the folder containing the XML document
6. Click on the XML document
7. Click on the OK button
8. Drag "row" over to the Excel cell
9. Click on the Developer tab again
10. Click on Import
11. Select the XML document again

Phew! That's a lot of work to get Excel to display the XML document.

Is there a tool that takes a plain, vanilla XML document and converts it into an Excel document?

/Roger