How to Convert Bank Statement to Excel: 5 Methods That Keep Dates and Totals Right

If you want to know how to convert bank statement to Excel, start with your bank. Most online banking sites let you download transactions as CSV, and sometimes as an Excel file, so check that first. If all you have is a PDF, run it through our free bank statement to Excel converter, which reads the file in your browser and gives you a clean spreadsheet. Then fix the dates, turn debit and credit columns into one signed amount, and check that the totals match the statement.

We built that converter because our team handles CSV lead lists, VCF contacts and PDF reports every day, and our own month-end close means getting statements into a spreadsheet. Below is every method we have tested and where each one breaks.

Can I export my bank statement to Excel directly from my bank?

Often, yes. Before you convert anything, look for a download option in your online banking. Banks usually put it near the transaction list or account activity, labeled something like “Download”, “Export” or “Download transactions”. The menu names differ from bank to bank and change with redesigns, so look around the account activity page rather than following a path from a forum post.

A direct export beats any converter because the bank sends structured data, with no broken rows or guessed columns. The trade-off is that exports often cover transactions only, not the formatted statement with your opening and closing balance, and some banks limit how far back you can download.

Which export format should you pick?

If your bank only gives you a plain text export with odd delimiters, our TXT to CSV converter turns it into a proper CSV that Excel opens without the Text Import Wizard.

How to convert bank statement to Excel: 5 methods that work

These are the five methods we use, from fastest to most manual.

1. Download the export from online banking

Covered above. If the bank offers CSV or XLSX for the period you need, use it.

2. Use the LeadCanal bank statement converter in your browser

This is the method we built for the job. It runs entirely in your browser, so the PDF never leaves your computer. Here is how to use it:

1. Open the bank statement to Excel tool.
2. Drop your PDF statement onto the page or pick it with the file button. The tool only accepts PDFs and checks the file signature, so a renamed file is rejected.
3. If the statement is password protected, type the password when asked. Many banks lock e-statements with a password built from your details. It is used locally to open the file and is not sent anywhere.
4. Download the Excel file. It has two sheets: Transactions, with the rows the tool recognized as transactions, and All text, with every line of text from the PDF so nothing is lost if a row was missed.
5. Check the totals against the statement before you rely on the file (see the reconciliation section below).

Dates are kept exactly as printed on the statement. That is deliberate: a guess between March 4 and April 3 for 03/04 could silently scramble a whole month. You set the date order in Excel, as shown below.

3. Use Excel’s Get Data From PDF (Power Query)

Excel can read tables out of a PDF itself. In Microsoft 365 for Windows, go to Data > Get Data > From File > From PDF, choose the statement, and the Navigator lists every table and page Excel detected. Select the transaction table, then click Load, or Transform Data if you want to clean it in Power Query first.

Availability varies. The PDF connector depends on your Excel version, platform and licence, and some versions and platforms do not show it at all. Microsoft documents it in the Power Query PDF connector reference. Two more limits: it cannot open a password-protected PDF until you remove the password, and statements often come through as one table per page, so you append the page tables in Power Query to get one list.

4. Export the PDF to Excel with Adobe Acrobat

Acrobat Pro and Standard can save a PDF as a spreadsheet. Open the statement, choose the Export PDF option, pick Spreadsheet and then Microsoft Excel Workbook, and save. Adobe explains the options in its guide to exporting PDFs to other file formats. The menu layout changes between Acrobat versions, so look for “Export PDF” or “Convert” if the names differ.

Acrobat keeps the layout well, so expect merged cells, wrapped descriptions on two rows and headers repeated on every page. Adobe’s online converter uploads your file to Adobe’s servers, unlike the desktop app.

5. Run OCR on scanned or paper statements

A scanned bank statement to Excel job is different. A scan or phone photo is an image, so there is no text layer for a converter or Power Query to read. You need optical character recognition (OCR) first. Acrobat can recognize text in scanned documents, and many scanner apps add a text layer when they save to PDF.

If you photographed several pages, first combine the JPG pages into one PDF so you keep them in order, then run OCR on that file. Check every number after OCR. It commonly misreads 1 and 7, 0 and 8, and decimal points, and one wrong digit breaks your reconciliation.

Which method should you use? Comparison table

Copy and paste from a PDF viewer also works for a few rows, but columns usually land in one cell and need Text to Columns.

Is it safe to upload bank statements to online converters?

Be careful. A statement holds your name, address, account number and a full record of where you spend money. Many “free” converters work by uploading the PDF to their server, and you usually cannot check how long they keep it or who can see it. That information is exactly what identity thieves use, as the FTC explains in its guide on what to know about identity theft.

That is why our converter runs 100% in the browser. The file is read by your own device, nothing is stored, and there is no account to create. Whatever tool you use, follow a few rules:

• Prefer local tools: desktop software, Excel itself or a browser-based converter.
• Read the privacy policy: check how long an upload site keeps files.
• Delete working copies: remove downloaded spreadsheets you no longer need, especially on shared computers.

How do you clean a bank statement after converting it to Excel?

Conversion gets the text into cells. Cleaning makes it usable. These are the steps we follow every time.

