Bank statement PDF to Excel: 4 ways compared

Before you start: ask your bank for a spreadsheet

Most online banking lets you download recent transactions as CSV or Excel, usually from the account’s transactions page under Download or Export. That file comes straight from the bank’s records, so it is cleaner than anything made from a PDF. If you can get it, use it and skip the rest of this guide.

The PDF is what you are left with when:

• the months you need are older than the bank’s download allows,
• the account is closed and only statements remain,
• someone else sent you their statements, as clients do to bookkeepers,
• or your bank simply doesn’t offer a spreadsheet download.

The four ways at a glance

Now each one in detail, with the steps and the catches.

Way 1: Excel’s Get Data from PDF

Excel for Windows can pull the tables out of a PDF with its Power Query tool. Microsoft added it in 2020 for Microsoft 365 subscribers. Excel for Mac doesn’t have it, and it doesn’t work on scanned PDFs, because it needs real text in the file.

1. Open a blank workbook and go to Data › Get Data › From File › From PDF.
2. Pick the statement. The Navigator lists everything it found: tables (Table001, Table002…) and whole pages (Page001…).
3. Click the tables that hold transactions. To take several, tick Select multiple items. Then choose Transform Data, not Load.
4. In the Power Query Editor, use Append Queries to stack the pages into one table, then Use First Row as Headers.
5. Remove the repeated header rows and page totals that came in with each page, and set the date and amount columns to the right types.
6. Close & Load to put the result on a sheet.

What tends to go wrong

• A description that wraps onto a second line becomes a separate row with no date or amount. Microsoft’s own documentation mentions multi-line rows as a known limit.
• Each page is a new table, sometimes with columns in a different order, so stacking them takes care.
• Amounts with commas, currency signs or CR/DR markers arrive as text.
• Opening and closing balance lines, page subtotals and bank footers mix in with transactions.

Good for: a short, simply laid-out statement, on Windows, when you would rather the file never left your computer and don’t mind some cleanup.

Way 2: ChatGPT or another AI chat

Upload the PDF to ChatGPT (or Claude, Gemini, Copilot) and ask for a spreadsheet. For a short statement it is often the fastest way. A prompt that asks for a check makes problems easier to spot:

This PDF is my bank statement. Turn every transaction into a table with
these columns: Date, Description, Money out, Money in, Balance.
Keep every row, in the same order, and don't change any amount.
Then check: does the opening balance plus money in minus money out
equal the closing balance? Tell me the row count and the result.

Two things to know before you use it on real statements.

Your statement leaves your computer

The PDF is uploaded to the AI company’s servers. OpenAI’s help centre says it may use content from its personal plans, ChatGPT included, to train its models unless you turn off Improve the model for everyone in Settings › Data controls. Temporary chats aren’t used for training, and business plans aren’t by default. A bank statement shows your account number, your employer, your landlord and where you spend money, so decide whether you are comfortable with that first.

It can change rows without telling you

A language model writes out the table it thinks it sees. On a long or crowded statement it can skip a row, merge two, or misread a figure, and the answer still looks tidy and confident. It may even say the balance checks out when it doesn’t. So check the result yourself with the formulas in the check section below, every time.

Good for: a one-off, short statement you don’t mind uploading, when you will check the totals afterwards.

Way 3: Google Docs, then Google Sheets

Google Sheets can’t read a PDF, but Google Docs can turn one into text, and you can paste that into Sheets.

1. Upload the PDF to Google Drive. Google’s help says the file should be 2 MB or smaller.
2. Right-click it and choose Open with › Google Docs. Drive reads the text, scans included.
3. Copy the transaction lines and paste them into a sheet.
4. Select the column and use Data › Split text to columns, then fix what didn’t split cleanly.

The catch is in Google’s own help: bold, fonts and line breaks are likely to survive, but tables and columns are not likely to be detected. You get the words in roughly the right order, then do the table work by hand.

Good for: a short statement when you have no Excel and no other option, and time to tidy it.

Way 4: A bank statement converter

A bank statement converter is made for one layout: dates, descriptions, money out, money in and a running balance. It finds that table on every page, joins descriptions that wrap onto two lines, and gives you one clean spreadsheet. Many can also write files for QuickBooks, Xero or Quicken.

They differ in two ways that matter, so check both before you choose one:

• Where the work happens. Many online converters upload your PDF to their servers. Ours runs in your browser and never uploads it; here is how, and how to check. Our comparison of six converters lists where each one sends your file.
• Whether it checks itself. Ours adds up every row against the statement’s running balance and its opening and closing balances, and shows you the row to look at if anything is off. It never changes a number to make it add up.

2 statements a day are free with no sign-up, up to 20 pages each. Bank and savings statements are supported; credit card statements aren’t yet. Scanned statements and many statements at once are on the paid plans. Try it here:

Check the result, whichever way you used

A bank statement has a rule that always holds, and it makes any conversion easy to test. In plain words: what you started with, plus what came in, minus what went out, is what you ended with.

Opening balance + SUM(money in) − SUM(money out) = closing balance

Put the four numbers side by side in Excel. If the two sides differ, something is missing or misread. The difference often tells you what: a gap equal to one transaction’s amount usually means that row was dropped, and twice an amount usually means its sign got flipped.

Find the exact row

If your sheet has a running balance column, you can check every row. With dates in column A, money out in D, money in in E and the balance in F, starting on row 2 (the layout our converter’s Excel file uses), type this in G3 and fill it down:

=IF(ROUND(F2+E3-D3-F3,2)=0,"OK","CHECK")

Each row should say OK. The first CHECK points to the row that went wrong, or to the one just before it. Our free reconciliation template has a sheet that does all of this for you: paste the rows in and it marks any that don’t add up.

Which one should you use?

• Your bank offers a CSV or Excel download: use it. Nothing beats the bank’s own data.
• One simple statement, Excel on Windows, and you want it to stay on your computer: Excel’s Get Data, with some cleanup.
• A short statement you don’t mind uploading: ChatGPT, then check the totals.
• Statements every month, long ones, or ones you would rather not upload: a converter that runs in your browser and checks the balances.
• You really want the transactions in QuickBooks or Xero: skip Excel. See how to import into QuickBooks Online, QuickBooks Desktop or Xero.

Questions

Sources

Read on 6 October 2026. Software changes its menus often; if a step here no longer matches what you see, please tell us at hello@safebankstatementconverter.com and we will fix it.

1. Microsoft Excel blog (2020): Announcing data import from PDF documents
2. Microsoft Learn: Power Query PDF connector (limits and multi-line rows)
3. Microsoft Q&A: Get Data from PDF missing in Excel for Mac
4. OpenAI Help: How your data is used to improve model performance
5. Google Drive Help: Convert PDF and photo files to text
6. Safe Bank Statement Converter: How it works (check the Network tab yourself)