Best 3 Ways to Convert PST to CSV with Complete Data

# 2 Method: Convert PST to CSV Via PowerShell and Scripts

This approach is suitable for users who have the knowledge to debug and run scripts using PowerShell.

Prerequisites:

• The PST file must be locally stored on your system.
• Outlook must be installed on your system (this PowerShell script depends on the Outlook COM object for working).

PowerShell Script to Convert PST Files to CSV

# Define the source PST file path and the destination CSV file path
$pstPath = "C:\PST\MyData.pst"
$csvPath = "C:\PST\all_items.csv"
$outlook = New-Object -ComObject Outlook.Application
$namespace = $outlook.GetNamespace("MAPI")
$namespace.AddStore($pstPath)
$pstName = [System.IO.Path]::GetFileNameWithoutExtension($pstPath)
$rootFolder = $namespace.Folders.Item($pstName)
$allItems = @()
function Process-Folder {
    param($folder)
    foreach ($item in $folder.Items) {
        try {
            switch ($item.MessageClass) {
                "IPM.Note" {
                    $allItems += [PSCustomObject]@{
                        ItemType    = "Email"
                        Folder      = $folder.Name
                        Subject     = $item.Subject
                        From        = $item.SenderName
                        To          = $item.To
                        Date        = $item.ReceivedTime
                        Company     = ""
                        Phone       = ""
                        Email       = ""
                        BodyPreview = ($item.Body.Substring(0, [Math]::Min(100, $item.Body.Length)))
                    }
                }
                "IPM.Contact" {
                    $allItems += [PSCustomObject]@{
                        ItemType    = "Contact"
                        Folder      = $folder.Name
                        Subject     = $item.FullName
                        From        = ""
                        To          = ""
                        Date        = ""
                        Company     = $item.CompanyName
                        Phone       = $item.MobileTelephoneNumber
                        Email       = $item.Email1Address
                        BodyPreview = ""
                    }
                }
            }
        } catch {
            Write-Warning "Failed to process item in $($folder.Name): $_"
        }
    }
    foreach ($subFolder in $folder.Folders) {
        Process-Folder -folder $subFolder
    }
}
Process-Folder -folder $rootFolder
$allItems | Export-Csv -Path $csvPath -NoTypeInformation -Encoding UTF8
# Display a success message in the console
Write-Output "All PST items exported to: $csvPath"

Important Note: Before following the working steps save the PowerShell script by the name of Export-PST-All.ps1 using your Notepad.