Upload a PDF bank statement and get a working Excel file back, with every transaction on its own row and the running balance intact. Digital PDFs, scanned statements, and phone photos all work. Start free, no credit card.
Last updated August 2026
Upload your bank statement
Drop file here or click to upload
PDF, JPG, PNG, BMP, HEIC, TIFF, MT940
Uploading...
To convert a bank statement to Excel, upload the statement PDF to BankXLSX and download the result as an .xlsx file with date, description, debit, credit, and running balance in separate columns. Excel can also import a PDF through Data, then Get Data, then From PDF, but bank statements usually come through with merged columns and repeated page headers that take longer to clean up than the conversion saves. A typical statement finishes in under a minute and exports to CSV as well.
The transactions are visible on screen, so it looks like a five minute job. Then you paste it into a sheet. Here is what usually happens.
Copying a PDF table into Excel jams the date, description, and amount together, so the first hour goes to Text to Columns instead of the actual work.
Pasted figures arrive with dollar signs, commas, and trailing spaces, so SUM returns zero until every cell has been scrubbed.
Excel can import a PDF, but multi-line descriptions get split across rows and some bank layouts are not detected as tables at all.
A twenty page statement drops the account header and column labels into the middle of your data at every page break.
A scanned or photographed statement is an image. There is nothing to select, so the fallback is retyping several hundred lines.
Quick exports and online downloads usually drop the balance column, which is the first number a lender or auditor looks for.
The converter reads the transaction table on the page rather than guessing at the text layer, then writes it into a spreadsheet you can sort and total straight away.
A proper Excel workbook with number formatting applied, not a text dump you have to reformat before it will calculate.
Date, description, debit, credit, and running balance each get their own column, which is the layout bookkeepers expect.
OCR reads scanned PDFs and phone photos in JPG, PNG, HEIC, and TIFF, so an image-only statement converts the same way.
Upload twelve or twenty four statements together and they come back stitched into one continuous sheet in date order.
Templates built around how Chase, Bank of America, Wells Fargo, and dozens of other US banks lay out their statements.
256-bit encryption in transit, and you can delete an uploaded statement whenever you want.
Nothing to install, and you can test it on a real statement before you pay anything.
Drag the PDF, scan, or photo into the box above. Password-protected PDFs work once you supply the password.
Tip: Several months at once is fine.
The AI picks out every transaction and maps each field to its own column.
Tip: Most statements finish in well under a minute.
Save the XLSX, or take the CSV if you are importing into accounting software next.
Tip: Opens in Excel, Google Sheets, or Numbers.
The same conversion covers a single month of bookkeeping and a two year loan file.
Turn a folder of client PDFs into postable ledgers without retyping a line.
Build tax and audit workpapers from multi-month statements in minutes.
Get transactions into a sheet for budgeting, expense review, and board reporting.
Give an underwriter a clean workbook instead of twenty four separate PDFs.
There is more than one way to do this, and the right one depends on how many statements you have and whether the PDF has a usable text layer. The table below is an honest read on each, including where the free options are genuinely good enough.
| Method | Works well when | Where it breaks | Time for one statement |
|---|---|---|---|
| Copy and paste from the PDF | A short statement with a simple one-line-per-transaction layout | Columns merge into one cell, amounts paste as text, page headers land mid-table | 20 to 60 minutes of cleanup |
| Excel Power Query (Data, Get Data, From PDF) | A digital PDF where the bank uses a clean, detectable table | Multi-line descriptions split across rows, some layouts are not detected as tables, scans fail entirely | 15 to 45 minutes the first time, faster on refresh |
| Adobe Acrobat export to Excel | You already pay for Acrobat and the statement is text-based | General purpose table detection, so bank-specific columns and the balance often land wrong | 10 to 30 minutes plus fixing |
| A dedicated bank statement converter | Any statement, including scans, photos, and multi-month batches | Unusual foreign layouts still deserve a spot check against the PDF | Under a minute |
If you have one clean statement and time to spend, Power Query is a perfectly reasonable free answer and it is already in Excel. The calculation changes once you are handling a year of statements, a scanned file, or several clients a month. That is the point at which a purpose-built bank statement converter stops being a convenience and starts being the cheaper option.
Worth knowing even if you end up converting instead, because it tells you quickly whether your PDF has a usable text layer. In Excel, go to the Data tab, choose Get Data, then From File, then From PDF, and pick your statement. The Navigator window lists each table Excel found. Select the one that looks like your transactions, choose Transform Data, then remove the repeated header rows, promote the real header, set the date and amount column types, and load it to the sheet.
Two things to watch. If the Navigator shows no tables, the PDF is a scan and Power Query cannot help, because it has no OCR. And if a transaction description runs onto a second line in the PDF, Power Query usually treats that second line as its own row with a blank amount, so the row count comes out higher than the number of transactions. Both are fixable by hand on one statement and impractical across twelve.
One transaction per row, with date, description, debit, credit, and running balance in separate columns and the amounts stored as numbers rather than text. That means you can sort by date, filter for a single vendor, drop a SUM under the debit column, or build a pivot table the moment the file opens, with no cleanup step in between. The same conversion also exports to CSV if the next stop is accounting software, and the running balance extraction is what lets you prove the sheet is complete rather than just plausible.
Working in Google Sheets instead? The CSV imports cleanly through File, then Import, and the bank statement to Google Sheets converter covers that route. If your workflow is CSV first, the PDF bank statement to CSV converter produces the same rows in a file you can map to any import template.
Do the same three checks every time and it takes about a minute. Compare the row count in Excel against the number of transactions on the statement. Sum the debit and credit columns and confirm that the opening balance plus credits minus debits equals the closing balance printed on the statement. Then sort by date and look for a gap where a page break fell. If all three agree, the file is complete, which is the standard an auditor or a lender applies anyway.
This is where the manual routes stop scaling. A loan file typically wants twelve or twenty four consecutive months, and a bookkeeping catch-up can run further back than that. Uploading the whole set together returns one continuous sheet in date order, with the periods already joined, so you are not merging twelve workbooks by hand and re-checking every boundary. If you need each account kept separate as well, combining bank statements in Excel covers how to structure that, and batch bank statement conversion is the route for firms running this weekly.
If the transactions are ultimately going into a ledger rather than a spreadsheet, skip a step. The QuickBooks bank statement converter produces the three column CSV QuickBooks accepts, and the Xero bank statement converter outputs the layout Xero expects for a manual import. Excel is the right destination when you need to analyze, summarize, or hand the data to someone else, and the wrong one when you just want the entries posted.
Statement layouts vary a lot between institutions, which is why generic PDF tools struggle. Per-bank pages cover the specific quirks, including Bank of America, Chase, and Wells Fargo. For a side by side look at the tools in this category, including the free ones, see the bank statement to Excel software comparison, or the deeper bank statement PDF to Excel converter page.
Upload the statement PDF to the converter at the top of this page and download the result as an .xlsx file. Every transaction lands on its own row with date, description, debit, credit, and running balance in separate columns. Digital PDFs, scans, and phone photos all work, and a typical statement finishes in under a minute.
Excel can import a PDF through Data, then Get Data, then From PDF. It works on some digital statements, but multi-line descriptions get split into separate rows, repeated page headers land inside the data, and scanned statements fail entirely because Power Query has no OCR. Check the Navigator window first: if it lists no tables, the file is an image.
Power Query is already included in Excel and costs nothing, so try it first on a single clean digital statement. BankXLSX is also free to start with no credit card, which is enough to test the output on a real statement. Free browser converters exist but often drop the running balance, so always check the file against the PDF.
Yes, but only with a tool that has OCR. A scanned or photographed statement is an image with no text to select, so copy and paste and Power Query both fail on it. Upload the scan as a PDF, JPG, PNG, HEIC, or TIFF here and it converts to the same structured Excel output as a digital PDF.
Upload the whole set together rather than one at a time. A year of statements comes back stitched into a single continuous sheet in date order, which is what a lender or an accountant asks for. This is the main reason firms move off Power Query, which handles one file per query.
Yes. The running balance from the statement is carried into its own column, so you can confirm that the opening balance plus credits minus debits equals the printed closing balance. Online transaction downloads usually drop this column, which is why they are not accepted as a substitute for the statement itself.
Date, description, debit, credit, and running balance, one transaction per row. Amounts come through as real numbers rather than text, so SUM, sorting, filtering, and pivot tables all work immediately without a cleanup pass first.
Uploads here are protected with 256-bit encryption in transit and you can delete a file at any time. Before sending a financial document to any converter, confirm that it encrypts uploads, that you can delete your data, and that it states how long files are retained. Be cautious with tools that are vague on any of those three points.
The PDF to Excel converter page, in more depth.
Compare bank statement to Excel software options.
Export to CSV for software import instead.
Merge many months into one workbook.
High-volume conversion for firms.
Cancel anytime from your account settings · refund policy
Get started converting bank statements to spreadsheets.
USD
per month
billed as
$288 yearly
Choose speed vs accuracy when extracting
| Base AI Faster | 2,500 pages |
| Pro AI Best accuracy | 500 pages |
Scale statement conversion across your team with automation.
USD
per month
billed as
$888 yearly
Choose speed vs accuracy when extracting
| Base AI Faster | 10,000 pages |
| Pro AI Best accuracy | 2,000 pages |
Enterprise-grade bank statement conversion and controls.
USD
per month
billed as
$ yearly
Choose speed vs accuracy when extracting
| Base AI Faster | pages |
| Pro AI Best accuracy | pages |