Fix the dates

Because statements print dates in many formats, Excel may read some as dates, some as text and some the wrong way round. To fix a date column:

1. Select the date column.
2. Go to Data > Text to Columns, choose Delimited, and click Next twice.
3. Under column data format, choose Date and pick the order your statement uses, such as DMY for 03/04/2026 meaning 3 April or MDY for March 4.
4. Click Finish and apply a clear date format.

If the statement prints dates without a year, such as “04 Mar”, add the year from the statement period in a helper column before converting, or January rows on a December statement will land in the wrong year.

Turn debit and credit columns into one signed amount

Most statements split money out and money in. Analysis is easier with one amount column where outgoing money is negative. If debits are in column C and credits in column D, use:

=N(D2)-N(C2)

N() treats a blank cell as zero, so the formula works whichever column is filled. If your statement uses a single column with “DR” and “CR” suffixes, strip the suffix and apply the sign, for example =IF(RIGHT(B2,2)="DR",-1,1)*VALUE(TRIM(LEFT(B2,LEN(B2)-2))). For amounts printed with a comma as the decimal separator, NUMBERVALUE(B2,",",".") converts them correctly.

Reconcile the totals

This is the step people skip. It is also the one that catches missed rows. Check that:

opening balance + SUM(signed amounts) = closing balance

In Excel, =ROUND(B1+SUM(E:E)-B2,2) should return 0, where B1 is the opening balance and B2 the closing balance. If it does not, compare total debits and total credits with the summary box on the statement. That tells you which side is off. Then look in the All text sheet for the missing line. Never use a converted statement for tax, lending or bookkeeping until it reconciles.

Remove the noise

Delete repeated page headers, “balance brought forward” lines and footers so they do not count as transactions, and merge descriptions that wrapped onto a second row. Then press Ctrl+T to turn the range into a table.

A worked example from our own month-end

At month-end we had a four-page, password-protected PDF statement for one of our business accounts and needed the transactions in a sheet for our bookkeeper.

1. We opened the converter, dropped in the PDF and typed the statement password.
2. The Transactions sheet came back with dates as printed (“04 Mar”), separate debit and credit columns and a running balance.
3. We added the year, converted the dates with Text to Columns, and built a signed amount with =N(D2)-N(C2).
4. The reconciliation check was off by the amount of one transaction. The All text sheet showed a card payment whose description wrapped across a page break. We added that row and the check returned 0.

The statement never touched a server.

Troubleshooting: common problems and fixes

If a lender portal also wants the original PDF under a size cap, you can compress the PDF to 300KB or another target size, again without uploading it to us. All our converters are listed on the free tools page.

Frequently asked questions

How to convert bank statement to Excel for free?

Check your online banking for a free CSV export first. If you only have the PDF, a free browser-based converter such as ours, or Excel’s From PDF option if your version includes it, will do it without paid software.

Can I export my bank statement to Excel?

Many banks let you download transactions as CSV, and some offer Excel, OFX or QFX files. Look for a Download or Export option near your account activity. If there is none, convert the PDF statement instead.

How do I convert a scanned bank statement to Excel?

Run OCR on the scan first so the image becomes searchable text, then convert it. Check every amount afterwards, because OCR often misreads similar digits and decimal points.

What is the best bank statement to Excel software?

It depends on the file. For text-based PDFs, a local or in-browser converter is fast and private. For scans, Acrobat or another OCR-capable app is better. For regular imports, your bank’s own CSV export beats any software.

Can Excel open a password-protected PDF statement?

Excel’s PDF import cannot open an encrypted file. Remove the password first in a PDF reader you trust, or use a converter that asks for the password and opens the file locally.

Is it safe to use online bank statement converters?

Only if you know where the file goes. Many sites upload your statement to their servers. A tool that works in your browser, or desktop software, keeps the file on your device.

Conclusion: key takeaways

Knowing how to convert bank statement to Excel is mostly about choosing the right source and then checking the result. Use the bank’s export when you can, a private converter when you cannot, and always reconcile.

• Check online banking for a CSV, XLSX, OFX or QFX export before converting a PDF.
• Use an in-browser converter so statements with account numbers never get uploaded.
• Scanned or photographed statements need OCR before any converter can read them.
• Fix dates with Text to Columns and build one signed amount from debit and credit.
• Opening balance plus signed amounts must equal the closing balance before you rely on it.

Editorial policy

We write guides about tasks we do ourselves. Every method here was tested on real statement layouts, and menu paths are given only where we are confident they match current versions. Where software varies by version or platform, we say so instead of guessing. This guide explains file conversion only and is not financial, tax or legal advice.

Content transparency

This guide on how to convert bank statement to Excel was researched with keyword data and checked against official documentation from Microsoft, Adobe and the FTC. LeadCanal built and offers the free bank statement converter and the other free tools mentioned here. They run in your browser, and we do not receive or store the files you convert.

About the author

The LeadCanal team builds verified B2B lists, enriches CRM data and runs cold email infrastructure every day. That means a steady stream of CSV, VCF and PDF files to convert and clean, which is why we built free, private file converters for our own work and yours.