How to Convert a Bank Statement PDF to Excel: 5 Methods Compared

Bank statements are designed to be read by people, not imported by software. A PDF is essentially a set of instructions for drawing text at fixed positions on a page, so the rows and columns you see are not stored as rows and columns at all. That is why copying a statement into a spreadsheet so often produces a jumble of merged cells, broken dates and amounts that refuse to add up.

This guide walks through five practical methods for getting a bank statement PDF into Microsoft Excel (most of them also work for Google Sheets and LibreOffice Calc), explains which method suits which kind of statement, and shows how to clean and verify the result so that you can trust it for bookkeeping, tax work, a loan file or a court disclosure.

Before you start: identify what kind of PDF you have

The single biggest factor in how easy a conversion will be is whether the PDF contains real text or only a picture of text.

Digital PDFs are the files you download from online banking. The characters are stored as text, so you can select a word with your cursor, search with Ctrl+F and copy a line. These convert well with almost any method.

Scanned PDFs are images. Someone printed a statement and scanned it, or the bank produced an image-only archive copy. You cannot select individual words, and search finds nothing. These need optical character recognition (OCR) before any spreadsheet tool can read them.

Photos taken with a phone are the hardest case: perspective distortion, shadows, curved paper and uneven lighting all reduce OCR accuracy.

A quick test takes five seconds: open the PDF, press Ctrl+F (Cmd+F on a Mac) and search for a word you can see on the page, such as the bank's name. If the viewer highlights it, the file is digital. If it finds nothing, treat it as a scan. Our explainer on OCR for bank statements covers what happens under the hood with scans.

It is also worth checking whether the PDF is password-protected. Many banks in the UK, India, South Africa and elsewhere encrypt emailed statements with a password based on your date of birth or account number. Open the file, then use "Print to PDF" or your viewer's save option to create an unprotected copy, provided you are authorised to do so.

Method 1: Copy and paste (fine for a handful of rows)

For a single page with a few transactions, copy-paste is the fastest option and needs no software.

1. Open the PDF in a browser or PDF reader and select the transaction rows.
2. Copy, then click cell A1 in a blank worksheet and paste.
3. If everything lands in column A, select the column and use Data > Text to Columns. Choose "Delimited" and tick "Space", or choose "Fixed width" and drag the column breaks to match the statement layout.
4. Delete header and footer lines that came along for the ride (page numbers, "continued on next page", addresses).

The weakness of this method is consistency. Descriptions that contain spaces split into several columns, multi-line descriptions become extra rows, and amounts sometimes arrive in the wrong column when a debit cell is empty. It is fine for a quick look, but it does not scale to a year of statements.

Method 2: Excel's Power Query PDF connector

Microsoft 365 versions of Excel for Windows include a PDF connector in Power Query. Availability varies by version and platform, so if you do not see the option, check for updates or use another method.

1. Go to Data > Get Data > From File > From PDF.
2. Pick the statement. The Navigator lists every table and page Power Query detected, such as "Table001 (Page 1)".
3. Click candidates to preview them. Choose the one that looks like your transaction table, or select several pages.
4. Click Transform Data to open the Power Query Editor rather than loading straight to a sheet.
5. Promote headers, remove junk rows, set column types (Date, Decimal Number, Text) and, if the statement spans pages, append the page tables together.
6. Click Close & Load.

Power Query has one real advantage: the steps are recorded. Next month, you can point the same query at a new file from the same bank and refresh. When the layout is stable and clean, this is a good free workflow.

The drawbacks show up quickly with real statements:

• Tables that continue across pages are often detected as separate tables with slightly different column boundaries.
• Descriptions that wrap onto a second line become separate rows with no date or amount.
• Summary boxes, interest tables and marketing panels are detected as tables too, so you must pick the right one every time.
• It does nothing for scanned PDFs, because there is no text to read.

Method 3: Adobe Acrobat (export to spreadsheet)

The paid versions of Adobe Acrobat can export a PDF directly to an Excel workbook (File > Export a PDF > Spreadsheet > Microsoft Excel Workbook). Acrobat also includes OCR, so it can attempt scanned documents.

The output preserves the visual layout, which is both its strength and its weakness. You get a workbook that looks like the statement, often with merged cells, header blocks repeated on each sheet and amounts stored as text. Expect to spend time unmerging cells, deleting decorative rows and converting text to numbers. For occasional use by someone who already pays for Acrobat, it is a reasonable option. For recurring bookkeeping, the clean-up time adds up.

Method 4: Your bank's own export

Before converting anything, check whether your bank can give you the data directly. Most online banking platforms offer transaction downloads as CSV, and many also offer QBO (QuickBooks Web Connect), OFX or QIF for personal finance tools.

The catch is the history window. Many banks only offer downloadable transactions for a limited period, often somewhere between a few months and a couple of years depending on the bank and account type, while PDF statements go back further. Closed accounts usually lose online access entirely; our guide to getting old statements from a closed account covers what to do in that case. Bank exports also tend to omit opening and closing balances, so you lose the easiest way to verify completeness.

