How to Convert a PST File to a CSV File

Techwalla may earn compensation through affiliate links in this story. Learn more about our affiliate and product review process here.
Use Outlook's Import and Export feature to convert PST files to CSV.

First released in 1997, Outlook is one of the world's most widely used personal information management applications. Included in the Microsoft Office suite of productivity products, the software lets users send and receive email messages, manage calendars and address books, maintain notes and task lists and much more. The program maintains this data in a Personal Storage Table (PST) file. To convert the contents of a PST file into a spreadsheet saved in Comma-Separated Values (CSV) format, make use of Outlook's Import and Export functionality.

Advertisement

Step 1

Open Microsoft Outlook.

Video of the Day

Step 2

Click "File" in the top menu bar, select "Open" and then click "Outlook Data File."

Step 3

Locate your PST file in the resulting files, then double-click its icon to load the data into Outlook.

Advertisement

Step 4

Click "File" again and select "Import and Export."

Step 5

Select "Export to a file" and click "Next."

Step 6

Select "Comma Separated Values (Windows)" and click "Next." Also click "Yes" if prompted by Outlook.

Advertisement

Step 7

Locate the folder containing the data you want to convert and click the adjacent "+" symbol.

Step 8

Click the name of the data type or folder that you want to convert (e.g., "Calendar," "Inbox").

Advertisement

Step 9

Click "Next."

Advertisement

Step 10

Click "Browse."

Step 11

Give the file a name, select a save location and click "OK."

Advertisement

Step 12

Click "Next."

Step 13

Click "Finish" to export the selected data.

Step 14

Repeat for each data type or folder requiring conversion.

Video of the Day

Advertisement

Advertisement

references