If your bank offers a transaction download in CSV or Excel, start there. It can save you the work of extracting a PDF. If you only have a statement PDF, you can use a converter, Excel's PDF import, or manual entry. The right choice depends on the document and how much cleanup you can do.
Before you start
Use the original PDF from your bank when available. Our PDF download walkthrough explains where to find it on a computer or phone. Check the account, statement period, page count, and whether the file opens without a password. For this converter, use a PDF no larger than 25 MB. Keep one account and one currency per conversion wherever possible.
A PDF with selectable text is different from a scan. A scan needs text recognition and closer checking. If your statement is locked, follow the password-protected PDF guide first.
Convert your statement in four steps
- Open the PDF to Excel converter and choose your PDF.
- Select Convert My Statement and wait for processing to finish. Processing time varies with length, layout, and image quality.
- Download Excel for a workbook, or CSV for a plain transaction table.
- Compare the result with the original statement before importing it into another system.
Guest conversions currently allow up to two pages per day. Signed-in account limits depend on the plan. Check pricing for the current allowances.
Understand the Excel output
The workbook contains two sheets. Summary holds detected account information, currency, statement period, and opening and closing balances. Transactions contains Date, Description, Debit, Credit, and Balance columns.
A blank cell can mean the information was absent or could not be extracted. The workbook does not create separate sheets for every account in a combined statement. Split those documents by account before converting when possible.
Check the numbers with a simple example
Inspect the fictional source PDF and download its Excel workbook to see the output before uploading your own document. These example downloads contain no customer data and use the application's export format.
| Date | Description | Debit | Credit | Balance |
|---|---|---|---|---|
| 2026-09-02 | Example deposit | — | 500.00 | 1,500.00 |
| 2026-09-05 | Example supplies, office | 125.00 | — | 1,375.00 |
| 2026-09-08 | Example service fee | 50.00 | — | 1,325.00 |
All amounts in this example are USD. Starting from 1,000.00, the closing balance is 1,000.00 + 500.00 − 175.00 = 1,325.00. A dash represents an empty cell. The Balance column is the account's running total; do not add it up as if it were a transaction amount.
Credit card statements can use different sign conventions, so check their payment and purchase totals separately.
- Compare the first and last transactions with the PDF.
- Inspect rows around page breaks for omissions or repeated headers.
- Check decimal points, minus signs, and dates that could be read in two ways.
- Confirm that summaries and opening balances have not become transaction rows.
- Investigate differences before you use the spreadsheet for reporting.
A balanced total is a useful check, but it does not prove that every description or date is correct.
Other ways to convert a PDF
Excel Power Query: if your Excel installation offers the PDF connector, select the file, inspect the detected tables, and choose Load or Transform Data. Repeated headers and wrapped descriptions may need cleanup. See Microsoft's PDF connector documentation for availability and limitations.
Manual entry: for a few transactions, entering rows yourself may be practical. Check the totals and keep a copy of the source document.
A custom script: a parser can suit a repeated, consistent layout. You will need to handle format changes, scans, and validation yourself. Avoid assuming that a parser built for one bank will work for another.
Choose your next step
Keep Excel for reviewing and analysing the transactions. If you need accounting software, read CSV vs QBO before exporting. For difficult scans, start with our OCR preparation guide.