The easiest way to Convert XML to Excel

Today's TipsMake will show you how to import XML files into a Microsoft Excel spreadsheet set on Windows or macOS. Open Microsoft Excel.

Windows

The easiest way to Convert XML to Excel Picture 1The easiest way to Convert XML to Excel Picture 1

Open Microsoft Excel. You'll find Excel in the 'Microsoft Office' group from the All Apps list of the Windows menu.

The easiest way to Convert XML to Excel Picture 2The easiest way to Convert XML to Excel Picture 2

Click File in the upper left corner of Excel.

On Excel 2007, click the round button with the Microsoft Office icon inside.

The easiest way to Convert XML to Excel Picture 3The easiest way to Convert XML to Excel Picture 3

Click Open . The file browser will open.

The easiest way to Convert XML to Excel Picture 4The easiest way to Convert XML to Excel Picture 4

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. Choose 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.

The easiest way to Convert XML to Excel Picture 5The easiest way to Convert XML to Excel Picture 5

Click the File menu .

The easiest way to Convert XML to Excel Picture 6The easiest way to Convert XML to Excel Picture 6

Click Save As… .

The easiest way to Convert XML to Excel Picture 7The easiest way to Convert XML to Excel Picture 7

Go to the folder where you want to save the file.

The easiest way to Convert XML to Excel Picture 8The easiest way to Convert XML to Excel Picture 8

Select Excel Workbook from the 'Save as type' drop-down menu.

The easiest way to Convert XML to Excel Picture 9The easiest way to Convert XML to Excel Picture 9

Click Save . The XML data will be saved as an Excel file.

macOS

The easiest way to Convert XML to Excel Picture 10The easiest way to Convert XML to Excel Picture 10

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.

The easiest way to Convert XML to Excel Picture 11The easiest way to Convert XML to Excel Picture 11

Click the File menu at the top of the screen.

The easiest way to Convert XML to Excel Picture 12The easiest way to Convert XML to Excel Picture 12

Click Open . A Finder window will open.

The easiest way to Convert XML to Excel Picture 13The easiest way to Convert XML to Excel Picture 13

Select the XML file. Browse to the folder containing the XML file and click on the filename to select it.

The easiest way to Convert XML to Excel Picture 14The easiest way to Convert XML to Excel Picture 14

Click OK . The contents of the XML file will appear.

The easiest way to Convert XML to Excel Picture 15The easiest way to Convert XML to Excel Picture 15

Click the File menu .

The easiest way to Convert XML to Excel Picture 16The easiest way to Convert XML to Excel Picture 16

Click Save As .

The easiest way to Convert XML to Excel Picture 17The easiest way to Convert XML to Excel Picture 17

Enter a name for the file.

The easiest way to Convert XML to Excel Picture 18The easiest way to Convert XML to Excel Picture 18

Select .CSV from the 'file type' drop-down menu.

The easiest way to Convert XML to Excel Picture 19The easiest way to Convert XML to Excel Picture 19

Click Save . The XML file was saved with the .CSV extension on Mac.

3.5 ★ | 4 Vote