How do I view an xml file in excel?



How do I view an xml file in excel?..

Answer / Saurabh Gangwar

To view an XML file in Excel, you can import the XML data as a table using the 'From Other Sources' option in the Data tab. After selecting the XML file, choose 'From XML' and map the XML elements to the corresponding Excel columns. Once the data is imported, you can manipulate it like any other Excel data.

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More XML XSLT RSS Interview Questions

Write a code for xml attribute and element.

1 Answers  


Why do xml namespaces start with http?

1 Answers  


What is xml feed?

1 Answers  


What does it mean to subscribe to a blog?

1 Answers  


What is xml coding?

1 Answers  


What is binding (XML)?

1 Answers  


What is an xml file for video?

1 Answers  


what is the diff. between DOM and SAX ?

2 Answers  


How is xml used?

1 Answers  


What is the difference between versions 1.0 and 1.1 of the xml namspaces recommendation?

1 Answers  


What is xsi type?

1 Answers  


what is the XML? what is the difference between XML AND HTML? How it is used in .Net and advantages?

3 Answers   ADP,


Categories