Using XML : We can now store data as XML and easily re-purpose the data : Excel 2003 : Basics
What is XML? Is it like HTML? XML stands for Extensible markup language. If you've ever looked at the "View Source" view of a webpage in Notepad, you are familiar with the structure of XML. While HTML allows for certain tags, like TABLE, BODY, TR, TD, XML allows for any tags. You can make up any sort of a tag to describe your data. Here is a screenshot of some XML data that I typed into notepad: http://www.mrexcel.com/articles/using-xml-in-excel.php