You are viewing the article How to Convert XML to Excel at Tnhelearning.edu.vn you can quickly access the necessary information in the table of contents of the article below.
X
This article is co-authored by wikiHow writer, Darlene Antonelli, MA. Darlene Antonelli is the author and editor of wikiHow about technology. Darlene has experience teaching at the university, writing articles related to technology and directly working in the technology field. She earned her master’s degree in writing from Rowan University in 2012 and has written a thesis on online communities and selected personalities in that community.
This article has been viewed 4,468 times.
This wikiHow teaches you how to import XML files into a Microsoft Excel spreadsheet set on Windows or macOS.
Steps
Windows
{“smallUrl”:”https://www.wikihow.com/images_en/thumb/4/4d/Convert-XML-to-Excel-Step-1.jpg/v4-728px-Convert-XML-to-Excel- Step-1.jpg”,”bigUrl”:”https://www.wikihow.com/images/thumb/4/4d/Convert-XML-to-Excel-Step-1.jpg/v4-728px-Convert- XML-to-Excel-Step-1.jpg”,”smallWidth”:460,”smallHeight”:345,”bigWidth”:728,”bigHeight”:546,”licensing”:”<div class=”mw-parser -output”></div>”}
Open Microsoft Excel. You’ll find Excel in the “Microsoft Office” group from the All Apps list of the Windows menu.
{“smallUrl”:”https://www.wikihow.com/images_en/thumb/7/75/Convert-XML-to-Excel-Step-2.jpg/v4-728px-Convert-XML-to-Excel- Step-2.jpg”,”bigUrl”:”https://www.wikihow.com/images/thumb/7/75/Convert-XML-to-Excel-Step-2.jpg/v4-728px-Convert- XML-to-Excel-Step-2.jpg”,”smallWidth”:460,”smallHeight”:348,”bigWidth”:728,”bigHeight”:551,”licensing”:”<div class=”mw-parser -output”></div>”}
Click File in the upper left corner of Excel.
- On Excel 2007, click the round button with the Microsoft Office icon inside. [1] X Research Source
{“smallUrl”:”https://www.wikihow.com/images_en/thumb/a/af/Convert-XML-to-Excel-Step-3.jpg/v4-728px-Convert-XML-to-Excel- Step-3.jpg”,”bigUrl”:”https://www.wikihow.com/images/thumb/a/af/Convert-XML-to-Excel-Step-3.jpg/v4-728px-Convert- XML-to-Excel-Step-3.jpg”,”smallWidth”:460,”smallHeight”:348,”bigWidth”:728,”bigHeight”:551,”licensing”:”<div class=”mw-parser -output”></div>”}
Click Open . The file browser will open.
{“smallUrl”:”https://www.wikihow.com/images_en/thumb/2/20/Convert-XML-to-Excel-Step-4.jpg/v4-728px-Convert-XML-to-Excel- Step-4.jpg”,”bigUrl”:”https://www.wikihow.com/images/thumb/2/20/Convert-XML-to-Excel-Step-4.jpg/v4-728px-Convert- XML-to-Excel-Step-4.jpg”,”smallWidth”:460,”smallHeight”:345,”bigWidth”:728,”bigHeight”:546,”licensing”:”<div class=”mw-parser -output”></div>”}
Double-click the XML file. Depending on the file format, you may need to take a few extra steps to open it:
- If there is an Import XML dialog box, open the file that references at least one XSLT style sheet. Select Open the file without applying a style sheet to choose a standard format, or Open the file with the style sheet applied to format. stylesheet data.
- If you see the Open XML dialog box, select As a read-only workbook .
{“smallUrl”:”https://www.wikihow.com/images_en/thumb/5/59/Convert-XML-to-Excel-Step-5.jpg/v4-728px-Convert-XML-to-Excel- Step-5.jpg”,”bigUrl”:”https://www.wikihow.com/images/thumb/5/59/Convert-XML-to-Excel-Step-5.jpg/v4-728px-Convert- XML-to-Excel-Step-5.jpg”,”smallWidth”:460,”smallHeight”:348,”bigWidth”:728,”bigHeight”:551,”licensing”:”<div class=”mw-parser -output”></div>”}
Click the File menu.
{“smallUrl”:”https://www.wikihow.com/images_en/thumb/b/bd/Convert-XML-to-Excel-Step-6.jpg/v4-728px-Convert-XML-to-Excel- Step-6.jpg”,”bigUrl”:”https://www.wikihow.com/images/thumb/b/bd/Convert-XML-to-Excel-Step-6.jpg/v4-728px-Convert- XML-to-Excel-Step-6.jpg”,”smallWidth”:460,”smallHeight”:348,”bigWidth”:728,”bigHeight”:551,”licensing”:”<div class=”mw-parser -output”></div>”}
Click Save As… .
{“smallUrl”:”https://www.wikihow.com/images_en/thumb/d/da/Convert-XML-to-Excel-Step-7.jpg/v4-728px-Convert-XML-to-Excel- Step-7.jpg”,”bigUrl”:”https://www.wikihow.com/images/thumb/d/da/Convert-XML-to-Excel-Step-7.jpg/v4-728px-Convert- XML-to-Excel-Step-7.jpg”,”smallWidth”:460,”smallHeight”:345,”bigWidth”:728,”bigHeight”:546,”licensing”:”<div class=”mw-parser -output”></div>”}
Go to the folder where you want to save the file.
{“smallUrl”:”https://www.wikihow.com/images_en/thumb/a/a8/Convert-XML-to-Excel-Step-8.jpg/v4-728px-Convert-XML-to-Excel- Step-8.jpg”,”bigUrl”:”https://www.wikihow.com/images/thumb/a/a8/Convert-XML-to-Excel-Step-8.jpg/v4-728px-Convert- XML-to-Excel-Step-8.jpg”,”smallWidth”:460,”smallHeight”:345,”bigWidth”:728,”bigHeight”:546,”licensing”:”<div class=”mw-parser -output”></div>”}
Select Excel Workbook from the “Save as type” drop-down menu.
{“smallUrl”:”https://www.wikihow.com/images_en/thumb/8/8e/Convert-XML-to-Excel-Step-9.jpg/v4-728px-Convert-XML-to-Excel- Step-9.jpg”,”bigUrl”:”https://www.wikihow.com/images/thumb/8/8e/Convert-XML-to-Excel-Step-9.jpg/v4-728px-Convert- XML-to-Excel-Step-9.jpg”,”smallWidth”:460,”smallHeight”:345,”bigWidth”:728,”bigHeight”:546,”licensing”:”<div class=”mw-parser -output”></div>”}
Click Save . The XML data will be saved as an Excel file.
macOS
{“smallUrl”:”https://www.wikihow.com/images_en/thumb/3/3c/Update-Excel-Step-8.jpg/v4-728px-Update-Excel-Step-8.jpg”,” bigUrl”:”https://www.wikihow.com/images/thumb/3/3c/Update-Excel-Step-8.jpg/v4-728px-Update-Excel-Step-8.jpg”,”smallWidth” :460,”smallHeight”:344,”bigWidth”:728,”bigHeight”:544,”licensing”:”<div class=”mw-parser-output”></div>”}
Open Microsoft Excel. The application is located in the Applications folder.
- Excel for macOS cannot import XML data from other sources, but the application allows you to open XML worksheet files. [2] X Research Source
{“smallUrl”:”https://www.wikihow.com/images_en/thumb/3/3b/Be-Ppitically-Correct-Step-2-Version-2.jpg/v4-728px-Be-Ppitically-Correct- Step-2-Version-2.jpg”,”bigUrl”:”https://www.wikihow.com/images/thumb/3/3b/Be-Ppitically-Correct-Step-2-Version-2.jpg/ v4-728px-Be-Ppitically-Correct-Step-2-Version-2.jpg”,”smallWidth”:460,”smallHeight”:345,”bigWidth”:728,”bigHeight”:546,”licensing”:” <div class=”mw-parser-output”></div>”}
Click the File menu at the top of the screen. [3] X Research Sources
{“smallUrl”:”https://www.wikihow.com/images_en/thumb/e/ef/Add-Grid-Lines-to-Your-Excel-Spreadsheet-Step-2.jpg/v4-728px-Add- Grid-Lines-to-Your-Excel-Spreadsheet-Step-2.jpg”,”bigUrl”:”https://www.wikihow.com/images/thumb/e/ef/Add-Grid-Lines-to- Your-Excel-Spreadsheet-Step-2.jpg/v4-728px-Add-Grid-Lines-to-Your-Excel-Spreadsheet-Step-2.jpg”,”smallWidth”:460,”smallHeight”:345,” bigWidth”:728,”bigHeight”:546,”licensing”:”<div class=”mw-parser-output”></div>”}
Click Open . A Finder window will open.
{“smallUrl”:”https://www.wikihow.com/images_en/thumb/c/c5/Convert-CSV-to-XLS-Step-5.jpg/v4-728px-Convert-CSV-to-XLS- Step-5.jpg”,”bigUrl”:”https://www.wikihow.com/images/thumb/c/c5/Convert-CSV-to-XLS-Step-5.jpg/v4-728px-Convert- CSV-to-XLS-Step-5.jpg”,”smallWidth”:460,”smallHeight”:342,”bigWidth”:728,”bigHeight”:541,”licensing”:”<div class=”mw-parser -output”></div>”}
Select the XML file. Browse to the folder containing the XML file and click on the filename to select it.
{“smallUrl”:”https://www.wikihow.com/images_en/thumb/8/81/Pick-a-Good-Gaming-Mouse-Step-1-Version-2.jpg/v4-728px-Pick- a-Good-Gaming-Mouse-Step-1-Version-2.jpg”,”bigUrl”:”https://www.wikihow.com/images/thumb/8/81/Pick-a-Good-Gaming- Mouse-Step-1-Version-2.jpg/v4-728px-Pick-a-Good-Gaming-Mouse-Step-1-Version-2.jpg”,”smallWidth”:460,”smallHeight”:334,” bigWidth”:728,”bigHeight”:529,”licensing”:”<div class=”mw-parser-output”></div>”}
Click OK . The contents of the XML file will appear.
{“smallUrl”:”https://www.wikihow.com/images_en/thumb/7/7e/Use-a-Computer-Mouse-Step-4-Version-2.jpg/v4-728px-Use-a- Computer-Mouse-Step-4-Version-2.jpg”,”bigUrl”:”https://www.wikihow.com/images/thumb/7/7e/Use-a-Computer-Mouse-Step-4- Version-2.jpg/v4-728px-Use-a-Computer-Mouse-Step-4-Version-2.jpg”,”smallWidth”:460,”smallHeight”:345,”bigWidth”:728,”bigHeight” :546,”licensing”:”<div class=”mw-parser-output”></div>”}
Click the File menu.
{“smallUrl”:”https://www.wikihow.com/images_en/thumb/c/cf/Convert-Excel-to-CSV-on-PC-or-Mac-Step-3.jpg/v4-728px- Convert-Excel-to-CSV-on-PC-or-Mac-Step-3.jpg”,”bigUrl”:”https://www.wikihow.com/images/thumb/c/cf/Convert-Excel- to-CSV-on-PC-or-Mac-Step-3.jpg/v4-728px-Convert-Excel-to-CSV-on-PC-or-Mac-Step-3.jpg”,”smallWidth”:460 ,”smallHeight”:343,”bigWidth”:728,”bigHeight”:543,”licensing”:”<div class=”mw-parser-output”></div>”}
Click Save As .
{“smallUrl”:”https://www.wikihow.com/images_en/thumb/a/a8/Use-Excel-Step-34.jpg/v4-728px-Use-Excel-Step-34.jpg”,” bigUrl”:”https://www.wikihow.com/images/thumb/a/a8/Use-Excel-Step-34.jpg/v4-728px-Use-Excel-Step-34.jpg”,”smallWidth” :460,”smallHeight”:258,”bigWidth”:728,”bigHeight”:408,”licensing”:”<div class=”mw-parser-output”></div>”}
Enter a name for the file.
{“smallUrl”:”https://www.wikihow.com/images_en/thumb/7/78/Convert-Excel-to-CSV-on-PC-or-Mac-Step-5.jpg/v4-728px- Convert-Excel-to-CSV-on-PC-or-Mac-Step-5.jpg”,”bigUrl”:”https://www.wikihow.com/images/thumb/7/78/Convert-Excel- to-CSV-on-PC-or-Mac-Step-5.jpg/v4-728px-Convert-Excel-to-CSV-on-PC-or-Mac-Step-5.jpg”,”smallWidth”:460 ,”smallHeight”:341,”bigWidth”:728,”bigHeight”:540,”licensing”:”<div class=”mw-parser-output”></div>”}
Select .CSV from the “file type” drop-down menu.
{“smallUrl”:”https://www.wikihow.com/images_en/thumb/2/2f/Convert-Excel-to-CSV-on-PC-or-Mac-Step-7.jpg/v4-728px- Convert-Excel-to-CSV-on-PC-or-Mac-Step-7.jpg”,”bigUrl”:”https://www.wikihow.com/images/thumb/2/2f/Convert-Excel- to-CSV-on-PC-or-Mac-Step-7.jpg/v4-728px-Convert-Excel-to-CSV-on-PC-or-Mac-Step-7.jpg”,”smallWidth”:460 ,”smallHeight”:346,”bigWidth”:728,”bigHeight”:547,”licensing”:”<div class=”mw-parser-output”></div>”}
Click Save . The XML file was saved with the .CSV extension on Mac.
X
This article is co-authored by wikiHow writer, Darlene Antonelli, MA. Darlene Antonelli is the author and editor of wikiHow about technology. Darlene has experience teaching at the university, writing articles related to technology and directly working in the technology field. She earned her master’s degree in writing from Rowan University in 2012 and has written a thesis on online communities and selected personalities in that community.
This article has been viewed 4,468 times.
This wikiHow teaches you how to import XML files into a Microsoft Excel spreadsheet set on Windows or macOS.
Thank you for reading this post How to Convert XML to Excel at Tnhelearning.edu.vn You can comment, see more related articles below and hope to help you with interesting information.
Related Search: