How to Import XML Data to a PST File in Outlook

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

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

Step

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

Step

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

Step

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

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

Step

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

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

Step

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

Step

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

Step

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

Step

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

Step

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

Step

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

Step

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