Can excel read xml?



Can excel read xml?..

Answer / Jagrit Kashyap

Yes, Excel can read XML files by importing them. To do this, you can go to 'File' -> 'Open' -> select the XML file -> choose 'Microsoft Excel Macro-Enabled Workbook (XML)' from the file type dropdown list -> and click on 'Open'. Once imported, you will have an Excel worksheet with the data from your XML file.

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More XML XSLT RSS Interview Questions

What is url what is the use of it?

1 Answers  


What is xslt used for?

1 Answers  


Whether root element is required for XML? If so, how many root elements are required?

1 Answers  


Define element and attribute in an xml document.

1 Answers  


If I replace my Sqlserver with XML files and how about handling the same ?

1 Answers   HCL,


How do I use graphics in xml?

1 Answers  


Is xml relational?

1 Answers  


What is the usage of xslt <xsl: if> element?

1 Answers  


How do I import an xml file into excel?

1 Answers  


In both cases Schema is same xml files are different when u opt xmlTextReader and when you opt Xml Document?

1 Answers   Honeywell,


What is an rss feed link?

1 Answers  


Write a program to use the stylesheet element?

1 Answers  


Categories