How to Convert PST File to Excel

You may need to convert your PST file in Outlook to an Excel file to do something with your data, such as creating a list of mailing addresses. The Outlook PST (personal storage table) file is a database containing your Outlook data such as contact info, calendar entries and email messages.

Image Credit: Siri Stafford/Digital Vision/Getty Images

Export Your PST File from Outlook

Step 1

From Outlook, click the File menu and select "Import and Export."

Step 2

Select "Export to a File" on the Import and Export Wizard. Click "Next."

Step 3

Select "Microsoft Excel 97-2003" as the file type to create on the Export to a File dialog box. Click "Next." Your PST folders will display in a directory tree.

Step 4

Select the data you want to export from the directory tree. For example, if you want to export your address list to Excel, select the Contacts folder. Click "Next."

Step 5

Type a name for your data file. You can click the "Browse" button to view your computer and select a folder in which to save the file. If you are exporting your contacts to Excel, you might name the file "My Contacts." The file type will already be "Excel 97-2003" based on your selection in step 3. Click "OK" to save the file and click "Finish" to complete the export.

Import Your Outlook Data Into Excel

Step 1

Open Microsoft Excel. Click the Office button and select "Open."

Step 2

Navigate to the location of the file you created when you exported your data from Outlook. Select the file and click "Open."

Step 3

Your data will display in Excel, where you can work with it.
If you exported your contacts, for example, you can work with your data in Excel to create a mailing list.

Things You'll Need

  • Microsoft Office Outlook 2007

  • Microsoft Office Excel 2007

references