Home Application Software conversion

How to Convert XML to Excel

This wikiHow teaches you how to import an XML file into a Microsoft Excel workbook using Windows or macOS. Open Microsoft Excel. You'll find Excel in the 'Microsoft Office' group in the All Apps area of the Windows menu.

Table of Contents
Method 1 of 2:

Windows

  1. Picture 1 of How to Convert XML to Excel
    Open Microsoft Excel. You'll find Excel in the 'Microsoft Office' group in the All Apps area of the Windows menu.
  2. Picture 2 of How to Convert XML to Excel
    Click File. It's at the top-left corner of Excel.
    1. If you're using Excel 2007, click the round button with the Microsoft Office logo inside instead.[1]
  3. Picture 3 of How to Convert XML to Excel
    Click Open. This opens the file browser.
  4. Picture 4 of How to Convert XML to Excel
    Double-click the XML file. Depending on the format of the file, you may have to take additional steps to open this file:
    1. 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.
    2. If you see the Open XML dialog, select As a read-only workbook.
  5. Picture 5 of How to Convert XML to Excel
    Click the File menu.
  6. Picture 6 of How to Convert XML to Excel
    Click Save As….
  7. Picture 7 of How to Convert XML to Excel
    Navigate to the folder where you'd like to save the file.
  8. Picture 8 of How to Convert XML to Excel
    Select Excel Workbook from the 'Save as type' drop-down.
  9. Picture 9 of How to Convert XML to Excel
    Click Save. The XML data is now saved as an Excel file.
Method 2 of 2:

macOS

  1. Picture 10 of How to Convert XML to Excel
    Open Microsoft Excel. You'll find it in the Applications folder.
    1. Excel for macOS cannot import XML data from another source, but it will allow you to open XML spreadsheet files.[2]
  2. Picture 11 of How to Convert XML to Excel
    Click the File menu. It's at the top of the screen.[3]
  3. Picture 12 of How to Convert XML to Excel
    Click Open. This opens a Finder window.
  4. Picture 13 of How to Convert XML to Excel
    Select the XML file. To do this, browse to the folder where it's contained, then click the file name once.
  5. Picture 14 of How to Convert XML to Excel
    Click OK. The contents of the XML file will appear.
  6. Picture 15 of How to Convert XML to Excel
    Click the File menu.
  7. Picture 16 of How to Convert XML to Excel
    Click Save As.
  8. Picture 17 of How to Convert XML to Excel
    Type a name for the file.
  9. Picture 18 of How to Convert XML to Excel
    Select .CSV from the 'file type' drop-down menu.
  10. Picture 19 of How to Convert XML to Excel
    Click Save. The XML file is now saved as a .CSV on your Mac.

You've just finished reading the article "How to Convert XML to Excel" edited by the TipsMake team. You can save how-to-convert-xml-to-excel.pdf to your computer here to read later or print it out. We hope this article has provided you with many useful tech tips and tricks. You can search for similar articles on tips and guides. Thank you for reading and for following us regularly.

« PREV : How to Compress...
How to Clear up... : NEXT »
Read more