To convert PST to JSON manually, add the PST file in Outlook. Then export the required email folder as a CSV file. Then use Python with Pandas to turn the CSV records into JSON format.
This method needs Outlook and basic scripting. It does not export attachment files or the full folder structure.
A dedicated PST to JSON converter can export supported mailbox data directly to JSON. Also it processes multiple PST files in bulk.
An Outlook PST file stores mailbox data including emails, contacts, calendar entries, tasks, and notes. JSON uses a structured format that applications, scripts and databases can process. To convert PST to JSON, you need a method that extracts the required data and maps it into JSON format. This guide explains three conversion methods, their requirements and limitations to help you choose the right approach. 
Understanding PST and JSON File Formats
| Aspects | PST File Format | JSON File Format |
|---|---|---|
| Full Form | Personal Storage Table | JavaScript Object Notation |
| File Extension | .pst | .json |
| Data Stored | Emails, contacts, calendars, tasks, and notes | Structured data, including text, numbers, arrays, and objects |
| File Structure | Stores mailbox items in folders and subfolders | Organizes data using key-value pairs, objects, and arrays |
| Compatibility | Primarily used with Microsoft Outlook | Supported by programming languages, web applications, and APIs |
Why Organizations Convert PST to JSON?
This conversion is driven by specific technical requirements, which are as follows:
- API and web application integration: Modern apps ingest structured JSON, not proprietary binary formats.
- CRM and ticketing system imports: Customer email history needs to be mapped into structured records. For example, a multiplex chain turning thousands of refund complaint emails into searchable support tickets.
- Machine learning and analytics pipelines: Sentiment analysis and search indexing need structured and parseable data. For instance, a marketing team parsing years of customer inquiry emails to auto-categorize FAQs to train a chatbot.
- Serverless architecture compatibility: AWS Lambda, Google Cloud Functions, and similar platforms cannot parse PST natively.
If any one of these maps to your situation, the conversion method mentioned below should be chosen considering the data’s sensitivity and volume, not convenience alone.
Method 1: Convert PST to JSON Using CSV and Python
You can convert PST to JSON manually with Microsoft Outlook and Python. Outlook exports email data into a CSV file which Python can convert into JSON format. This method is suitable for users who need basic email information in a structured format.
Step 1: Open the PST File in Outlook
Launch Classic Microsoft Outlook on your Windows computer.
- Select File then Open & Export.
- Now choose Open Outlook Data File.
- Browse and select your PST file.
- Click Open. Locate the imported PST folders in the Outlook folder pane.
Step 2: Export Outlook Emails to CSV
- Go to File, select Open & Export. Then click Import/Export.
- Choose Export to a file and click Next.
- Select Comma Separated Values (CSV) and click Next.
- Select the required email folder, such as Inbox and click Next.
- Choose a destination folder and enter a name for the CSV file.
- Click Map Custom Fields to review the available email fields for export.
- Click Finish to save the CSV file.
Repeat these steps for every required folder and subfolder. Outlook exports only the selected folder’s emails when using CSV format. It does not automatically include nested subfolders.
Step 3: Convert CSV Data into JSON Using Python
After exporting the Outlook emails, use Python with the Pandas library to convert the CSV file into JSON format.
1. Open Google Colab and create a new notebook.
2. Run the following code to upload your CSV file:
from google.colab import files uploaded = files.upload()
3. Add another code cell and run this Python script:
import pandas as pd
# Read the exported CSV file
csv_file = next(iter(uploaded))
data = pd.read_csv(
csv_file,
dtype=str,
keep_default_na=False
)
# Convert email records into JSON
data.to_json(
"outlook_data.json",
orient="records",
indent=2,
force_ascii=False
)
print("CSV data converted to JSON successfully.")
4. Run this code to download the JSON file:
files.download("outlook_data.json")
Your JSON file will contain email records based on the columns available in the exported CSV file.
Method 2: Convert PST to JSON Without Outlook Using Command Line
You can convert PST to JSON without Outlook using the pst_to_json command-line utility.
Steps:
1. Download the Windows executable from GitHub Releases.
2. Open Command Prompt in the downloaded tool’s folder.
3. Run this command:
pst_to_json -s "C:\PST\archive.pst" -d "C:\JSON\archive.json" -v -p
4. Replace the input and output paths with your file locations. Press Enter to start the conversion.
Method 3: Convert PST to JSON on Mac Using Command Line
Mac users can use a Python-based command-line tool to convert Outlook PST files into JSON without installing Outlook.
Steps:
1. Open Terminal and install the required library: brew install libpst
2. Download the PST to JSON GitHub project and open its folder in Terminal.
3. Run this command:
python3 -m pst_converter.cli "/path/to/archive.pst" -f json --full --folders
4. Replace the PST path with your actual file location and press Enter.
The tool saves JSON output in the output folder. The –full option includes email bodies, while –folders creates separate files for individual folders.
Method 4: Export PST to JSON Using Professional Converter Tool
When data integrity, bulk processing, or file accessibility issues rule out the methods above, purpose-built conversion software addresses the exact gaps those methods leave open. When the data to be converted is highly confidential and important, this approach is the most preferred and secure, as a dedicated SysTools PST Converter Tool is capable of reading the MAPI structure directly. This bypasses CSV entirely, which means emails, contacts, calendar entries, notes, and attachments all convert with their original structure intact.
Step 1. Launch the software. Choose File Mode or Folder Mode. Then browse to upload the PST files you want to convert into JSON.

Step 2. Check the specific data types you want to process. The choices are Email, Calendar, Contact, Task, Notes and Journal.

Step 3. Apply the date filter if you want to export items from a set period. (e.g., specific start and end dates). You can skip it to export everything.

Step 4. Go to the export options list and select JSON as your export format.

Step 5. Browse for your preferred output folder on your computer. Then click Export to complete the conversion.

When you convert with professional tools, batch conversions can handle dozens of PST files in a single operation. Your mailbox data gets converted fast and in a predictable manner once you convert this way.
Manual Method vs Dedicated PST to JSON Converter
| Aspects | Manual Method | Dedicated Converter |
|---|---|---|
| Outlook Required | Required for CSV export | Not required |
| Technical Skills | Requires Python or command-line knowledge | No coding required |
| Bulk Conversion | Requires separate folder exports | Supports multiple PST files |
| Attachments | Not included in CSV data | Supports attachment export |
| Processing | More manual steps | Automated conversion |
Also Read: How to Convert MSG to JSON File Format Like a Pro
Wrapping Up
Conversion of PST to JSON is fundamentally a schema translation problem. Every method discussed above handles that translation with a different degree of fidelity. The manual approach is sufficient for a smaller mailbox. A tool-based approach is preferred for important and highly confidential data. Because they contain client history, compliance-relevant records and years of institutional data. The selection of the method should match what your data is actually worth to you.
Frequently Asked Questions
No, Outlook has no direct PST to JSON export function. Conversion requires an intermediate CSV export and script, a command-line PST parser or dedicated conversion software.
It depends entirely on the method. CSV-based manual conversion commonly loses attachment binaries, nested folder structure, and precise timestamps, because CSV cannot represent Outlook’s full MAPI property set. Dedicated conversion tools avoid this by parsing the MAPI structure directly.
Not for every method. Command-line PST parsers and dedicated converter tools read the PST file’s internal structure directly and don’t need Outlook installation.
Each mailbox item becomes a discrete JSON object with explicitly labeled fields such as subject, sender, recipient, timestamp, body content, and attachment references structured for direct ingestion by databases, APIs, or applications.