If your bank offers a CSV for the period you need, use it. If you need older data, a third party's statements, or a format the bank does not offer, you will need to convert the PDFs.

Method 5: A dedicated bank statement converter

Statement converters are built for exactly this problem. Instead of guessing at generic tables, they look for the structures that every statement shares: a statement period, an opening balance, transaction rows with a date, description and amount (or separate debit and credit columns), an optional running balance, and a closing balance.

With StatementPilot's PDF to Excel converter the workflow is:

1. Upload one or more PDFs, scans or phone photos.
2. The extractor reads every page, joins wrapped descriptions, and normalises dates and amounts.
3. A balance reconciliation check confirms that the opening balance plus transactions equals the closing balance, and that each printed running balance follows from the previous row.
4. You fix anything flagged in the review table, then download .xlsx, CSV, QBO, OFX or QIF.

The free plan covers 20 pages a month, which is enough to test the converter on your own statements before deciding whether it beats the manual methods for your volume.

Comparison: which method should you use?

Method	Scanned PDFs	Multi-page tables	Effort per statement	Cost	Best for
Copy and paste	No	Poor	High	Free	One page, a few rows
Power Query	No	Fair	Medium (low once set up)	Included with Microsoft 365	One bank, stable layout, digital PDFs
Adobe Acrobat export	Yes (OCR)	Fair	Medium to high	Paid subscription	Occasional one-off files
Bank CSV export	n/a	Good	Low	Free	Recent periods at your own bank
Statement converter	Yes	Good	Low	Free tier, then paid	Recurring work, many banks, scans

Cleaning the spreadsheet after conversion

Even good conversions sometimes need tidying. These are the issues that cause the most trouble, and how to fix them in Excel.

Dates that are stored as text

If dates are left-aligned in their cells or sort alphabetically, Excel is treating them as text. Select the column and use Data > Text to Columns, click through to step 3, choose "Date" and pick the order the statement uses (MDY for US statements, DMY for most other countries). Alternatively, use a helper column with =DATEVALUE(A2), but be careful: DATEVALUE interprets text according to your computer's regional settings, so "03/04/2026" may become 3 April or 4 March depending on the machine.

Statements without a year

Many statements print dates like "Mar 04" and show the year only in the header. When a statement runs from December into January, the January rows belong to the next year. Add the year explicitly and check the rows around the year boundary.

Amounts with currency symbols, commas or suffixes

Amounts such as "$1,234.56", "1.234,56" (common in Europe), "1,234.56 CR" or "(1,234.56)" will not calculate until they are converted. Useful formulas:

• Remove symbols and thousands separators: =VALUE(SUBSTITUTE(SUBSTITUTE(B2,"$",""),",",""))
• Turn a trailing "DR" into a negative number: =IF(RIGHT(B2,2)="DR",-VALUE(LEFT(B2,LEN(B2)-3)),VALUE(B2)) (adjust to match the exact format)
• Parentheses as negatives: Excel usually converts "(123.45)" correctly when you change the cell format to Number; if not, substitute the brackets and multiply by -1.

For European formats, it is usually easiest to use Data > Text to Columns > Advanced and set the decimal separator to a comma and the thousands separator to a period.

Separate debit and credit columns

Accounting imports usually want a single signed amount. Add a column with =C2-B2 (credit minus debit) or the reverse, depending on whether you want money out to be negative. Be consistent across every file, especially if you will later import into QuickBooks or Xero, where a wrong sign doubles a discrepancy instead of fixing it. Our comparison of QBO, OFX, QIF and CSV formats explains what each accounting tool expects.

Wrapped descriptions

When a description spills onto a second line, the conversion may produce an extra row with only text. Sort temporarily by the amount column to collect blank-amount rows together, then merge their text into the row above with a formula like =B2&" "&B3 before deleting the orphan rows. Restore the original order with an index column you added before sorting.

Verify the spreadsheet before you use it

A conversion that looks right can still be missing a page or have a sign flipped on one row. Two checks catch almost every problem.

Check 1: the statement totals. Add up the money in and money out columns and compare them with any totals printed on the statement. Then confirm:

Opening balance + total credits - total debits = closing balance

If the result is off, the difference itself is a clue. A difference that equals one transaction amount usually means a missing or duplicated row. A difference of exactly twice a transaction amount usually means a sign is reversed. A difference divisible by 9 often indicates transposed digits (for example 540 typed as 450).

Check 2: the running balance. If the statement prints a balance after each transaction, add a column that calculates it yourself: in the first row, =opening + amount, and in each subsequent row, the previous calculated balance plus the current amount. Then add a difference column against the printed balance. The first row where the difference is not zero is where the problem starts.

These are the same checks we automate in the converter, and they are covered in more depth in our guide to reconciling a bank statement.

Structuring the workbook for analysis

Once the data is verified, a little structure makes it much more useful:

