Conversion Of XML Data File To A Spreadsheet

Asked By 0 points N/A Posted on -
qa-featured

How can I convert XML data file to Excel spreadsheet? Is it possible online only? Or there is any other way to do it?

SHARE
Answered By 20 points N/A #162776

Conversion Of XML Data File To A Spreadsheet

qa-featured

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.

Related Questions