A hierarchical XML data structure can be converted to a spreadsheet data structure of a book, sheets, rows and columns. In a conversion implemented by an xml tool, the root or an arbitrary element is mapped to the book. Elements with child elements of the same element names or attributes are mapped to rows. The child elements of the row elements are mapped to columns.

http://www.liquid-technologies.com/Tutorials.aspx