Home > English site > Articles > XML and Excel

XML and Excel

Introduction

This article has been previously published in the Dutch Microsoft Office Magazine (http://www.msoffice-magazine.nl) 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 versions and in the "stand-alone" version of Excel 2003/2007 and in the Professional edition of Office 2003. Other editions, 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.

XML and Excel

Introduction

Contents