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.

Method 1
Method 1 of 2:
Windows

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

Method 2
Method 2 of 2:
macOS

  1. Image titled Update Excel Step 8
    1
    Open Microsoft Excel. You’ll find it in the Applications folder.
    • Excel for macOS cannot import XML data from another source, but it will allow you to open XML spreadsheet files.[2]
  2. Image titled Be Politically Correct Step 2
    2
    Click the File menu. It’s at the top of the screen.[3]
  3. Image titled Add Grid Lines to Your Excel Spreadsheet Step 2
    3
    Click Open. This opens a Finder window.
  4. Image titled Convert CSV to XLS Step 5
    4
    Select the XML file. To do this, browse to the folder where it’s contained, then click the file name once.
  5. Image titled Pick a Good Gaming Mouse Step 1
    5
    Click OK. The contents of the XML file will appear.
  6. Image titled Use a Computer Mouse Step 4
    6
    Click the File menu.
  7. Image titled Convert Excel to CSV on PC or Mac Step 3
    7
    Click Save As.
  8. Image titled Use Excel Step 34
    8
    Type a name for the file.
  9. Image titled Convert Excel to CSV on PC or Mac Step 5
    9
    Select .CSV from the “file type” drop-down menu.
  10. Image titled Convert Excel to CSV on PC or Mac Step 7
    10
    Click Save. The XML file is now saved as a .CSV on your Mac.

You Might Also Like

Make a Zip File
How to
Make a Zip File
Copy and Paste
How to
Copy and Paste
Automatically Shut Down Your Computer at a Specified Time
How to
Automatically Shut Down Your Computer at a Specified Time
Copy and Paste a Link
How to
Copy and Paste a Link
Open XML
How to
Open XML
Shut Down Your PC with a Shortcut Key
How to
Shut Down Your PC with a Shortcut Key
Shut Down or Restart Another Computer Using CMD
How to
Shut Down or Restart Another Computer Using CMD
Refresh a Page
How to
Refresh a Page
Jitter Click
How to
Jitter Click
Turn Off Driving Mode
How to
Turn Off Driving Mode
Select All
How to
Select All
Open Downloads
How to
Open Downloads
Unzip a File
How to
Unzip a File
Change a File Extension
How to
Change a File Extension

References

  1. ↑ https://support.office.com/en-us/article/Import-XML-data-6eca3906-d6c9-4f0d-b911-c736da817fa4#_showdevelopertab
  2. ↑ https://answers.microsoft.com/en-us/msoffice/forum/msoffice_excel-mso_mac-mso_mac2016/import-xml/805f11b3-fead-4217-80fb-244e52c389e7
  3. ↑ https://www.techwalla.com/articles/how-to-convert-xml-to-csv-on-a-mac

About This Article

Nicole Levine, MFA
Written by:
Nicole Levine, MFA
Tech Specialist
This article was written by Nicole Levine, MFA. Nicole Levine is a Technology Writer and Editor for wikiHow. She has more than 20 years of experience creating technical documentation and leading support teams at major web hosting and software companies. Nicole also holds an MFA in Creative Writing from Portland State University and teaches composition, fiction-writing, and zine-making at various institutions. This article has been viewed 203,400 times.
How helpful is this?
Co-authors: 4
Updated: December 3, 2019
Views: 203,400
Categories: File Manipulation | Basic Computer Skills
Article SummaryX

1. Open the file in Excel.
2. Click File.
3. Click Save As.
4. Change the file type to .CSV.
5. Click Save.

Did this summary help you?