How to convert a bank statement PDF to Excel: six methods, honestly compared

The short answer

To convert a bank statement PDF to Excel, first check whether your bank offers a CSV or Excel download for the same period, because that skips conversion entirely. If it does not, use Excel’s Data → Get Data → From File → From PDF on Microsoft 365 for Windows, Acrobat’s Export PDF if you already pay for it, or a converter built for bank statements. Whichever you use, finish by checking that opening balance plus deposits minus withdrawals equals the closing balance.

That last step is the one people skip, and it is the only one that proves the conversion is complete. A bank statement PDF to Excel conversion with a missing row looks exactly like a complete one.

Bank statement PDF to Excel: the six methods side by side

The table rates each way to convert a bank statement PDF to Excel on what matters for a statement specifically: rows spread across many pages, amounts that must be exact, and a balance that has to agree at the end. “Included” means it comes with something you may already have; it does not mean the product itself is free.

The times are rough ranges for a typical three to six page checking statement, not measurements, and they include the clean-up described later. The accuracy column is the important one: every method except the bank’s own download is reading a page layout, and layouts were designed for people, not spreadsheets.

Method 1: your bank’s own CSV or Excel download

Most US banks let you download account activity from online banking, usually as CSV and often as QFX, QIF or QBO for Quicken and QuickBooks. Chase, for example, documents spreadsheet (CSV), Quicken Web Connect (QFX), QIF and QuickBooks Web Connect (QBO) downloads from its desktop site. If the period you need is available this way, use it. The bank wrote the data, so nothing has been read off a page and nothing can be misread.

The limits are real, though, and they are why people end up converting PDFs anyway:

• History is shorter than the statement archive. Chase says statements go back up to seven years depending on the account, but activity downloads usually cover a much shorter window, and closed accounts often have statements but no download at all.
• The download is not the statement. It may include pending items, use posting rather than transaction dates, omit the running balance, or describe payees differently from the PDF. A lender, auditor or tax preparer asking for statements wants the statement figures.
• Column layouts differ between banks, and sometimes between checking and card accounts at the same bank, so a template built for one rarely fits another.
• Statements that arrive from someone else, such as a client, a tenant or a borrower, come as PDFs. You have no login to download anything.

Method 2: Excel’s Get Data → From PDF (Power Query)

Excel has a built-in PDF connector in Power Query, and it is the most capable included way to convert a bank statement PDF to Excel. Microsoft’s table of Power Query data sources by Excel version lists the PDF connector as included for Microsoft 365 subscriptions (Home, Personal, Business, Business Premium and Apps for Enterprise) on Windows, and not for the Office 2016 or Office 2019 one-time purchases. The same page’s table for Excel for Microsoft 365 for Mac has no PDF connector. Excel for the web lists PDF only among SharePoint files opened with a work account. The table does not cover Excel 2021 or 2024, so if you own one of those, look for the menu item rather than assuming. Microsoft also notes the connector needs .NET Framework 4.5 or later.

1. 1In Excel for Windows, go to Data → Get Data → From File → From PDF, choose the statement and select Import.
2. 2The Navigator lists the tables and pages Power Query found. Click through them; the transaction tables are usually the ones with a date column.
3. 3Select one transaction table and choose Transform Data rather than Load, so you can clean it before it reaches a sheet.
4. 4If the transactions came through as several tables, one per page, use Home → Append Queries to stack them, after making sure each has the same column headers.
5. 5Remove the header and summary rows Power Query kept, set the Date column type, and choose Close & Load.

For a power query bank statement PDF import, the behaviour worth knowing is in Microsoft’s Pdf.Tables documentation. A MultiPageTables option, on by default, combines similar tables on consecutive pages into one, which helps when the statement’s first and last pages look like the middle ones and fails quietly when they do not. StartPage and EndPage limit which pages are read, useful for skipping a summary page. And Microsoft states plainly that multi-line rows are not always identified, suggesting Fill Down or Group By to repair them. On a bank statement, multi-line rows are the wrapped descriptions, so expect to fix some.

• Strengths: included if you already have Microsoft 365 on Windows, the file never leaves your computer, and the same query can be pointed at next month’s statement from the same bank and refreshed, as long as the layout has not changed.
• Weaknesses: debit and credit columns can merge or shift, the year is not added to MM/DD dates, and Microsoft documents no text recognition, so treat scanned statements as out of scope.

