How to Export PayPal Transactions to Excel (2026 Guide for Business Owners)

If you run a business through PayPal, you've probably felt the pain of pulling your transaction data into a spreadsheet. PayPal's raw Activity Report CSV is 30+ columns wide and mixes payments received, refunds, fees, transfers, and currency conversions into one tangled file. Getting that into a clean, usable Excel spreadsheet requires some work.

This guide covers every method for exporting PayPal transactions to Excel — including which method is right for your situation and how to clean up the data once you have it.

Which PayPal Statement Type Do You Have?

Before choosing a method, it helps to know what you're working with:

PayPal Business Account (Activity Report): If you use PayPal to accept payments or pay for business expenses, your transaction history lives in the Activity section. PayPal provides a CSV download here — it covers everything in your account but requires significant cleanup.

PayPal Credit (formerly Bill Me Later): This is a separate credit product issued by Synchrony Bank. If you carry a balance on PayPal Credit, you receive PDF monthly statements — these are handled differently from regular PayPal account activity. See the PDF statement conversion method below.

PayPal Cash Card / Debit Card: Transactions appear in your main account activity and can be exported via the Activity Report.

Method 1: Download PayPal's Activity Report CSV (Recommended for Most Users)

This is the most direct route. PayPal lets you download a complete transaction history as a CSV file that you can open in Excel.

Step 1: Go to Activity and Filter Your Date Range

1. Log in to paypal.com
2. Click Activity at the top of the page
3. Use the date filters to select your desired period (monthly, quarterly, or custom)
4. For business users, a one-month or one-quarter range keeps the file manageable

Step 2: Download the CSV

1. Click Download Transactions (top right of the Activity page)
2. Select Comma Delimited - All Activity for the most complete export
3. Choose your date range again to confirm
4. Click Download Report

PayPal will generate a CSV file named something like Download.CSV or PayPal_activity_...csv.

Step 3: Open in Excel and Clean Up the Data

This is where most users get stuck. PayPal's raw export includes 30+ columns and mixes transaction types that you probably want to separate. Here's a systematic cleanup process:

1. Open the file in Excel. When you open a .csv file in Excel, use Data > From Text/CSV rather than double-clicking. This preserves leading zeros in transaction IDs and handles date formats correctly.

2. Delete the columns you don't need. The PayPal export includes columns like Transaction ID, Invoice Number, Custom Number, Confirmation Number, and Balance. For most business purposes, you only need:

• Date
• Name (counterparty)
• Type
• Status
• Currency
• Gross
• Fee
• Net

3. Filter out non-business rows. PayPal's export includes currency conversions, bank transfers, and balance adjustments alongside actual income and expenses. Use Data > Filter and filter the Type column to show only the transaction types you care about:

4. Combine Gross and Fee into Net. PayPal reports the gross amount, the fee amount (negative), and the net amount separately. For most accounting purposes, use the Net column — that's what actually hit your balance after PayPal's fee.

5. Standardize the Amount column sign. PayPal uses negative numbers for money going out and positive for money coming in, but this can flip depending on transaction type. Add a helper column to confirm direction before sorting.

Method 2: Convert a PayPal Credit PDF Statement

If you use PayPal Credit (the buy-now-pay-later product), your statements are PDF files — not an activity export. This is a proper credit account with a billing cycle, minimum payment, and monthly statement, issued through Synchrony Bank.

PayPal Credit statements don't have a built-in CSV export option. The fastest way to get transactions into Excel:

1. Log in to PayPal and navigate to PayPal Credit > Statements
2. Download the PDF for the month you need
3. Go to CreditCardToExcel.com
4. Upload the PDF
5. Download as Excel or CSV in about 30 seconds

The AI extraction handles the structured transaction table in the PayPal Credit PDF and produces a clean four-column spreadsheet (Date, Description, Amount, Category). For a broader overview of how this works with any credit card PDF, see the credit card statement to Excel guide.

Method 3: Connect PayPal to Accounting Software Directly

If you use accounting software for your business, you may not need to touch Excel at all. Several tools connect directly to PayPal via API:

