Sheetfold

How to convert a bank statement PDF to Excel

Four ways, from free and manual to automatic, what each one gets wrong, and a one-formula check that tells you whether every number came through.

Updated Oct 21, 2026 · 6 min read

The short answer: if your bank lets you export the months you need as CSV, do that; it is the bank’s own data. For PDF statements, Excel can import simple digital ones itself (Microsoft 365 on Windows), and a bank statement converter handles any layout, scans included. Whichever way you use, run the one-formula check at the end of this guide before the numbers go anywhere.

  • 1. Your bank’s export

    Best for
    Recent months, when your bank offers CSV
    Scanned PDFs
    Not needed
    Checks the numbers
    It is the bank’s own data
    Cost
    Free
  • 2. Excel: Get Data from PDF

    Best for
    Clean digital PDFs, Microsoft 365 on Windows
    Scanned PDFs
    No
    Checks the numbers
    No
    Cost
    Included with Microsoft 365
  • 3. Copy and paste, or a PDF converter

    Best for
    A one-off short statement
    Scanned PDFs
    Only with OCR
    Checks the numbers
    No
    Cost
    Free for a few files
  • 4. A bank statement converterSheetfold, for example

    Best for
    Any bank and layout, many statements
    Scanned PDFs
    Yes
    Checks the numbers
    Sheetfold checks every row against the printed balances
    Cost
    5 pages a day free with an account, then per page

1. Download the transactions from your bank

Most online banking lets you export transactions for a date range, usually as CSV, sometimes also as Excel, OFX or QIF. Look under the account’s transactions or statements for Export or Download, choose CSV, and open the file in Excel.

Two catches. Exports usually reach back only a limited time, so older months exist only as PDF statements. And an export is not the statement: it may include pending transactions, and it usually lacks the printed opening and closing balances and the totals your accountant or auditor will ask for. When you need the statement itself, or the months are too old, you are converting a PDF.

2. Use Excel’s Get Data from PDF

Excel can pull tables out of a PDF on its own, through Power Query:

  1. In Excel, open Data, then Get Data, From File, From PDF, and pick the statement.
  2. The Navigator lists every table it found, page by page. Pick the one that holds the transactions; similar tables on consecutive pages are combined by default.
  3. Choose Transform Data to clean up in Power Query: remove the header rows repeated on each page, set the date and number columns to the right types, and merge descriptions that wrapped onto a second line.
  4. Choose Close & Load to get the table into a sheet.

It works best on short, digital statements with a simple layout. It is available in Microsoft 365 on Windows, not in Excel for Mac, and in Excel for the web only for files stored in work or school OneDrive or SharePoint. It works from the text inside the PDF, so scans are out, and Microsoft’s documentation warns that rows spanning more than one line may need extra clean-up steps. On a bank statement, that is most of the descriptions.

3. Copy and paste, or a general PDF converter

Selecting the table in a PDF viewer and pasting it into Excel usually gives you one line of text per cell. Data, Text to Columns can split it, but every statement needs its own clean-up. General PDF to Excel converters, from Adobe Acrobat to the free websites, turn the page into cells more neatly, but they do not know what a statement is. Expect:

  • Descriptions on two lines split into two rows, the second one without a date or amount.
  • Money in and money out merged into one column, or shifted one column over.
  • Page headers and “balance carried forward” lines in the middle of the data.
  • Numbers stored as text, so sums come out as 0.

Fine for one short statement you are going to check by eye anyway; slow for a year of them.

4. Use a bank statement converter

A converter made for statements reads the page the way a person does: dates, descriptions, money out, money in and the running balance, with descriptions joined across lines and rows kept together across page breaks. Most read scans too. The difference between them is what happens after the reading: whether anything checks the result.

With Sheetfold:

  1. Drop the PDF on the page. Any bank, any language, digital or scanned. A password-protected statement opens with its password in your browser; if you do not know it, see bank statement passwords for Indian banks.
  2. Watch the check. Each page is read, then every row is compared with every balance the bank printed. When they all agree, the statement is marked Reconciled.
  3. If something does not add up, Sheetfold names the rows between the balances that disagree (usually just one) and shows the page beside them, so you correct a cell instead of rechecking the month.
  4. Download Excel or CSV, or a QBO, QFX or OFX file for QuickBooks, Quicken or Xero. The Excel file has a Transactions sheet and a Reconciliation sheet.
  5. Come back any time in the next 30 days. Your statements keeps every conversion with your corrections, so another format, or a copy for a colleague, costs no pages.

Your first page each day is free without an account, and a free account converts 5 pages a day.

Check the numbers, whichever way you choose

A bank statement checks itself: every row’s balance is the balance before it, plus money in, minus money out. One formula per row turns that into a test. With dates in A, descriptions in B, money out in C, money in in D and the printed balance in E, put this in F3 and fill it down:

=ROUND(E2-C3+D3-E3,2)
ADateBDescriptionCMoney outDMoney inEBalanceFCheck
2Opening balance4,210.00
302/03Rent1,450.002,760.000.00
403/03Client payment3,200.005,960.000.00
505/03Supplies321.405,647.60−9.00
608/03Software98.005,549.600.00
711/03Payroll2,400.003,149.600.00
One misread amount: 312.40 came through as 321.40. Every other row checks to 0.00; that one shows exactly how far off it is.

Every row that agrees shows 0.00. A row that does not shows the exact difference, and the amount usually says what went wrong: a difference that divides by 9 often means two swapped digits, one that equals a transaction means a missing or doubled row. Finally, compare the last balance with the closing balance printed on the statement.

If you would rather not build the check yourself, our free bank reconciliation template has it ready on its Statement sheet, and Sheetfold runs it on every statement before you download.

Questions

Can I convert a bank statement PDF to Excel for free?
Yes. Your bank’s own CSV export is free when it covers the months you need. Excel’s Get Data from PDF is included with Microsoft 365 on Windows. And a free Sheetfold account converts 5 pages a day, with every row checked.
Why are my columns mixed up after converting a PDF?
A PDF has no columns, only text placed on a page. General converters guess the columns from the positions, so descriptions that wrap onto a second line, page headers repeated in the middle of the data, and separate money-in and money-out columns often land in the wrong cells. Converters built for statements read the layout as a statement: dates, descriptions, amounts and balances.
How do I convert a scanned bank statement to Excel?
A scan is a picture of a page, so it needs a tool that reads images (OCR). Excel’s PDF import does not; most bank statement converters do, Sheetfold included. Check the result against the printed balances, because scans are where misread digits happen most.
Can ChatGPT convert a bank statement PDF to Excel?
It can produce a table from a statement, but it does not check that table against the balances the bank printed, so a misread or skipped row looks exactly like a correct one. There is also the question of what happens to the file. We cover both in our post on uploading bank statements to ChatGPT.

Try it on your own statement

Drop a PDF here and Sheetfold reads it, then checks every row against the balances your bank printed. A free account converts 5 pages a day.

or drop it here

All guides