Excel: import xml file
If you want to import an XML file into Excel, you can choose from several functions. We will show you how to open the file correctly.
Import XML file into Excel
- Click on "File" above and select the "Open" option. The XML file can be opened here like any other file.
- There are now several options for editing the XML file. Decide here between "As XML table" and "Use XML source task area".
- If you select "As XML table", you can edit the data in the XML file as in a normal Excel table.
- The "Use XML source task area" option opens a small window on the right-hand side. Drag all the desired attributes into the Excel table and then click on the "Update all" button at the top. The associated data is now loaded.