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

Audit !!!

Check out our RefTreeAnalyser
the ultimate Excel formula auditing tool.

Trainings

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

Third party tools

Speed up your file

FastExcel
The best tool to optimise your Excel model!

Repair your file

Stellar Phoenix Excel Repair
Best tool to repair corrupt Excel sheets and objects
Home > English site > Articles > XML and Excel
Deze pagina in het Nederlands

XML and Excel

Introduction

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.

Contents