How to Import XML generated by TFPT into Excel 2007?

Question

Below is the xml content generated by TFPT for the WIQL issued. When I try to import this XML into Excel 2007 XML source pane shows only "Id", "RefName" and "Value" as fields to be mapped. Whereas I would like to display System.Id, System.State, Microsoft.VSTS.Common.ResolvedDate, Microsoft.VSTS.Common.StateChangeDate as column headings and corresponding value as rows. Any idea how to achieve this using XML import in Excel 2007.

<?xml version="1.0" encoding="utf-8"?>
<WorkItems>
  <WorkItem Id="40100">
    <Field RefName="System.Id" Value="40100" />
    <Field RefName="System.State" Value="Closed" />
    <Field RefName="Microsoft.VSTS.Common.ResolvedDate" Value="3/17/2010 9:39:04 PM" />
    <Field RefName="Microsoft.VSTS.Common.StateChangeDate" Value="4/20/2010 9:15:32 PM" />
  </WorkItem>
  <WorkItem Id="44077">
    <Field RefName="System.Id" Value="44077" />
    <Field RefName="System.State" Value="Closed" />
    <Field RefName="Microsoft.VSTS.Common.ResolvedDate" Value="3/1/2010 4:26:47 PM" />
    <Field RefName="Microsoft.VSTS.Common.StateChangeDate" Value="4/20/2010 7:32:12 PM" />
  </WorkItem>
</WorkItems>

Thanks