[XML-DEV Mailing List Archive Home] [By Thread] [By Date] [Recent Entries] [Reply To This Message]

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

• From: Roger L Costello <costello@mitre.org>
• To: "xml-dev@lists.xml.org" <xml-dev@lists.xml.org>
• Date: Thu, 4 Aug 2022 14:59:08 +0000

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

• Follow-Ups:
  • Re: Is there a tool that converts a plain vanilla XMLdocument into an Excel document?
    • From: Stephen D Green <stephengreenubl@gmail.com>
  • Re: Is there a tool that converts a plain vanilla XMLdocument into an Excel document?
    • From: Peter Flynn <peter@silmaril.ie>
  • RE: Is there a tool that converts a plain vanilla XML document intoan Excel document?
    • From: Roger L Costello <costello@mitre.org>
  • Re: Is there a tool that converts a plain vanilla XMLdocument into an Excel document?
    • From: William David Velasquez <wd@creativosdigitales.co>