How to Convert a Bank Statement PDF to Excel or CSV for Free

Published July 28, 2026 · Updated July 28, 2026

If you've ever needed to upload transactions into accounting software, apply for a loan, or analyze your spending, you've probably run into a frustrating wall: your bank only gives you PDF statements, and what you really need is a CSV or Excel file.

Manually typing rows of transactions from a PDF into a spreadsheet is tedious, error-prone, and a huge time sink. Fortunately, there's a better way. With a bank statement to CSV converter, you can extract all your transactions — dates, descriptions, amounts — in seconds.

Why Convert a PDF Bank Statement to CSV?

CSV (comma-separated values) is the universal format for spreadsheets and accounting tools. Here's why you want it:

• Accounting software import: QuickBooks, Xero, Wave, and FreshBooks all accept CSV imports. A bank PDF converter saves you from manual data entry.
• Expense analysis: Load your transactions into Excel or Google Sheets to categorize spending, spot trends, and create budgets.
• Tax preparation: Your accountant will thank you for clean, digitized records instead of a stack of PDF pages.
• Loan applications: Lenders often ask for transaction history in a machine-readable format.

Which Banks Work with PDF-to-CSV Conversion?

A good bank pdf converter should handle statements from any bank. Here are the most common ones people convert:

• Chase: Extract a Chase statement CSV from your monthly PDFs. Chase formats vary by account type, but a reliable converter handles them all.
• Bank of America: BofA statements with multiple pages and dense transaction tables convert cleanly.
• Wells Fargo: Their statements include running balances — watch for parsers that handle the extra column.
• US Bank, Citibank, PNC, Capital One, and many more: Any standard table-based statement works.

How to Convert Your Bank Statement PDF to CSV

Using a free online bank statement to CSV tool is the fastest method. Here's the process:

1. Download your statement: Log into your online banking and download the monthly statement as a PDF.
2. Upload to the converter: Go to tooly.work/banktocsv and upload your PDF.
3. Review the extracted data: The tool parses the PDF and shows you the extracted transactions.
4. Export as CSV or Excel: Download your clean file and open it in your spreadsheet app or import it directly into accounting software.

What If the PDF Is Scanned or Image-Based?

Some bank statements come as scanned images rather than text-based PDFs. These require OCR (optical character recognition) to extract the text. If your converter doesn't support OCR, you'll see garbled output. The Tooly bank statement converter includes OCR support for scanned statements, so even older or printed statements work.

Tips for Clean Conversion Results

• Use the original PDF — not a photocopy or re-saved version that may reduce quality.
• Check date formats: Some CSV exports use MM/DD/YYYY. You can reformat in Excel with a simple text-to-columns operation.
• Watch for negative amounts: Credits and debits are often shown differently (parentheses vs. minus signs). A good converter normalizes these.

What to Do After Converting

Once you have your CSV file, here's what you can do with it:

• Import to QuickBooks: Use the "Import Data" feature under the Transactions menu.
• Load into Google Sheets: Use File → Import → Upload and select your CSV.
• Merge multiple months: Copy all rows into a single spreadsheet for a full year of tracking.
• Categorize with formulas: Use VLOOKUP or IF formulas to auto-categorize recurring transactions.

Stop Typing Transactions by Hand

Whether you need a bank statement to CSV for accounting, a Chase statement CSV for tax prep, or just want your finances in a spreadsheet, the right tool makes it instant. No manual typing. No errors. No frustration.

Looking for more tools? Tooly offers 26+ free online tools for freelancers and small businesses — no signup needed.