• QuickBooks Online — Connect via Banking > Add Account > PayPal. Transactions sync automatically. See our guide on importing credit card statements into QuickBooks for the general import workflow.
• Xero — Xero has a native PayPal app in their marketplace that syncs transactions daily.
• Wave — Connect PayPal under Accounting > Bank Connections.
• FreshBooks — Limited PayPal sync available via the FreshBooks-PayPal integration.

The direct sync approach is best if you need continuous reconciliation. The CSV export method in Method 1 is better if you want a one-time or periodic snapshot, or if your accounting software doesn't support PayPal connections.

Cleaning Up PayPal Data for Tax Purposes

For freelancers and small business owners, the most important use of PayPal export data is usually tax preparation. Here's what the IRS (and most tax professionals) care about:

Gross receipts: PayPal sends 1099-K forms when you receive more than $600 in payments (as of 2024 rules). The 1099-K uses gross amounts before fees. Make sure your total income figure in Excel matches the gross column, not the net.

Business vs. personal transactions: If you use one PayPal account for both, you'll need to manually flag personal transactions and exclude them from business totals. Add a "Business?" column and filter it before summing.

Fees as a deduction: PayPal's transaction fees are a deductible business expense. Sum the Fee column (the negative values) to get total fees paid for the year.

Currency conversion: If you receive international payments, PayPal converts the currency at the time of transaction. The USD equivalent in the Net column is what you report for income — but keep the original currency columns for reference.

For a detailed walkthrough of categorizing transactions for tax filing, see our guide on categorizing credit card expenses for taxes.

Tips for Monthly PayPal Bookkeeping

If you run your business finances through PayPal, a monthly export routine keeps your books clean:

Download on the last day of each month. PayPal's "Custom" date range lets you select exactly the current month. Do this the same day each month, before the next month's transactions start appearing.

Save files with a consistent naming convention. Something like paypal-2026-03.csv (year-month) makes it easy to find historical files and import them in order.

Reconcile against your PayPal balance. After filtering your transactions, sum the Net column and confirm it matches the change in your PayPal balance during the period. If it doesn't match, you missed a transaction type in your filter.

Keep the original file. Once you clean up the CSV in Excel, save a separate clean copy and leave the original untouched. Raw files are useful for troubleshooting discrepancies later.

Separate income sources if you have multiple. If you sell physical products, offer services, and receive affiliate payments — all through PayPal — add a "Source" column in Excel and tag each transaction type. This makes it much easier to compare categories month over month.

Common Problems with PayPal Exports (and Fixes)

The dates are formatted strangely. PayPal uses MM/DD/YYYY HH:MM:SS format. If Excel treats these as text instead of dates, use Text to Columns to reparse them, or use a formula like =DATEVALUE(LEFT(A2,10)) to extract just the date portion.

Amounts have currency symbols. PayPal includes currency codes like "USD" in the amount columns. Strip these using Find & Replace (Ctrl+H): find " USD" and replace with nothing.

Duplicate entries appear. If you set overlapping date ranges or export twice, you'll get duplicate rows. Use Excel's Remove Duplicates (Data > Remove Duplicates) on the Transaction ID column to clean these up.

The file opens with garbled characters. This happens with international characters in customer names. When opening via Data > From Text/CSV, make sure the encoding is set to UTF-8.

Refunds are counted as income. PayPal marks refunds you received (for a charge reversal) as positive — but they're not income. Filter by Type = "Refund" and exclude those rows from your income total.

Summary: Which Method to Use

For most freelancers and small business owners, the Activity Report CSV export covers 90% of use cases. The cleanup steps above are a one-time investment — once you have a template with the right column filters, each month takes about five minutes.

If you're dealing with PDF statements from PayPal Credit or any other credit card issuer, CreditCardToExcel handles the conversion automatically and gets you to a clean spreadsheet without the manual cleanup work. For a complete overview of how PDF-to-spreadsheet conversion works across any issuer, see our full guide to converting credit card statements to Excel.