One way to present XML information to a user is by converting it to a file format the user actually knows. Edmond Woychowsky walks you through his process, including all the necessary sample code ...

TinyWow can split an Excel file if you want the XLSX file to end up as multiple files. That same site has an Excel to XML converter, and others that can save the file to PDF or CSV.