How to Convert a Bank Statement to Excel

Choose the right conversion method

The quickest answer is: download a native CSV from your bank when it contains the same account and date range you need. If the official PDF is the only complete record, use Excel's PDF connector for a clean, selectable-text table or a bank-statement converter for a faster PDF-to-XLSX workflow.

These methods solve slightly different problems. A transaction download can include pending activity or a date range that does not match the issued statement. Power Query gives you control but often needs cleanup. A dedicated converter is useful when you want an Excel file immediately, but you should still compare the result with the source PDF.

Method 1: download transactions from your bank

Sign in to the bank, select the account, choose the exact date range, and look for Download, Export, or Download transactions. Choose CSV when available, open it in Excel, and confirm that the first and last dates match the period you intended to export.

This is usually the cleanest route because no PDF table has to be reconstructed. It is not always a substitute for converting a statement, though. The download may omit statement-only text, include pending transactions, or cover activity that differs from the bank-issued PDF.

Method 2: import the PDF with Excel Power Query

In supported desktop versions of Excel, go to Data, Get Data, From File, From PDF. Choose the statement, select the relevant tables in Navigator, and choose Transform Data before loading them. Remove page headers, subtotal rows, and blank lines; fill dates only when the PDF clearly uses continuation lines for the same transaction.

Power Query works best when the PDF contains a real text layer and consistent table geometry. A scanned statement is a collection of page images until OCR recognizes the text. Even on a text-based PDF, wrapped merchant descriptions and repeated headers can create extra rows, so compare the imported table with the PDF before saving the workbook.

Method 3: convert the issued PDF to XLSX

When you need the transaction rows from an issued PDF, upload the statement to a purpose-built converter and download the XLSX file. StatementMint's standard export keeps the schema intentionally small: Date, Description, and signed Amount. Purchases and withdrawals appear as negative amounts; deposits, payments, credits, and refunds appear as positive amounts according to the transaction shown on the statement.

The example below uses synthetic data, but it mirrors the columns in a StatementMint workbook. Dates are real spreadsheet dates, descriptions remain searchable text, and amounts remain numeric so you can sort, filter, total, and format them in Excel.

Check the Excel file before using it

A successful download is not proof that every row is correct. Compare the transaction count with the statement, spot-check the first and last transaction on each transaction page, and inspect the largest positive and negative amounts. Sort by date only after confirming that every transaction stayed attached to the right description and amount.

If the statement prints opening and closing balances or transaction totals, use those as additional controls when they apply. Some statements do not expose enough information for a complete arithmetic check, so the source PDF remains the final reference. Keep the spreadsheet for analysis and the PDF for the issued record.

• Confirm that the account and statement period are the ones you intended to convert.
• Check that purchases and withdrawals are negative and deposits, credits, or refunds are positive.
• Look for wrapped descriptions that became separate rows or repeated page headers that became transactions.
• Filter the Amount column to confirm it contains numbers rather than text.
• Report a problem and attach the PDF only if you choose to share it for support review.

Frequently asked questions