How to Convert XML to Excel (With Images)

Table of contents:

How to Convert XML to Excel (With Images)
How to Convert XML to Excel (With Images)

Video: How to Convert XML to Excel (With Images)

Video: How to Convert XML to Excel (With Images)
Video: how to open a .zip file without winzip (FREE) 2024, March
Anonim

This article will teach you how to import an XML file into a Microsoft Excel workbook using a Windows or Mac computer.

Steps

Method 1 of 2: Windows

Convert XML to Excel Step 1
Convert XML to Excel Step 1

Step 1. Open Microsoft Excel You can find it in the "Microsoft Office" group in the All apps area in the "Windows" menu

Convert XML to Excel Step 2
Convert XML to Excel Step 2

Step 2. Click File in the upper left corner of the window

In Excel 2007, click the round button with the Office logo

Convert XML to Excel Step 3
Convert XML to Excel Step 3

Step 3. Click Open… to open "File Explorer"

Convert XML to Excel Step 4
Convert XML to Excel Step 4

Step 4. Double click on the XML file

Depending on the file format, some additional steps may be required.

  • If you see the "Import XML" dialog, the file references at least one XSLT stylesheet. click in Open the file without applying a stylesheet to select the default format, or in Open the file with the following stylesheet applied to format the data according to the style sheet.
  • If you see the "Open XML" dialog, select As a read-only workbook.
Convert XML to Excel Step 5
Convert XML to Excel Step 5

Step 5. Click on the File menu item

Convert XML to Excel Step 6
Convert XML to Excel Step 6

Step 6. Click Save As…

Convert XML to Excel Step 7
Convert XML to Excel Step 7

Step 7. Navigate between the folders where you want to save the file

Convert XML to Excel Step 8
Convert XML to Excel Step 8

Step 8. Select Excel Workbook from the "Save as type" drop-down menu

Convert XML to Excel Step 9
Convert XML to Excel Step 9

Step 9. Click Save

Then the XML data will be saved to the Excel file.

Method 2 of 2: Mac OS

Step 1. Open Microsoft Excel You can find it in the "Applications" folder

Excel for macOS does not import XML data from another source, but it does allow opening XML spreadsheets

Step 2. Click on the File menu located at the top of the screen

Step 3. Click Open

Then the "Finder" window will open.

Step 4. Select the XML file

To do this, navigate to the folder where the file is saved and click on it.

Step 5. Click OK

Now you will see the contents of the XML file.

Step 6. Click on the File menu

Step 7. Click Save As

Step 8. Enter a name for the file

Step 9. Select CSV from the "File Type" drop-down menu

Step 10. Click Save

Then the XML file will be saved as CSV on Mac.

Recommended: