How to convert a bank statement PDF to Excel
Start with a searchable PDF, keep the original nearby, and check the extracted transactions before using the spreadsheet.
Choose the right source
Use a text-based PDF whose dates, descriptions, debit, credit and balance columns can be selected as text. A scanned picture of a statement will not work in the local converter. Password-protected files must be unlocked in your own trusted PDF tool first.
Convert and review
Upload the PDF in the converter. Local PDF extraction supports date-led transaction rows and clearly labelled Debit / Credit or Withdrawal / Deposit columns. Layouts vary, including within one bank, so a bank name alone does not establish compatibility.
Keep the dates honest
Choose the statement year before importing if dates omit a year. Numeric dates are read day-first. If a statement spans two years and omits years in its rows, correct each affected date in the review table.
Check the arithmetic
Enter opening and closing balances from the source. Compare money in, money out and the difference. Inspect individual running-balance flags, then confirm any missing or repeated rows. Matching arithmetic alone does not prove every description or amount was read correctly.
Export the useful version
Choose Excel for editable columns or standard CSV for another spreadsheet. Source page numbers remain with the rows. If a layout is not recognised, use a bank-exported CSV or the example CSV format instead.