Method 3: Adobe Acrobat’s Export PDF to Excel

Acrobat can export a PDF to an Excel workbook (.xlsx), and it is a paid feature. Adobe’s Reader help says you need a paid subscription to the Adobe Acrobat Export PDF service to convert PDFs to Word, Excel or RTF from the free Acrobat Reader. Acrobat Standard and Acrobat Pro are paid plans; as of October 2026 Adobe’s comparison page lists them at US$14.99 and US$19.99 a month on annual plans, and lists turning scanned documents into editable, searchable PDFs under Pro. Adobe also runs an online PDF to Excel page billed as free, without stating how many conversions that covers, so treat it as a one-off option rather than a workflow.

In the desktop app the path, per Adobe’s help, is All tools → Export a PDF → Microsoft Excel, with a settings icon next to the format. Those settings decide how tables are handled, and they matter more than the export itself:

• Worksheet settings: one worksheet for each table, one for each page, or a single worksheet for the whole document. For a statement, a single worksheet is usually what you want, because it keeps the rows in order across pages.
• Numeric settings: the decimal and thousands separators. On a US statement they should be a period for decimals and a comma for thousands; a mismatch turns amounts into text or wrong numbers.
• Text recognition settings: whether text in images is recognised, and in which language. This is what lets Acrobat attempt a scanned page.

Acrobat rebuilds tables from the page layout: ruled lines, column positions and spacing, so it does best on clean digital statements. The common problems are a description that wraps onto a second line becoming its own row, a page header or “continued” line landing among the transactions, and amounts with a trailing minus or CR suffix arriving as text. None of that is flagged; it has to be found.

Method 4: copy and paste a bank statement PDF into Excel, or use Google Docs

Selecting the transaction table in a PDF viewer and pasting it into Excel works for a short statement with a simple layout. More often a whole row lands in one cell. Excel’s Data → Text to Columns can split it, but descriptions contain spaces, so splitting on spaces breaks payee names apart, and fixed-width splitting only works if every page lines up exactly. Paste one page at a time and check each one, because a skipped line raises no error.

Google Sheets cannot open a PDF: Google’s list of file types Sheets can import covers Excel, OpenDocument, CSV, TXT, TSV and TAB files, and no PDF. The route people use runs through Google Docs instead. In Google Drive, right-click the PDF and choose Open with → Google Docs, and Drive converts it to an editable document, including text recognition on scanned pages. Google’s help says the file should be under 2 MB and warns that tables, columns, lists and footnotes may not be detected, which for a bank statement is the whole point. You then copy the text into Sheets and rebuild the columns.

These methods cost nothing extra, so they are the honest answer if you need to convert a PDF bank statement to Excel for free. They are reasonable for one or two statements a year. Past that, the time spent rebuilding columns and hunting missing lines costs more than any of the paid options.

Method 5: AI chatbots such as ChatGPT and Claude

Can an AI chatbot convert a bank statement PDF to Excel? Both ChatGPT and Claude accept PDF uploads and can be asked to return the transactions as a table or a CSV file. OpenAI’s file uploads FAQ says that outside ChatGPT Enterprise, PDFs use text-based retrieval, which extracts the digital text rather than embedded images, so a scanned statement uploaded as a PDF may give it little to work with. The same FAQ limits free users to three file uploads a day. Anthropic’s help says Claude reads text and visual elements in PDFs of up to 100 pages, and text only for longer ones, up to 1,000 pages.

The risk is different in kind from the other methods. A layout tool fails visibly, with a shifted column or a row in the wrong place. A language model can produce a perfectly tidy table that is missing three transactions, has two amounts transposed, or has a description reworded, and nothing about the output looks wrong. Long statements raise the risk, because the model may summarise or stop partway.

1. 1Ask for every transaction with no summarising, one row per line, and the amounts exactly as printed.
2. 2Ask for the opening balance, closing balance and the count of rows alongside the table.
3. 3Check those figures yourself against the PDF, not against the chatbot’s own statement that they agree.
4. 4Before uploading, check what your plan does with uploaded files. A statement carries account numbers, names and addresses, and client statements carry someone else’s.

Method 6: a dedicated bank statement converter

