Click on the "Data" menu in Excel and choose "XML," then "XML Source" to open the "XML Source" task pane. Click on the "XML Maps" button, then click "Add" and choose the XML map file you created ...

For an Excel for Windows workbook that does not open in Excel 2008 for Mac, save the workbook in the XLSB file format from Excel for Windows. You can then open and resave to XLSX, XLTX, XLSM, or ...