Banks usually send statements as PDFs because they are fixed, printable records. The moment you want to total expenses, reconcile invoices or prepare a tax return, though, you need the transactions in a spreadsheet. There are four common ways to get there.
1. Copy and paste
Select the transaction table in a PDF viewer, copy it and paste it into Excel. This can work for a handful of rows, but it rarely survives a full statement:
- Rows often paste into a single column, with each value on its own line.
- Descriptions that wrap over two lines become two separate rows.
- Amounts arrive as text, so
SUMreturns zero until you convert them. - Page headers and footers end up in the middle of your data.
Use it only for quick look-ups of a few transactions.
2. Excel’s built-in PDF import
Recent versions of Excel for Windows with Microsoft 365 can import tables from a PDF via Data → Get Data → From File → From PDF. Power Query then shows the tables it found on each page. This works well when a statement uses clearly ruled tables, but you typically have to combine a table per page, promote headers, remove repeated heading rows and fix data types yourself. It is also not available in every edition of Excel.
3. Ask your bank for a CSV or Excel export
Many online banking services let you download recent transactions as CSV, OFX or Excel. If yours does, this is the most accurate route because the data comes straight from the bank’s system. The limitations are that exports often only go back a limited time, and they are not always accepted where an official statement is required. See PDF vs CSV bank statements for more on the differences.
4. Use a bank statement converter
A dedicated converter reads the statement’s layout and rebuilds the transaction table for you. With FinParse the steps are:
- Open the converter and drop in your PDF statement.
- Wait a few seconds while each page is read in your browser.
- Review the table: check the summary totals and any rows marked for review.
- Edit or add rows if needed, then click Download Excel.
Because FinParse runs entirely in the browser, the statement is not uploaded anywhere – a meaningful difference from converters that process files on their servers.
How to check the converted data
Whichever method you use, verify the result before relying on it:
- Count the rows. Compare the number of transactions with the statement. Many statements print a count or you can check one page.
- Check the totals. Total debits and total credits should match the statement summary if it has one.
- Reconcile the balance. Opening balance + total credits − total debits should equal the closing balance.
- Spot-check dates. Make sure day and month have not been swapped, especially for dates up to the 12th of the month.
Once the data is in Excel, the next step is usually tidying it up. Our guide to cleaning bank statement data in Excel covers categories, monthly summaries and common fixes.