How to Import XML Data to a PST File in Outlook

By Matthew Burley

Microsoft Outlook manages email, contacts and tasks for both individuals and businesses. All of the data that is used in Outlook is stored in one large file with the file type .pst. While it is possible to import different types of data into Outlook, an Extensible Markup Language (.xml) file is not natively supported. Therefore, it is necessary to convert the .xml file to a type that is supported, such as a .csv file. This conversion can be performed in the spreadsheet application, Microsoft Excel.

Step 1

Click the "Start" button in the lower-left corner of the desktop, then click the "All Programs" option.

Step 2

Scroll to "Microsoft Office' and click the "Microsoft Excel" option.

Step 3

Click the "Data" tab at the top of the screen, then click the "From Other Sources" button in the "Get External Data" section.

Step 4

Select the "XML" option, then locate the .xml file on the computer. Click the "Import" button to add the .xml data to the spreadsheet.

Step 5

Click the "Office" button in the top-left corner of the screen and choose the "Save As" option.

Step 6

Click the "Save as Type" drop-down menu and select the "CSV" option. Change the name and location of the the file, if necessary, then click the "Save" button.

Step 7

Click the "Start" button, then click the "All Programs" option.

Step 8

Scroll to "Microsoft Office' and click the "Microsoft Outlook" option.

Step 9

Click "File" at the top of the screen, then click the "Import and Export" option.

Step 10

Select the "Import from another program or file" option, then click the "Next" button.

Step 11

Click the "Comma Separated Values (Windows)" option, then click the "Next" button.

Step 12

Click the "Browse" button and locate the .csv file you just created, then click the "Next" button.

Step 13

Select the Outlook folder into which you would like to add the information, then click the "Next" button.

Step 14

Click the "Finish" button to complete the import of the original .xml data into the Outlook .pst file.

Tips & Warnings

  • If the .xml file that you are importing to your Outlook .pst file is for contacts, then the file must be set up in a specific manner. Navigate to the Microsoft web page concerning the importation of files from the Palm Desktop to Outlook (see References).