How to open XML files in Excel?

Using XML file on Excel, and working further on it is quite simple. We are going to use Microsoft Excel to use XML, but first you need an XML file.

Xml file

This would look like this, in assumption that you use Notepad to create it:

xml file

Important note: you must save this file in an xml format.

Hom to open XML file?

Open Microsoft Excel, and press Open on top.

ribbon open

Browse to the XML file, and click on the arrow under or side of "file name", and choose XML files.

choose xml

Choose the XML file.


Click on the open as XML table, and press Ok.

open xml as table

Just click Ok. If the XML data is not properly formatted, Excel will prompt you to import the data using the XML Import Wizard. Follow the steps in the wizard to import the data into an Excel worksheet.

warning ok

Click on the last cell in the table, and press TAB on your keyboard.

last cell press tab

Keep filling the XML table with details.

fill table

If the XML file contains properly formatted data, Excel will open the file and display the data in the worksheet without using the XML Import Wizard. If the XML data is not properly formatted, you may need to use an XML editor to modify the data before importing it into Excel.

In conclusion, only use the tab button on your keyboard at the last cell of the row. Everything you input must be in the XML table. You should always save it as XML if you wish to keep the format, otherwise Excel would save it as Excel worksheet.

Further reading: 
SQL Server
How to use SQL in Excel Exponents How to use .XSD file in Excel to create data XML files?