How to Convert PST Files to CSV on Mac

Converting a PST file to CSV on a Mac is possible, but the correct method depends on what data you want. A PST can contain email, contacts, calendar events, tasks, notes, and folder structure. CSV, by contrast, is a simple table format. It is excellent for contacts and structured lists, but it is not a faithful replacement for a complete Outlook mailbox.

This is where many old tutorials become misleading. Outlook for Mac can import PST files in supported versions, but Microsoft’s normal Mac archive export produces OLM—not a general CSV export of all PST data. Outlook for Windows and Outlook on the web provide clearer native CSV workflows for contacts.

If your goal is to extract contacts from a PST into CSV, Microsoft-native methods are practical. If your goal is to turn thousands of email messages into rows containing sender, subject, date, body, and attachment names, you will need a specialized exporter or a scripted/third-party workflow because Outlook does not treat a whole mailbox as a spreadsheet.

The original article linked to a PST Converter for mac. That backlink is preserved exactly. This guide explains the supported Microsoft options first, when a dedicated converter makes sense, how to design a useful CSV, and how to prevent data loss or privacy problems.

What Is a PST File?

PST stands for Personal Storage Table.

Outlook for Windows uses PST files for:

exports;
archives;
POP accounts;
mailbox migration;
local storage.

A PST may contain:

email;
contacts;
calendar;
tasks;
notes;
folders;
attachments.

What Is CSV?

CSV stands for Comma-Separated Values.

A CSV is a plain-text table where each row represents a record and columns represent fields.

Example contact CSV:

First Name,Last Name,Email,Phone

CSV is useful because it can be opened by:

Excel;
Google Sheets;
Numbers;
databases;
CRM systems;
contact import tools.

CSV Is Not a Mailbox Format

CSV cannot naturally preserve:

folder hierarchy;
rich HTML rendering;
embedded attachments;
calendar recurrence;
Outlook-specific properties;
message flags.

Decide What You Need to Export

Choose:

contacts only;
email metadata;
email bodies;
calendar data;
everything for analysis.

Best Native Method for Contacts

If the PST contains contacts, one practical workflow is:

Import the PST into a supported Outlook environment.
Move or synchronize the contacts to Outlook.com/Microsoft 365 if appropriate.
Open Outlook on the web.
Go to People.
Select Manage contacts → Export contacts.
Download the CSV.

Microsoft’s current support documentation confirms that Outlook on the web and Outlook.com export contacts as CSV.

Classic Outlook for Windows Can Export Contacts Directly

If you have access to Windows:

Open the PST in classic Outlook.
Choose File → Open & Export → Import/Export.
Select Export to a file.
Select Comma Separated Values.
Select Contacts.
Choose destination.
Finish.

Why Windows May Be Easier

Microsoft’s native Windows export wizard can map Outlook contact fields directly into CSV.

That avoids depending on a third-party PST parser.

Importing PST on Mac

Microsoft supports importing PST files into legacy Outlook for Mac.

Typical steps:

Open Outlook for Mac.
Choose File/Tools → Import.
Select Outlook for Windows archive file (.pst).
Choose the PST.
Import.
Find data under On My Computer.

Legacy Outlook for Mac Support Changes in 2026

Microsoft has announced end-of-support changes for legacy Outlook for Mac beginning in October 2026 depending on licence and account type.

If your migration depends on legacy import/export features, verify the current Microsoft support status before beginning a large conversion.

Outlook for Mac Does Not Offer a General “PST to CSV” Export

The old article described a Windows-style File → Open → Import/Export → CSV wizard on macOS.

That is not the normal Outlook for Mac workflow.

Microsoft’s current Mac documentation focuses on:

importing PST;
importing/exporting OLM;
moving contacts through supported account tools.

Method 1: PST Contacts → Outlook on the Web → CSV

This is a strong option if the contacts can be moved into an Outlook.com or Microsoft 365 account.

Advantages

Microsoft-native;
easy CSV export;
UTF-8 support;
good for contacts.

Limitations

requires cloud upload;
not suitable for email bodies;
may be inappropriate for confidential/offline archives.

Method 2: Use a Windows PC or VM

If you own Outlook for Windows, this can be the most reliable native route.

You can run Windows through:

physical PC;
virtual machine;
corporate remote desktop.

Follow licensing and organizational policy.

Method 3: Dedicated PST Converter on Mac

A specialized converter can parse PST directly and export selected data to CSV.

This may be useful when:

no Windows Outlook is available;
you need bulk extraction;
you need message data rather than only contacts;
processing must stay local.

Define the CSV Schema Before Conversion

For contacts, columns might include:

First Name;
Last Name;
Display Name;
Email 1;
Email 2;
Mobile;
Business Phone;
Company;
Job Title;
Address;
Notes.

Email CSV Schema

If exporting messages for analysis:

Folder;
From;
To;
Cc;
Subject;
Sent Date;
Received Date;
Message-ID;
Body Text;
Attachment Names.

Do Not Put Binary Attachments Inside CSV

A better approach is:

export attachments to folders;
store filenames/paths in CSV.

HTML Email

If the converter exports body content, decide whether you want:

plain text;
raw HTML;
both.

Raw HTML can make the CSV difficult to read.

CSV Encoding

Use UTF-8 for international text.

Microsoft specifically recommends UTF-8 CSV for broad language compatibility when importing contacts.

Why Encoding Matters

Wrong encoding can damage:

Arabic;
Urdu;
Chinese;
accented names;
emoji.

CSV Delimiters

Some regional spreadsheet settings use:

comma;
semicolon.

Make sure the target application understands the delimiter.

Quoted Fields

A proper CSV exporter should quote fields containing:

commas;
line breaks;
quotation marks.

Otherwise message bodies and addresses can break the table.

Large PST Files

A very large PST can take substantial time to parse.

Before conversion:

copy to local SSD;
check free space;
close Outlook;
back up original.

Never Convert Your Only PST

Use:

Original.pst;
WorkingCopy.pst;
Output folder.

Corrupt PST

If Outlook cannot open the PST, the issue may be corruption.

Microsoft’s Inbox Repair Tool, SCANPST.EXE, can repair certain PST structural problems on Windows.

It is not a CSV converter.

PST Size Is Not Automatically Corruption

The old article implied that PST files commonly exceed a maximum size and become corrupted.

Modern Unicode PSTs support large files, but very large PSTs can still create:

slow backups;
long indexing;
difficult recovery;
operational inconvenience.

Size alone does not prove corruption.

Duplicate Contacts

After migration, duplicate contacts can appear because of:

multiple imports;
synced accounts;
duplicate PST archives;
old CRM exports.

Deduplication

Do not deduplicate only by name.

Compare:

email;
phone;
company;
address.

Two people can share a name.

CSV Is Good for Data Analysis

Once message metadata is exported, you can analyze:

email volume by month;
top senders;
top recipients;
subject patterns;
response volume;
attachment counts.

Privacy

A CSV can be more exposed than PST because:

it is plain text;
it opens in many apps;
it has no built-in mailbox permissions.

Protect sensitive exports with:

encrypted disk;
access controls;
secure transfer;
appropriate retention.

CSV Injection Risk

If CSV data will be opened in spreadsheet software, fields beginning with certain characters can be interpreted as formulas.

For untrusted data, sanitize leading characters such as:

according to your security requirements.

Legal and Compliance Data

Do not convert business email to CSV and then discard PST if the original format is required for:

legal hold;
eDiscovery;
audit;
records retention.

CSV may lose important message properties.

Verify the Output

After conversion:

Count source contacts/messages.
Count CSV rows.
Check headers.
Check old and new dates.
Check non-English text.
Check duplicate behavior.
Keep the PST.

Using Excel

When opening the CSV in Excel:

confirm encoding;
check columns;
do not accidentally convert phone numbers to scientific notation;
do not lose leading zeros;
save a working copy separately.

Using Google Sheets

Upload only if the content is appropriate for cloud processing.

Confidential corporate email should follow your organization’s data policy.

What About CSV to Outlook?

Microsoft can import contact CSV files into:

new Outlook for Windows;
classic Outlook;
Outlook on the web.

This is another reason CSV is a useful contact interchange format.

Recommended Contact Workflow

Back up PST.
Open/import in supported Outlook.
Export or sync contacts.
Create UTF-8 CSV.
Verify columns.
Keep original PST.

Recommended Email-Analysis Workflow

Copy PST.
Define required fields.
Use trusted local exporter.
Export message metadata/body to UTF-8 CSV.
Export attachments separately.
Validate row count.
Protect sensitive output.

Useful Microsoft Resources

Final Thoughts

PST-to-CSV conversion is most straightforward when you are exporting contacts. Microsoft’s Windows and web versions of Outlook provide native CSV tools, while Outlook for Mac focuses more heavily on PST import and OLM archive workflows.

For email, CSV should be treated as an analysis or data-exchange format rather than a mailbox replacement. Decide exactly which fields you need, use UTF-8, export attachments separately, and preserve the original PST.

A dedicated Mac converter can be useful when native Microsoft workflows do not meet the requirement, but test it on a copy and verify the output before trusting a large archive.