1. 1Choose your files
  2. 2Check the result
  3. 3Download Excel

Bank statement to Excel converter

Choose a PDF statement from your bank. You get an Excel file with one row per transaction, and every running balance is added up and checked. The file is read by your browser and never uploaded.

Drag your files here

or

PDF, scans and photos, Word, Excel and CSV. Several files or a whole folder at once.

Up to 100 MB each. The files stay on this computer.

What's in the file? We usually tell by ourselves.
No PDF at hand?

The file is read by your browser and never uploaded.

01How it works

How to convert a bank statement to Excel

  1. 01

    Choose the PDF

    Drag the statement onto this page or press “Choose a PDF”. Statements downloaded from online banking work best.

  2. 02

    Check the preview

    Each transaction appears with its date, description, money in, money out and balance. A green banner means the balances add up; yellow rows need a look.

  3. 03

    Download Excel

    The .xlsx file opens in Excel, Google Sheets, LibreOffice and Numbers. Amounts are real numbers and dates are real dates.

02The result

What the Excel file looks like

The Transactions sheet has one row per transaction. The Check column is a live formula: it compares the previous balance plus money in minus money out with the balance on the statement. A Summary sheet adds up the totals.

DateDescriptionMoney outMoney inBalanceCheck
01 Oct 2026Card payment Green Leaf Grocers54.202,395.80OK
01 Oct 2026Salary Harbour Design Ltd3,200.005,595.80OK
02 Oct 2026Direct debit City Energy96.405,499.40OK
Example from the sample statement. If your statement has a reference or cheque number column, it is kept as its own column.

03What it reads

Statements it understands

  • Separate money in and money out columns, a single amount column with + and − signs, or amounts marked Cr and Dr
  • A running balance in its own column, including overdrawn balances shown as negative, OD or Dr
  • Number formats such as 1,234.56, 1.234,56, 1 234,56, 1'234.56, 1,23,456.78 and (45.10)
  • Dates such as 31/12/2026, 12/31/2026, 31.12.26, 2026-12-31 and 31 Dec 2026, also dates printed without a year
  • Statements that list the newest transactions first: rows are put in date order
  • Descriptions that run over two or more lines, and days where the date is printed only once
  • Password-protected PDFs: type the password, it is used on your computer only

04Good to know

Every balance is checked

Most statements print the balance after each transaction. Tidysheet takes the previous balance, adds money in, subtracts money out and compares the result with the bank's figure. If one printed balance is off, exactly that row is highlighted in yellow, on the page and in the Excel file. When a statement has no balance column, the totals are compared with the totals printed on the statement.

Your statement stays on your computer

The conversion runs in your browser without uploading your PDF. Optional recovery keeps a temporary local copy for up to two hours. You can turn it off or clear the file and result. Read the privacy policy.

What to check

Scans and photos can be recognised in your browser. Recognition may misread digits: compare amounts and rows with the original. A PDF with real text from online banking is usually more accurate than a scan.

05Questions

Questions about converting bank statements

Is the bank statement converter free?

Yes. There is no sign-up, no trial and no limit on files or pages. The conversion runs in your browser, so it costs very little to offer.

Which banks does it work with?

It reads the layout of the statement rather than a list of known banks, so it works with most statements downloaded as PDF from online banking. The balance check shows you if anything was read incorrectly.

Can I convert a password-protected statement?

Yes. When the PDF asks for a password, type it in. It is used on your computer to open the file and is never sent anywhere. See where to find the password.

What if the totals don't match?

The rows that don't fit are highlighted in yellow. Usually one line was printed in an unusual way. Compare it with your PDF, correct it in Excel, and the Check formula updates itself.

Can I get CSV instead of Excel?

Yes. Press “Download CSV”, or use the bank statement to CSV page, where CSV is the main download.

Does it work for credit card statements?

Yes. On a card statement the balance is what you owe, so purchases increase it and payments reduce it. Tidysheet detects this. More on the credit card statement page.

06Also useful

More converters and guides