Export Excel File to an XML Data File

In this article you will learn how to import an Excel file from an XML file or export an Excel file to an XML file.

XML is a markup language designed to transport and store data and Excel is a spreadsheet in which you can create tables and calculate and analyze data. XML and Excel are totally different, but you can convert some XML data to an Excel file or Excel file to an XML file. Look at the following procedure.

Convert File

Use the following procedure to convert an Excel file to an XML file:

  • Look at the following Excel data:

    excel data sheet
     
  • First, turn on the developer tab in Excel, right-click on the menu bar and select "customize the ribbon".

    customize the ribbon option in excel
     
  • Select "Developer" and click "OK".

    add developer tool in excel
     
  • Finally a new tool (Developer) is added to your menu bar. Now open Notepad and add the following lines:


     
    Note: tags are referred to as column names.
     
  • Save the file as format.xml.
     
  • Open the Excel file, go to the developer tab and click on Source:

    source task panel in excel
     
  •  Click XML Maps:

    add xml map in excel
     
  • Click add, select file "format.xml" and then click add:

    add xml map
     
  • Now you can see drag (map) the 3 elements from the tree onto the worksheet (row 1).

    data set map in excel sheet
     
  • Now, on the developer tab, click "Export":

    export excel data
     
  • Save your file as myfile.xml and the open. See the result:

      XML