BankToRows

PDF statement → Excel

Bank Statement to Excel

Drop a PDF statement from your online banking and get an Excel sheet with one row per transaction: date, description, money in, money out, signed amount and running balance. The rows are checked against the balances printed on the statement, so a missed or misread line shows up as a difference instead of in your books.

Converted in your browser. Your file is never uploaded.

No file handy?

Nothing uploaded

Files are read and converted in your browser, on your device.

Amounts checked to the cent

Opening + transactions = closing, and each running balance. Dates and currency are confirmed with you.

Fix before you export

Edit any date, description or amount, flip a sign, drop a line.

How to convert a bank statement to Excel

  1. 1

    Drop the PDF statement

    Download it from online banking first. Checking, savings and credit card statements all work; password-protected PDFs too.

  2. 2

    Check the balance

    Every transaction is listed with the result of the balance check. Fix anything that’s off right in the table.

  3. 3

    Download Excel

    Pick the date format you need in Export settings. Any other format is one click away too.

What people use it for

Loan and mortgage applications, tax returns, audits, expense reviews and catch-up bookkeeping: anywhere someone needs every transaction in a table with the money in and out totalled. The balance check is the part that saves a second look: a missed or misread line shows up as a difference against the printed balances.

Why not copy and paste from the PDF?

Pasting a PDF table into Excel usually gives one column of jumbled text, dates Excel can’t sort and amounts stored as text. Wrapped descriptions split across rows, and on multi-page statements the headers and page numbers land in the middle of your data. The converter rebuilds each row from where the text sits on the page, joins wrapped lines, and skips page headers and totals.

What you get in the workbook

Dates are real Excel dates in the order you choose, amounts are numbers with two decimals, and the header row is frozen with filter buttons on. Money in and money out have their own columns, next to a signed Amount column ready for SUM and pivot tables.

The formats

PDF statement
The statement your bank lets you download from online banking. It looks like a table but is really text placed at positions on a page, which is why copying it into a spreadsheet goes wrong. Scanned paper statements are pictures of text and need OCR, which BankToRows doesn’t do yet.
Excel
An Excel workbook (.xlsx) with real dates and numbers, so sorting, filters, SUM and pivot tables work straight away. It also opens in Google Sheets, Numbers and LibreOffice.

Related converters

Bank statement converterBank statement to CSVPDF statement to QBOPDF statement to QIFQBO to ExcelQFX to ExcelQIF to Excel

Bank Statement to Excel: FAQ

Which banks does it work with?

There’s no list of bank templates: it reads the transaction table on any text-based statement, the kind you download from online banking. Checking, savings and credit card statements work, with US, UK, Canadian and Australian date and amount formats.

What if my statement is a scan?

A scanned paper statement is a picture with no text to read, so it isn’t supported yet. A quick test: if you can select words in your PDF viewer, the file will work.

What does the balance check mean?

Statements print an opening balance, a closing balance and often a running balance. After reading the transactions, the converter adds them up and compares: opening + money in − money out must equal closing, and each printed running balance must follow from the one before. A green check means everything adds up to the cent; anything else is shown with the rows to look at. It’s a check of the totals, not a guarantee: two mistakes that cancel out (a missed +100 and a missed −100) still add up, which is less likely when the statement prints a running balance on every line.

Is my file uploaded anywhere?

No. The conversion runs in your browser: the file is read on your device and the download is built there too. It never reaches our server, so we can’t see it, keep it or lose it.

Is it free?

Yes, while BankToRows is in beta: no sign-up and no page limits.

Last updated October 2026