Conversion Of XML Data File To A Spreadsheet
Asked By
0 points
N/A
Posted on - 07/23/2016
How can I convert XML data file to Excel spreadsheet? Is it possible online only? Or there is any other way to do it?
How can I convert XML data file to Excel spreadsheet? Is it possible online only? Or there is any other way to do it?
You can do it by importing the data of XML file into your Excel spreadsheet.
For this, follow the steps-
• Open the Excel spreadsheet.
• On the menu bar, select Data.
• Select from other sources->From XML Data Import.
• The internal structure of the XML document would be used for the division of data into rows and columns.
• Select ‘in existing worksheet’ in the Import Data dialog box.
• Click File->Save As.
• In the ‘Save as Type’ dialog box, select .XLS.