• Convert the range to a table (Ctrl+T). Tables expand automatically, keep formulas consistent and work well with PivotTables.
• Add a category column and use it to group spending. A lookup table that maps payee keywords to categories saves hours over a year; see categorising bank transactions in Excel for formulas.
• Keep one sheet per account, or one combined table with an "Account" column if you want to analyse several accounts together.
• Add Month and Year columns with =TEXT(A2,"yyyy-mm") so PivotTables can summarise by period.
• Protect the raw data. Keep the original converted export on a separate sheet and do your edits on a copy so you can always trace numbers back.

For trend analysis, our article on cash flow analysis from bank statements shows how to build monthly inflow and outflow summaries.

Special cases

Credit card statements

Card statements reverse the usual sign logic: purchases increase the balance owed, and payments reduce it. They also have separate sections for purchases, payments, fees and interest, and sometimes list additional cardholders separately. Make sure every section ends up in your sheet. Our credit card statement converter handles these layouts, and the bank statement vs credit card statement guide explains the differences.

Brokerage and investment statements

Brokerage statements mix cash activity, trades, dividends and holdings. Usually you want the cash activity or the transaction history rather than the holdings table. The brokerage statement to Excel page and the guide to reading a brokerage statement explain which sections matter.

Statements in other languages and formats

Date order, decimal separators and column labels vary by country. A French statement may label columns "Débit" and "Crédit" and use commas as decimal separators; a UK statement typically uses DD/MM/YYYY; US statements use MM/DD/YYYY. Our bank directory lists statement notes for more than a hundred banks across fourteen countries, such as the Chase, Barclays and Commonwealth Bank pages.

Very large batches

If you need to convert a year of statements for twelve accounts, choose a method that handles batches and keeps each statement's reconciliation result visible. Converting files one by one through copy-paste or Acrobat is where most of the error risk lies, simply because of fatigue.

Privacy and security considerations

Bank statements contain account numbers, addresses, salaries and spending details. Before uploading them anywhere:

• Check where files are stored and for how long. We delete original uploads automatically 24 hours after conversion, and you can delete a job at any time; details are on our security page.
• Avoid generic free "PDF to Excel" websites that do not explain retention or whether files are used to train models.
• Store the resulting spreadsheets with the same care as the PDFs: password-protect the workbook or keep it in an access-controlled folder.
• If you handle client statements, check your professional obligations and client agreements regarding third-party processors.

Common mistakes to avoid

• Trusting a conversion without a balance check. A single dropped page can remove dozens of transactions, and nothing looks wrong at a glance.
• Mixing date formats across files. Combining a US and a UK statement without normalising dates produces silent errors for every day up to the 12th of each month.
• Leaving amounts as text. SUM ignores text, so totals will be understated without any warning.
• Deleting the original PDFs too early. Keep the source documents until the converted data has been reconciled and, where relevant, imported into your accounting system.
• Editing the only copy. Work on a duplicate so you can compare against the raw conversion.

Frequently asked questions

Can Excel open a PDF bank statement directly?

Microsoft 365 versions of Excel for Windows can import tables from PDF files using Data > Get Data > From File > From PDF, which uses Power Query. It only works with digital PDFs that contain text, and it often needs cleanup when tables span several pages. Excel cannot read scanned statements without OCR.

How do I convert a scanned bank statement to Excel?

A scanned statement is an image, so it needs OCR first. You can use a tool with built-in OCR, such as Adobe Acrobat's paid versions or a statement converter like our scanned bank statement to Excel tool. Always verify the result against the opening and closing balances, because OCR errors such as an 8 read as a 3 are easy to miss.

Why don't my converted amounts add up?

The most common causes are amounts stored as text, a missing page, wrapped descriptions that created extra rows, and debit or credit signs reversed. Compare opening balance plus credits minus debits against the closing balance, then use the running balance to find the first row where the numbers diverge.

Is it safe to use an online bank statement converter?

It can be, if the provider encrypts files, deletes them on a short schedule, does not use them to train AI models, and lets you delete data on demand. Read the security and privacy pages before uploading, and avoid services that do not state their retention period.

Can I convert a bank statement to Google Sheets instead?

Yes. Convert to CSV or .xlsx and import it with File > Import in Google Sheets, or use our bank statement to Google Sheets guide. Google Sheets has no built-in PDF table import, so you will still need a converter or a copy-paste step.

What is the best format to export: Excel, CSV or QBO?

Choose Excel for analysis and review, CSV for importing into most other software, and QBO, OFX or QIF when you are importing into QuickBooks, Quicken or similar tools that accept bank-feed style files. Our export formats page lists what each option contains.

Next steps

If you convert statements once a year, Power Query or a careful copy-paste may be all you need. If you convert them every month, for several banks, or from scans, a dedicated converter with built-in reconciliation will save hours and catch errors you would otherwise miss. You can try StatementPilot free on your own statements, or read our roundup of the best bank statement converters to compare options first.