How to Convert an XML File to Excel (with Images)

Table of contents:

How to Convert an XML File to Excel (with Images)
How to Convert an XML File to Excel (with Images)
Anonim

This wikiHow teaches you how to import an XML file into a Microsoft Excel worksheet 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. Launch Microsoft Excel

The Excel program icon is located within the "Microsoft Office" group of the list All apps from the Windows "Start" menu.

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

Step 2. Access the File menu

It is located in the upper left corner of the Excel window.

If you are using Excel 2007, press the button with the Microsoft Office logo

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

Step 3. Click Open

The Windows "File Explorer" dialog will be displayed.

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

Step 4. Double-click the icon of the XML file to be processed

Depending on the format of the file under consideration, you may need to perform additional steps before you can open it in Excel:

  • If the "Import XML" dialog box appears, the selected file references one or more style sheets in XSLT format. In this case you can choose the option Open the file without applying a style sheet to use normal Excel formatting or entry Open the file and apply the following stylesheet to format the data according to the selected style sheet.
  • If the "Open XML" dialog appears, choose the option Read-only workbook.
Convert XML to Excel Step 5
Convert XML to Excel Step 5

Step 5. Access the File menu

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

Step 6. Choose the Save As… option

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

Step 7. Select the folder where you want to store the new Excel file

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

Step 8. Choose the Excel Workbook format from the "Files of type" drop-down menu

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

Step 9. Press the Save button

At this point the data contained in the original XML file has been stored in the Excel file you created.

Method 2 of 2: macOS

Step 1. Launch Microsoft Excel

The program icon is stored in the "Applications" folder.

The macOS version of Excel cannot import XML data from an external source, but it does allow you to open an XML spreadsheet

Step 2. Access the File menu

It is located at the top of the screen.

Step 3. Click Open

The "Finder" dialog will be displayed.

Step 4. Select the XML file to use

Navigate to the folder where it's stored, then select the file name with a single mouse click.

Step 5. Press the OK button

The content of the XML file will be displayed on the screen.

Step 6. Access the File menu again

Step 7. Choose the Save As option

Step 8. Name the file you want

Step 9. Choose the. CSV format from the "Files of type" drop-down menu

Step 10. Press the Save button

The data present in the chosen XML file will be stored in CSV format in the specified folder of the Mac.

Recommended: