Conversion Of XML Data File To A Spreadsheet

Asked By jkbenson 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?

• Status: Open
• Question Views: 336
• Answer Count: 1
• Vote Up 0 Vote Down

• Answer Accepted: No
• Question Category: File Servers

Answered By loann eille 20 points N/A #162776

Conversion Of XML Data File To A Spreadsheet

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.

About loann eille

Questions
12

Answers
16

Best Answers
0

• Vote Up 0 Vote Down

• Posted on - 07/23/2016
• Question Category: File Servers