Google News
logo
XML - Interview Questions
How to convert XML to excel?
Step 1 : Open Microsoft Excel
Step 2 : Click on ‘file’ on the top left corner of MS Excel. If you are using MS Excel version 2007, click on the MS Office logo.
Step 3 : You will land on the ‘open’ tab; if not, select the ‘open’ tab. Click ‘browse’ for the MS Excel version of 2010 and above.
Step 4 : Double click on the XML file you want to export into MS Excel.
Step 5 : Select ‘Open the file without applying a style sheet’ to select the standard format, or ‘Open the file with the stylesheet applied’ to format the data in accordance with the style sheet.
Step 6 : Click on ‘save as’ and select ‘Excel Workbook’ from the drop-down menu.
Step 7 : Save the file!
Advertisement