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 |
Write a code for xml attribute and element.
Why do xml namespaces start with http?
What is xml feed?
What does it mean to subscribe to a blog?
What is xml coding?
What is binding (XML)?
What is an xml file for video?
what is the diff. between DOM and SAX ?
How is xml used?
What is the difference between versions 1.0 and 1.1 of the xml namspaces recommendation?
What is xsi type?
what is the XML? what is the difference between XML AND HTML? How it is used in .Net and advantages?