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.
Click the "Start" button in the lower-left corner of the desktop, then click the "All Programs" option.
Scroll to "Microsoft Office' and click the "Microsoft Excel" option.
Click the "Data" tab at the top of the screen, then click the "From Other Sources" button in the "Get External Data" section.
Select the "XML" option, then locate the .xml file on the computer. Click the "Import" button to add the .xml data to the spreadsheet.
Click the "Office" button in the top-left corner of the screen and choose the "Save As" option.
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.
Click the "Start" button, then click the "All Programs" option.
Scroll to "Microsoft Office' and click the "Microsoft Outlook" option.
Click "File" at the top of the screen, then click the "Import and Export" option.
Select the "Import from another program or file" option, then click the "Next" button.
Click the "Comma Separated Values (Windows)" option, then click the "Next" button.
Click the "Browse" button and locate the .csv file you just created, then click the "Next" button.
Select the Outlook folder into which you would like to add the information, then click the "Next" button.
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).