PayPal CSV Not Opening or Missing Transactions? Fix It

Source workflow verified: August 29, 2026

A PayPal CSV may appear incomplete because the report covers the wrong dates, uses filters, is still processing, or opened with the wrong delimiter. PayPal’s Activity Download supports custom reports and several file formats, with special limits for large date ranges.

Quick answer: In PayPal, use History → Download → Custom, choose the report and dates, generate it, and wait for its status to complete. Download the original CSV before opening a working copy.

Create a fresh PayPal CSV

  1. Sign in through the official PayPal website.
  2. Open History and select Download.
  3. Choose Custom.
  4. Select the appropriate activity report.
  5. Set the start and end dates and review any filters.
  6. Choose CSV and generate the report.
  7. Wait until PayPal marks it ready, then download it.

PayPal says activity can be downloaded for up to seven years, but an individual request can cover a maximum of 12 months. If you need a longer history, create separate non-overlapping annual or shorter files and label each period.

For the complete workflow and alternative formats, see how to download PayPal transaction history.

If the CSV opens in one column or shows wrong numbers

Symptom Likely cause Safe fix
All data in one column Delimiter was not detected Import as text/CSV and select comma
Dates changed Automatic date formatting Set the intended locale or import dates as text
Amounts look too large Decimal/thousands separator mismatch Check locale and preview before importing
Long IDs changed Spreadsheet converted them to numbers Import identifier columns as text
Headers or rows shifted File was edited or converted Return to the original download

PayPal’s own guidance includes using spreadsheet filters to review report data. Apply filters after importing correctly, and avoid overwriting the source file.

If transactions are missing

  1. Check that the report’s first and last dates match the intended period.
  2. Confirm that the request covers no more than 12 months.
  3. Remove transaction-type or status filters and generate a broad comparison file.
  4. Check whether you are signed in to the correct personal or business account.
  5. Compare refunds, reversals, fees, holds, and currency conversions with the on-screen Activity view.
  6. Download adjacent periods when a boundary date may fall outside the selected range or timezone.

A PayPal tax form or Reconciliation Report is not the same as an Activity CSV. If you are checking Form 1099-K totals, use our guide to download and reconcile a PayPal 1099-K.

If the report is still processing

PayPal says small logs can be available immediately, while large logs may take up to five business days. Avoid submitting many identical requests. Check the report status and your recent downloads; PayPal says the last three large logs are saved.

If a completed file will not download, try the current browser version, permit the download for PayPal, confirm available storage, and use official PayPal support if the problem is account-specific.

Data safety: Activity reports can expose names, email addresses, transaction IDs, payment notes, balances, and business activity. Do not upload them to unverified conversion or “CSV repair” websites.

Frequently asked questions

How much PayPal history can one report include?

PayPal says activity is available for up to seven years, with a maximum 12-month date range per request.

Why is my PayPal report taking so long?

Large logs can take up to five business days. Monitor the existing request rather than generating repeated duplicates.

Can PayPal export directly to Excel?

PayPal provides CSV and other formats. Import CSV into Excel and verify delimiter, dates, and decimal settings before saving as XLSX.

Why are refunded transactions still visible?

A report may show the original payment and its later refund or reversal as separate account events. Reconcile their identifiers and statuses instead of deleting one row.

Primary source

Formats, date limits, processing times, and workflow were checked on August 29, 2026.