Howto: convert a Excel workbook to an xml file

This post is a bit off topic for this blog but I’ll post it anyway as a reminder for myself and hopefully to help others who want to do the same. At a client someone had to convert a very simple, plain, flat text excel 2007 workbook to an xml file format.

I have made an example to let you see how to do this. Below you see the workbook that has to be converted to xml.

exc_workbook1

I thought that just saving the file with “save as” to xml format would do it but I thought wrong. I got an error that there were no XML mappings found in the workbook. For Excel 2007 you need a add-in that is called OfficeExcel2003XMLToolsAddin.exe and which can be downloaded here. On the download page you can also read how to install and open the add-in in Excel 2007.

After you have installed the add-in and you click the Add-Ins menu the “XML tools” menu have to added (see below).

exc_xmltools

Now click on the XML tools drop down and choose the first option “Convert a Range to an XML List”. In the little window that appears you have to fill in the range of cells you want to convert and indicate that the first row contains the column headers (see below).

exc_range

Click OK and the workbook will be converted (see below)

exc_converted

When you open the Developer menu and click “Source” you have to see the “XML maps in this workbook” on the right of the screen (see below). Now the workbook is ready to be converted to an XML file.

exc_xmlmap

To convert this workbook you have to click “Export” on the Developer menu. Choose a filename to save the xml file.  The result will look like:

exc_example

There are 16 comments for this article
  1. Pingback: Tweets die vermelden Howto: convert a Excel workbook to an xml file -- Topsy.com
  2. cna training at 5:11 AM

    Great information! I’ve been looking for something like this for a while now. Thanks!

  3. Pingback: convert a Excel workbook to an xml file « Online Learning Stations
  4. Raj at 10:43 PM

    Great information and it helped me a lots. Thanks

  5. Diane at 5:24 PM

    This took a frustrating issue and made it simple to understand. Thanks ever so much :-)

Leave a Reply

Your email address will not be published. Required fields are marked *

You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code class="" title="" data-url=""> <del datetime=""> <em> <i> <q cite=""> <strike> <strong> <pre class="" title="" data-url=""> <span class="" title="" data-url="">