Click the Office button, click Open
Click the Files of type list arrow, click XML Files,
select the XML data file, click Open
Click the As an XML table,
As a read-only workbook, or Use The XML Source task pane option, and then click OK.