Most Valuable Professional

View Jan Karel Pieterse's profile on LinkedIn subscribe to rss feed
Subscribe in a reader

Subscribe to our mailing list

* indicates required

File crashes Excel!!

Save my workbook!
The best tool for salvaging problematic workbooks.


Excel VBA Masterclass (English)
Excel VBA for Financials (Dutch)

Third party tools

Speed up your file

The best tool to optimise your Excel model!

What has changed?

PerfectXL Compare, for Spreadsheet Comparison
This Excel compare tool is fast, reliable, and easy to use. Compare two Excel files now and see for yourself!
Home > English site > Articles > XML and Excel
Deze pagina in het Nederlands

XML and Excel


This article has been previously published in the Dutch Microsoft Office Magazine no 27, 2006.

Microsoft Office 2003 Professional was the first Office version that took the XML standard seriously. The XML standard has been devised to ease the markup of data (especially on the web). A well known example of the use of XML are RSS feeds with which one can gather news from web pages. In reality, these so-called RSS-feeds are nothing less than XML files. This article introduces XML and shows some things that can be done with it (specifically in Excel).

Note : In this article techniques are used which are only available in all Excel 2007-2013 versions and in the "stand-alone" version of Excel 2003/2007/2010/2013 and in the Professional edition of Office 2003. Other editions of Office 2003, such as the small business version or the Students and teachers version, lack the XML capabilities exhibited in this article.

The sample files from this article may be downloaded here.