How to Convert PST File to Excel

Techwalla may earn compensation through affiliate links in this story.
Image Credit: Siri Stafford/Digital Vision/Getty Images

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.

Advertisement

Export Your PST File from Outlook

Step 1

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

Video of the Day

Step 2

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

Advertisement

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

Advertisement

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.

Advertisement

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

Advertisement

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

Advertisement

references