Written by Jennifer Walsh. Reviewed for technical accuracy by Shubham Dixit, Independent Expert in Email Forensics and Data File Conversion.
Shubham is an independent external reviewer and not an employee of PCDOTS.
Quick answer. PST is Outlook’s mailbox format and CSV is a plain spreadsheet. If you have classic Outlook, its built-in Import/Export turns contacts into CSV for free, but not email messages. For emails, or if you do not have Outlook at all, a converter that reads the .pst directly is the way to get a CSV.
On this page
PST is a mailbox, CSV is a spreadsheet
Worth a quick framing, because it decides which route you take. A PST is Outlook’s mailbox file, holding emails, contacts, calendar and more in Outlook’s own format. A CSV is a plain text spreadsheet, rows and columns you can open in Excel or Google Sheets. So converting PST to CSV means pulling data out of that mailbox into tidy columns. Two questions shape how you do it, do you have the classic desktop Outlook, and do you want your contacts or your emails? Those answers point you at either the free built-in export or a tool, and the rest of this guide is just those two paths.
Converting turns mailbox items into spreadsheet rows.
“There is a lot of confusion here, and it comes from one fact people miss, Outlook’s own export to CSV only handles contacts, not your emails. Outlook keeps mail and contacts as different kinds of data, so the wizard simply will not turn a mail folder into a spreadsheet. That is fine if contacts are what you are after, and the built-in export does it well, on classic Outlook. But the moment you want email fields like subject, sender and date in columns, or you do not have Outlook installed at all, you need a tool that opens the .pst file directly and reads it without Outlook in the loop. That is the honest dividing line.” Shubham Dixit, Email Data reviewer (draft, pending approval)
Contacts to CSV in Outlook, free
If contacts are what you need and you have the classic desktop Outlook, this is free and built in. Open Outlook, go to File, Open & Export, then Import/Export. Choose Export to a file, then Comma Separated Values, and click Next. Now pick your Contacts folder, choose where to save, and if you want to control the columns, use Map Custom Fields to pick which details go in. Click Finish, and Outlook writes a clean CSV of your contacts, ready for Excel, Google Contacts or a CRM. It is the standard way to move an address book, and it works well.
The built-in export, for contacts, on classic Outlook.
What Outlook won’t do
Here is the part that catches everyone, and it is why so many people search for a way around Outlook. That built-in export only handles contacts, plus calendar and tasks, not your email messages. Outlook treats mail and contacts as different kinds of data, so there is simply no option in the wizard to turn an inbox into a CSV of subjects, senders and dates. On top of that, the Import/Export wizard lives in the classic desktop Outlook only, it is not in the new Outlook, Outlook on the web, or Outlook for Mac. So if you want emails as a spreadsheet, or you do not have classic Outlook installed, the native route is a dead end, and that is exactly where the next method comes in.
Emails, or without Outlook at all
A lot of people specifically need to do this without Outlook, either they never installed it, or it is on a different machine, or they just want the emails as data. Because a PST is Outlook’s own format, you need something that can open the .pst file directly and read it, no Outlook required. A dedicated converter does exactly that, it reads the mailbox from the file itself and writes the fields you want, subject, from, to, date and more, straight into a CSV. If you only want to look inside a PST first, a free PST viewer opens one without Outlook too. This is the honest answer to the without-Outlook question, a reader that does not depend on the app at all.
The direct converter
For emails to CSV, or any PST-to-CSV job without Outlook, the PCDOTS PST Converter Wizard opens the .pst file on its own and exports the contents to CSV, both emails and contacts, letting you choose which fields become columns. It reads the file directly, so Outlook does not need to be installed, and it handles multiple or large PST files in one run. It works on Windows with a free trial so you can test the output first. If you only need contacts and you already have classic Outlook, the free export above is enough, this is for emails, bulk, and the no-Outlook case.
The tool route, a PST turned into a CSV without Outlook.
The tool follows four short steps.
Step 1. Install and run the software on Windows.
Step 2. Add your PST file directly, no Outlook needed.
Step 3. Open Export and choose CSV.
Step 4. Pick a destination and save.
Related reading, our guides to back up Outlook emails, and if your CSV ends up with repeats, the CSV Duplicate Remover cleans them out.
The methods compared
Pick by whether you have classic Outlook and what you want out.
| Method | Best for | Good to know |
|---|---|---|
| Outlook Import/Export | Contacts to CSV | Free, classic Outlook, no emails |
| Direct converter | Emails, or no Outlook | Reads the .pst itself |
| Free PST viewer | Just looking inside | Opens a .pst, no Outlook |
Frequently asked questions
Can I convert a PST file to CSV without Outlook?
Yes. Use a converter that opens the .pst file directly, since it reads the mailbox from the file and does not need Outlook installed at all.
Why can’t I export my emails to CSV in Outlook?
Outlook’s Import/Export CSV option only covers contacts, calendar and tasks, not email messages. For emails as a spreadsheet, use a direct PST to CSV converter.
How do I export Outlook contacts to CSV?
In classic Outlook, go to File, Open & Export, Import/Export, choose Export to a file, Comma Separated Values, select Contacts, and save.
Does the export work in the new Outlook?
No. The Import/Export wizard is in classic desktop Outlook only, not the new Outlook, Outlook on the web, or Outlook for Mac.
Can I convert PST to TSV instead of CSV?
Some converters offer tab separated values as well. Otherwise, export to CSV and change the delimiter to a tab in a spreadsheet program.
Are online PST to CSV converters safe?
A PST can be large and hold private mail, so uploading one to a website carries a real privacy cost. A tool that works on your own computer keeps the data local.
Which route fits you
So it comes down to two quick checks. Do you have the classic desktop Outlook, and is it your contacts you want? If yes to both, the built-in export is free and does the job in a minute, no download needed. If you want your emails as a spreadsheet, or you do not have Outlook at all, the native route cannot help, and a converter that opens the .pst directly is the way. Answer those two questions first, and the right method for your situation is obvious rather than a guess.
