Bank statement PDF to Excel

Most banks and card issuers still send statements as PDFs. If you need a bank statement PDF to Excel conversion for bookkeeping, a budget, an expense report or a tax folder, you can upload the statement to pdf2rows and download the transaction table as an XLSX workbook or CSV. Here's how to do it and what to double-check before you rely on the numbers.

Open the converter, free for 5 pages a day

How to convert a bank statement PDF to Excel

Download the statement from your bank's website or app. Use the original PDF, not a photo or a scan.
Upload it in the converter.
In the preview, confirm that the date, description, amount and balance columns line up. Statements usually have a summary box plus the transaction list, and they show up as separate tables.
Download XLSX for a spreadsheet, or CSV if you're importing into accounting or budgeting software.

Checks to do after converting a statement

Wrapped descriptions: some banks print long merchant descriptions on two lines. The second line can appear as its own row with only a description. Merge it into the row above or delete it.
Debits and credits: statements show money out either as a separate column, with a minus sign, or in parentheses. In the XLSX, (45.00) becomes -45 and 1,200.00 becomes 1200, so you can sum a column directly.
Reconcile the balance: compare the opening and closing balance printed on the statement with the opening balance plus the SUM of the amount column. If they match, nothing was dropped.
Page breaks: a statement that runs over several pages gives one table per page. Use All tables on one sheet and delete the repeated header rows. See convert PDF tables to a spreadsheet for step-by-step instructions.
Dates: dates are kept as printed (for example 10/03). Add the year and convert them to real dates if your software needs it.

Statement layouts that work best

Downloaded statements from online banking almost always have a text layer and regular columns, and those convert well. Layouts with ruling lines are the most reliable. Space-aligned layouts are handled by a row parser and usually come out right, but check the preview. Paper statements you scanned yourself won't work until OCR support is added.

Privacy for financial documents

Statements contain sensitive information. pdf2rows deletes the PDF as soon as the conversion finishes and keeps no copy of your file or the extracted transactions. Before sharing the downloaded spreadsheet with anyone, remove account numbers and anything else you don't need to share. See the privacy page for how data is handled.

Excel or CSV for statements?

Use XLSX if you're going to review, categorize or chart the transactions yourself. Use CSV if you're importing them into bookkeeping or budgeting software, since most of those tools accept CSV imports. Details are in PDF to CSV online.

Current limitations

Scanned PDFs: pages that are just images have no text layer, and OCR is not supported yet. If you can't select the text in your PDF viewer, the converter won't find it either.
Password-protected PDFs: remove the password first (you need to know it).
Complex layouts: merged cells, rotated text and nested tables may need a quick cleanup after download.
Size: up to 20 MB per file. The free plan converts 5 pages per day; Pro ($9/month, 7-day free trial) removes the daily limit.

Frequently asked questions

Does it work with every bank?

It works with statements that have a text layer and a regular column layout, which covers most statements downloaded from online banking. Layouts vary, so always check the preview.

Can I convert a year of statements?

Yes, one PDF at a time. The free plan covers 5 pages a day, and Pro ($9/month, 7-day free trial) removes the daily limit.

Are credit card statements supported?

Yes. They work the same way as bank statements, as long as the PDF has selectable text.

Is this financial or tax advice?

No. pdf2rows is a file conversion tool. Always check converted figures against your original statement.