2005-6-2 Convert Excel to XML file. Convert Excel to XML file/XML Schema, and validate Excel. How we can convert any type of file Like(Txt.,TabSaparated,etc.) in to XML. Some Title Some Description Keyword1,Keyword2,Keyword3,Keyword4 or whatever other format you are looking. How to convert Xml files to Text Files.
Bookmark and share page
Created in a textual data format, XML is a file type that is not only human readable but is also relevant to web services since it is a machine readable language as well. XML is a platform independent language designed to store various data. With features such as simplicity, usability, and generality, the language is as popular as HTML and is widely distributed over the internet. The fact that XML files can be easily edited by using a simple text editor supports the growing popularity of this file type.
Technical details of XML files
An XML document is a series of characters where every Unicode character may be found in each individual document. The standard encoding of a Unicode that makes up a XML document is divided into markup and content on the basis of simple syntactic rules. It has an advantage over the HTML document by allowing custom tagging of objects to distinctly define the data they are holding.
More information about the XML file format
| File extension | .xml |
| File category | Document |
| Example file | Download example.xml file (252.17 KiB) |
| Associated programs | Microsoft Visual Studio 2013 JAPISoft EditiX Wattle XMLwriter MacroMates TextMate |
| Useful links | More information on XML |
| Developer | World Wide Web Consortium |
I have a XSD file and I need to convert that to MS Excel file.The XSD is below.
Pls help me, I really don't know how and where to start.
Eric
4 Answers
This answer is equally for you as well as @Alex, @Michael and @forty-two. I am illustrating it using Excel 2010, so if you're on another version, I'll leave it up to you to make the necessary adjustments.
First thing, make sure the developer tab shows (Click the File tab, Options).
You now have to create an XML source from your XSD: click the Developer tab; in the XML group, toggle Source button to show the Xml Source task pane; then click the XML Maps button.
Click Add button at the prompt; point to the XSD file; then click OK to go back to the main screen.
Then you can drag and drop your shipOrder to a cell in a worksheet, to anchor the generated mapped table.
Next, you may use Import to get your XML data into the spreadsheet, and Export to get it out. There are a couple of additional things to pay attention to; read this article on Microsoft's site; pay particular attention to the issues with exporting XML data (error XML maps in my workbook are not exportable). This is because of the 1 to many cardinality between shiporder and item. You can try to handle it using mapped ranges - I'll leave this all up to you. The best would be for you to read the online help for the XML developer section...
Petru GardeaPetru GardeaGo to MS Excel ->File ->Open. Select the xsd file.
You will be prompted on how you would like to open the file. You can select the option 'As an XML table'. Save the file in excel format.
swiftBoy
You could save the file as an XML file and then open it in Excel and open as a 'Read-only workbook' when prompted. However it won't be in a nice format, but at least all the data (along with the XML paths as columns) will be there.
You can then edit the data as you require. Anything else will require some processing.
XN16XN16Select the whole text of the XSD in a text editor, copy it to the clipboard, click on a cell in an Excel spreadsheet, and do a Paste. Your XSD data will now be in your spreadsheet.
Free Xml Validation Tool
It won't be in a very useful format, but you haven't told us what you want the spreadsheet to look like, and I find it hard to imagine a format that would be useful.
Xml Schema Validation Tool
Michael KayMichael KayXml Parser Online
protected by MaximMar 20 '18 at 22:52
Thank you for your interest in this question. Because it has attracted low-quality or spam answers that had to be removed, posting an answer now requires 10 reputation on this site (the association bonus does not count).
Would you like to answer one of these unanswered questions instead?