Bulk Convert PST to CSV without outlook with All data

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

This method is built particularly for technical users who have experience with PowerShell scripting. It lets users convert PST to CSV automatically by running, creating and troubleshooting scripts.

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.