See XML::Twig for reading the XML and Spreadsheet::WriteExcel for writing to XLS. Just take any of your data and write it that way for illustration. This is not a code writing service.