Bank Statement Converter
Turn a PDF bank statement into a spreadsheet. Drop in the PDF, fix anything that looks off, and download a CSV that opens in Excel or Google Sheets. Then it does what most converters skip: it checks that the opening balance plus every transaction equals the closing balance.
Drop your bank statement PDF here
or
No statement handy?
Your statement is read by code running in this browser tab. It’s never uploaded, sent or saved anywhere.
Can’t parse your bank? Use this Claude prompt
Statement-to-CSV prompt
Attach your statement (PDF or screenshots) in Claude, paste this prompt, then copy Claude’s answer into the tab above. Claude reads the rows; this page’s code checks that they add up.
Using Claude means your statement is sent to Anthropic, unlike this page. If that matters to you, black out account numbers first.
How to convert a bank statement to Excel or CSV
- Get the PDF from your bank. Log in to online banking and download the statement as a PDF. A downloaded PDF works better than a scan or a photo.
- Drop it into the converter. It finds each line that starts with a date and ends with an amount, joins descriptions that wrap onto a second line, and works out the year from the statement period.
- Look at the math check. Green means the opening balance plus all the transactions equals the closing balance, and every printed running balance matches. Amber points you to the rows that don’t add up.
- Fix what needs fixing. Click any cell to edit it, use In/Out to flip a row that’s going the wrong way, delete rows that aren’t transactions, or add one that was missed. The check updates as you type.
- Download the CSV. Pick ISO dates (2026-03-02, best for sorting) or dates as printed, then click Download CSV.
If the PDF won’t read, open it, select all the text, copy it and use the Paste text tab. If that doesn’t work either, use the Claude prompt above and paste Claude’s CSV into Check a CSV.
How to open the CSV in Excel or Google Sheets
Excel
Double-click the file. The CSV is saved as UTF-8 with a byte order mark, which tells Excel how to read it, so symbols and accented names come through correctly. If anything still looks garbled, open a blank workbook and use Data > Get Data > From Text/CSV and choose UTF-8. To keep it as a normal workbook, use File > Save As > Excel Workbook (.xlsx).
Google Sheets
Open a new sheet, go to File > Import > Upload, choose the CSV, and pick “Replace current sheet” or “Insert new sheet”.
What the columns mean
- Withdrawal and Deposit are positive numbers in separate columns, the way most statements print them.
- Amount is the same money as one signed number: negative for money out, positive for money in. Use this column for totals, pivot tables and budgets.
- Balance is the running balance printed on the statement, where there is one.
Want to total spending by category or month once it’s in a spreadsheet? The Excel formula generator writes SUMIFS and pivot-ready formulas in plain English.
Why it checks the math: AI reads, code calculates
Pulling rows out of a messy PDF is a reading job, and reading is something AI tools like Claude are good at. Adding up a column of numbers is a different kind of job. Language models predict text, so they can drop a row, misread a digit or quietly get a total wrong, and they sound just as sure either way. We explain why in why AI is bad at math.
So this page splits the work. The converter, or Claude if you use the prompt, pulls the rows out. Then plain code does the arithmetic in whole cents: opening balance plus money in minus money out must equal the closing balance, and each printed running balance must equal the one before it plus the rows in between. If one digit was misread, the check turns amber and points to the row. That’s the habit worth keeping whenever AI touches numbers: let it read, then let code (or a spreadsheet formula) do the math.
Limits
- Scanned statements need OCR. A scan or photo has no text in it, and this tool doesn’t include OCR. Download the PDF from your bank instead, or use the Claude prompt.
- Every bank is different. The converter handles common US layouts, but unusual ones (several accounts on one page, foreign date formats, tables that run sideways) may need fixes or the Claude prompt.
- Money in or out is sometimes a guess. When a statement doesn’t mark it with a column, a minus sign or a running balance, the row is labeled as guessed. Check those rows.
- Password-protected PDFs need to be saved again without the password first (open it, then Print > Save as PDF).
- Always check the totals. A green check means the numbers agree with each other and with the statement’s balances. It doesn’t mean every description or date is right, so skim the table before you rely on it for taxes or bookkeeping.
More for your finances
Once your transactions are in a spreadsheet, see how to use Claude for personal finance to sort spending into categories and build a budget, and how to set up Claude for Excel to work inside the workbook. For formulas you can trust, try the Excel formula generator. New to Claude? Start with the free Claude course.
Frequently asked questions
How do I convert a bank statement PDF to Excel?
Download the statement from your bank as a PDF, drop it into the converter on this page, and check the rows it finds. Fix anything that looks wrong, make sure the math check is green, then click Download CSV. Double-click the CSV to open it in Excel, or in Google Sheets go to File > Import and upload it. You get Date, Description, Withdrawal, Deposit, Amount and Balance columns, ready to sort, filter and total.
Is it safe to upload my bank statement to a converter?
With this one, nothing is uploaded. The PDF is opened and read by code running in your own browser tab, and the CSV is built there too. Your statement never leaves your computer, and nothing is saved. Many other online converters do upload your file to their servers, so check their privacy terms before you use one. If you use the Claude prompt on this page instead, your statement does go to Anthropic, so black out account numbers first if that matters to you.
Why doesn’t my scanned statement work?
A scanned or photographed statement is a picture of text, not actual text, so there’s nothing for the converter to read. Turning a picture into text needs OCR (optical character recognition), which this tool doesn’t include. The simplest fix is to download the statement again from your bank’s website, since those PDFs usually contain real text. Otherwise, give the scan to Claude with the prompt on this page and paste its CSV back here so the totals still get checked.
Does it work with my bank?
It reads many US statements: lines that start with a date (like 03/05, 03/05/2026, Mar 5 or 5 Mar), then a description, then amounts, with either one signed amount column or separate withdrawal and deposit columns, with or without a running balance. Every bank lays out its statements differently, though, so always look at the math check. If it can’t find your rows, try the Paste text tab or the Claude prompt.
Can I convert a bank statement to Excel for free?
Yes. This converter is free, has no sign-up and no page limit, and runs in your browser. It saves a CSV file with a UTF-8 byte order mark, which Excel opens correctly with a double-click. If you need a real .xlsx workbook, open the CSV in Excel and use File > Save As > Excel Workbook.