Wednesday, July 18, 2012

How to Convert XML Files Into an Excel Spreadsheet


1. Open Excel.
2. Click the Microsoft Office symbol in the upper left-hand corner. Select 'Open' from the menu.
3. Find the XML document you want to convert and click 'Open.' If the document does not seem to be present where it should be, you may need to select 'XML Files(*.xml)' from the 'Files of type:' drop-down box.
4. A small dialog box will open titled 'Open XML.' In this box select the radio button titled 'As an XML table,' then click 'OK.'
5. If another dialog pops up that has a message relating to creating a 'XML schema,' simply click 'OK.' The XML file should be opened as a spreadsheet.
6. To complete the conversion, save the spreadsheet as an Excel file by clicking the 'Office' button, then 'Save.'

Blogger news