Converters that turn a bank statement PDF into Excel as their only job read the same PDF as the tools above but know what a statement is supposed to contain: an opening balance, transactions, a closing balance, and often a running balance and printed totals. That knowledge is what lets a good one check its own work. When comparing them, these are the questions that matter:

• Does it check the result against the statement’s balances and totals, and show you where a mismatch is, or only claim accuracy?
• When rows print only MM/DD, does it take the year from the statement period, including periods that cross January 1?
• Are deposits and withdrawals in one signed amount column, and are card statements signed from the cardholder’s side?
• Can you trace a row back to the line on the PDF it came from?
• Does it handle scanned statements and password-protected PDFs?
• Can it write the format you actually import, such as QBO or a Xero CSV, not just Excel?

VouchRow checks the running balance on every row where the statement prints one, page subtotals, opening balance plus movement against the closing balance, printed credit and debit totals, and the transaction count. A mismatch is shown as the dollar difference, and every row links to its line on the PDF. Upload needs an account and plans are paid, so it suits people converting statements regularly rather than once a year.

Which method should you use?

The right way to convert a bank statement PDF to Excel depends on three things: whose statement it is, how many you have, and whether the figures have to reconcile.

• Your own account, a recent period, and the bank offers a download: use the bank’s CSV or Excel export. Nothing else on this list is as reliable.
• One or two digital statements, and you have Microsoft 365 on Windows: use Get Data → From PDF, then do the clean-up below.
• You already pay for Acrobat Standard or Pro: export to a single worksheet and clean up. Not worth subscribing for this alone.
• A one-off, short, simple statement and no software: copy and paste, or Google Docs if it is scanned.
• You want a quick look at spending and exact figures do not matter: an AI chatbot is fine. For books, taxes or a loan file, verify every total.
• Client statements, many months, scanned pages, or figures that must reconcile: a dedicated converter that checks balances.

The clean-up every method needs

Whichever way you convert a bank statement PDF to Excel, the raw result needs the same five fixes before it is usable. Do them in this order, because each one makes the next easier.

1. 1Merge wrapped descriptions. A long payee often prints on two or three lines, and the extra lines arrive as rows with a description but no date and no amount. Sort is the wrong tool here because it destroys the order. Instead, add a helper column, flag rows with an empty date and amount, append their text to the description above, then filter and delete the flagged rows.
2. 2Put the amounts in one signed column. Statements print debits and credits in separate columns, or one column with a minus sign, a trailing minus, parentheses or a CR or DR suffix. For a bank account, make deposits positive and withdrawals negative: with separate columns, =C2-D2 where C is credits and D is debits. For a credit card, the convention accounting software expects is the cardholder’s view: charges, fees and interest negative, payments and refunds positive.
3. 3Give every date the right year. Many statements print 01/03 rather than 01/03/2026. Excel will assume the current year, which is wrong for last year’s statements and wrong for half of a December to January statement. Take the year from the statement period, and for a period that crosses January 1, assign the earlier year to the December rows.
4. 4Remove summary rows. Opening and closing balance lines, page subtotals, “balance forward” lines, daily balance tables and repeated column headers all look like transactions to a tool reading the layout. Delete them from the transaction list, but note the opening and closing balances first: you need them for the last step.
5. 5Check the balance. Opening balance plus the sum of the signed amount column must equal the closing balance to the cent. If the statement prints a running balance, a second column that recomputes it row by row will show exactly where a row is missing or misread.

To build it, type the opening balance in the cell above the first recomputed balance, then make each recomputed balance the one above plus that row’s amount, for example =E2+C3, copied down. A further column of printed minus recomputed balance should be zero on every line. The first non-zero value marks the row to look at. Finally, $2,450.00 plus the net movement of $41.23 gives the closing balance of $2,491.23 printed on the statement.

After the bank statement PDF is in Excel: saving it for import

Once you convert the bank statement PDF to Excel, decide where it is going. If the spreadsheet is going into accounting software rather than staying in Excel, the format matters as much as the conversion. QuickBooks, Xero and Quicken each want specific columns and date formats in a CSV, and some prefer a bank file such as QBO or OFX. Save a clean .xlsx as your working copy, then export the format your importer expects, and reconcile once more after the import against the same closing balance.