How do I open an xml file in excel?
- 1 Answers
- 946 Views
- I also Faced
- E-Mail Answers
Answer / Ajay Kant Singh
To open an XML file in Excel, you can use Microsoft Office's built-in functionality. First, ensure that the XML file is saved as a 'Text (Tab Delimited)' or 'Text (Comma Delimited)' file. Then, open Excel and click on 'File' -> 'Open', navigate to your file, select it, and click 'Open'. In the Text Import Wizard, choose 'Delimited', next choose the delimiter (typically Tab or Comma), and then click 'Finish'. The XML data will be imported into Excel.
| Is This Answer Correct ? | 0 Yes | 0 No |
How to conduct various xml transformations in java?
What is binding (XML)?
How do I insert an xml file into word?
Are rss feeds still used?
What is the mime type definition for atom files?
What is the difference between xml and xlsx?
How many document types are defined for atom feed files?
What are the different xslt elements?
What is Data Island?
What is soap api?
Why XML editor is needed instead of Notepad?
How do I save as an xml file?
HTML DHTML 
