Your bank sends you a statement as a PDF. But your bookkeeper, your tax helper or your own budget sheet needs it in Excel. Typing every line by hand takes ages, and one wrong number can throw off the whole month.
This guide shows you two ways to do it. The first uses Excel itself and costs nothing if you already have Excel. The second uses MyBankToExcel, which turns a bank statement PDF into a file Excel can open.
Before you start: is your PDF real text or a picture?
Open your statement and try to highlight a word with your mouse.
- If the words highlight, the PDF has real text. Both methods below can work.
- If you can only draw a box, your statement is a scanned picture. Excel can't read it. Excel can't read it, and MyBankToExcel can't either. You'll need a tool that reads scanned pages.
Method 1: Use Excel's own PDF import (free, Windows only)
Newer versions of Excel for Windows (Microsoft 365) can open a PDF. Excel for Mac and Excel on the web don't have this option.
- Open a blank Excel workbook.
- Click the Data tab at the top.
- Click Get Data, then From File, then From PDF. If you don't see "From PDF," your version of Excel doesn't have it.
- Pick your statement and click Import.
- A window shows a list called Table001, Table002, Page001 and so on. Click each one to preview it. Find the one that shows your transactions.
- Click Transform Data (not Load). This lets you tidy it first.
- Delete rows that aren't transactions, like page numbers or the bank's address.
- Rename the columns to Date, Description, Money Out, Money In and Balance.
- Click Close & Load. Your transactions now sit in a sheet.
The honest catch: bank statements don't have lines between the rows. So Excel often joins a description with an amount, or splits one purchase across two rows. Headers that repeat on each page can show up in the middle of your data. For a short, simple statement it can be fine. For long ones, expect to do some clean-up.
Method 2: Use MyBankToExcel (fastest)
MyBankToExcel is made for bank statements, so it knows that a long description belongs to one line and that the header on page 3 is not a purchase.
- Go to tools.ltd/my-bank-to-excel.
- Click the big button and choose your bank statement PDF.
- Wait a moment while it reads your statement. You see the first rows for free.
- Pick the file for Excel. It is a CSV file, which Excel and Google Sheets open. (QuickBooks and Quicken files are in More options.)
- Download your file and open it in Excel.
Each transaction is on its own row, with the date, description and amount in their own columns. Your PDF is read right in your browser. It never leaves your device.
Step 3 for everyone: check the numbers add up
Whichever way you choose, do this quick check. It catches almost every mistake.
- Find the starting balance on your statement.
- In Excel, add up all the money that came in.
- Add up all the money that went out.
- Do this sum: starting balance + money in − money out.
- Your answer should match the ending balance printed on the statement, to the penny.
If it doesn't match, look for a missing row, a row that appears twice, or an amount in the wrong column.
Tips to make life easier
- Keep one file per month. Name them like "Checking 2026-01" so they sort in order.
- Don't change the original PDF. Keep it as your record in case you need to check later.
- Remove private details before sharing. If you're sending a statement to someone else, like a landlord, you can hide your account number first with TrueRedact.
- Got a different kind of table? For price lists, reports and other PDF tables that aren't bank statements, try Sheetsnap instead.
When to use which method
| Your situation | Best choice |
|---|---|
| Short, simple statement, Excel for Windows | Excel's PDF import |
| Mac or Excel on the web (text PDF) | MyBankToExcel |
| Long statement or many months | MyBankToExcel |
| Need a QuickBooks file | MyBankToExcel |
Why a statement might not convert
Most problems come from the PDF, not from you. Here is what to look for.
- It is a scan or a photo. MyBankToExcel reads the words in the PDF. A scan is only a picture, so there is nothing to read. Ask your bank for a PDF you download from online banking.
- It has a password. Remove the password first, then try again.
- The table has no labels. Each table needs a row at the top with words like Date and Amount. Without that row, we can't tell which numbers go where.
- The dates could go two ways. A date like 03/04 could be March 4 or April 3. If the statement doesn't make it clear, we read it as month first and tell you.
- Numbers in brackets. A number like (86.14) means money going out. It shows as -86.14 in your file.
Want a plain CSV file? Pick CSV when you download. Excel opens it right away.
Frequently asked questions
Can I just copy and paste my bank statement into Excel?
You can try, but the columns usually get mixed up. Dates, descriptions and amounts often land in one cell. A converter keeps each part in its own column.
My statement is a scan. Will this work?
Excel and MyBankToExcel cannot read scanned pages. If you can't highlight the words in your PDF, it is a picture, and you will need a tool that can read scanned text.
How do I know nothing was missed?
Take the starting balance, add the money in, and take away the money out. The answer should match the ending balance on the statement.
Is my bank statement kept?
No. MyBankToExcel reads the PDF in your browser, so your file never leaves your device. Read the privacy page for the details. If you have questions, email support@tools.ltd.
Related guides: Import a bank statement into QuickBooks · Convert a PDF table to Excel · More bank statement guides