I have an XML file that i want to be to able to import into Excel 2007, however i only want to select some of the data in the XML file to be imported. Initially if i could work out how to do this manually, and then come up with some automated process for a bunch of XML files. I have a sample XML file here https://www.dropbox.com/s/oa3dop5636245q2/test.xml and the only data we need to extract is ContractOrderReference BuyersOrderNumber LineNumber SuppliersProductCode Description Amount UnitPrice preferably all on one row of the excel file. so is this possible? and is this an efficient way of doing it ?