Many people don’t know how to import XML files into excel tables? Today’s article brought to you is a tutorial on importing XML files into excel tables. If you still don’t know, let’s learn about it with the editor.

Create a new Excel workbook, click [Data] - [From other sources] - [Import from XML data] in the upper menu bar.

A dialog box will pop up, select the prepared XML file,

​​Import the file, a pop-up window will pop up, click OK,

​​The import data window will appear, click OK again.

As shown in the picture, we have successfully imported the XML file into the Excel table.

The above is the tutorial for importing XML from excel table to share with you.All the content, interested friends, please come and watch it!