View xml files in excel 2010

Please log in with your username or email to continue. No account yet? Create an account. Edit this Article. We use cookies to make wikiHow great. By using our site, you agree to our cookie policy. Cookie Settings. Learn why people trust wikiHow. Download Article Explore this Article methods. Related Articles. Article Summary. Method 1. Open Microsoft Excel. Click Open.

This opens the file browser. Double-click the XML file. Depending on the format of the file, you may have to take additional steps to open this file: If you see a dialog box called Import XML, the file references at least one XSLT style sheet.

Select Open the file without applying a style sheet to select the standard format, or Open the file with the style sheet applied to format the data in accordance with the style sheet. Click the File menu. Click Save As…. How to view the XML form of an Excel file? Ask Question. Asked 9 years, 11 months ago. Active 5 months ago. Viewed 56k times. Improve this question. TylerH Allan Chua Allan Chua 6, 8 8 gold badges 37 37 silver badges 58 58 bronze badges. Add a comment.

Active Oldest Votes. Improve this answer. The following procedure worked for me: Change the extension of the file from. You do not have to install any special zip utilities to open and close files in Office.

Improved damaged-file recovery Files are structured in a modular fashion that keeps different data components in the file separate from each other.

This allows files to be opened even if a component within the file for example, a chart or table is damaged or corrupted. Support for advanced features Many of the advanced features of Microsoft require the document to be stored in the Open XML format.

Better privacy and more control over personal information Documents can be shared confidentially, because personally identifiable information and business-sensitive information, such as author names, comments, tracked changes, and file paths can be easily identified and removed by using Document Inspector.

Better integration and interoperability of business data Using Open XML Formats as the data interoperability framework for the Office set of products means that documents, worksheets, presentations, and forms can be saved in an XML file format that is freely available for anyone to use and to license, royalty free.

This means that customers can easily unlock information in existing systems and act upon it in familiar Office programs. Information that is created within Office can be easily used by other business applications. Easier detection of documents that contain macros Files that are saved by using the default "x" suffix such as. Only files whose file name extension ends with an "m" such as. Before you decide to save the file in a binary format, read Can different versions of Office share the same files?

By default, documents, worksheets, and presentations that you create in Office are saved in XML format with file name extensions that add an "x" or an "m" to the file name extensions that you are already familiar with. For example, when you save a document in Word, the file now uses the. When you save a file as a template, you see the same kind of change. The template extension used in earlier versions is there, but it now has an "x" or an "m" on the end.

If the file contains code or macros, you must save it by using the new macro-enabled XML file format, which adds an "m" for macro to the file extension. Office lets you save files in the Open XML Formats and in the binary file format of earlier versions of Office and includes compatibility checkers and file converters to allow file-sharing between different versions of Office.