Excel® 2013 On Demand

Working with XML

XML (Extensible Markup Language) is a universal language that enables you to create documents in which data is stored independently of the format so you can use the data more seamlessly in other forms. XML is supported in Office 2013 through Word, Excel, and Access. XML allows you to work with the familiar Office interface and create and save documents as XML, without ever knowing the XML language. When you work with XML, you can attach an XML Schema—a set of rules that defines the elements and content used in an XML document. XML schemas are created by developers who understand XML. After you attach a schema, you should change XML map properties before you map schema elements to cells in your worksheet.

Attach a Schema

Click ...