How to convert PDF bank and credit card statements to Excel
For bookkeepers, lenders and finance teams: the ways to get a bank or credit card statement into Excel, where each one breaks, and a step-by-step walkthrough in Docsumo.
Key takeaways
- To convert a PDF bank statement to Excel, copy and paste the rows, use a PDF converter such as Excel's Power Query, or use document AI. Which one works depends on whether the PDF holds text or is a scan, and on how many banks you see.
- Excel's Power Query imports tables from text-based PDFs, but a scanned statement comes back empty until it has been through OCR.
- For your own accounts, download a CSV file from online banking instead. Conversion is for statements you only have as PDFs, such as a borrower's or a client's.
- After converting, check the math: opening balance plus deposits minus withdrawals should equal the closing balance.
- Credit card statements convert the same way, with a different balance summary to check.
On this page
To convert a PDF bank statement to Excel, copy and paste the transactions, use a PDF converter (Excel's own Power Query is one), or use document AI that reads any bank's layout, scans included. Copying works for a page or two, converters suit the layouts they handle well (Power Query reads text-based PDFs only), and document AI is for scans, many banks and monthly volume. If the statement is for your own account, skip the PDF: many banks and card issuers let you download transactions as a CSV file.
| Field | Extracted value | Confidence |
|---|---|---|
| Account holder | Harbor Street Bakery LLC | |
| Address | 118 Harbor St, Portland, ME | |
| Bank name | First Midwest Bank | |
| Account number | •••• 4821 | |
| Account type | Business checking | |
| Statement period | 2026-07-01 → 2026-07-31 |
| Field | Extracted value | Confidence |
|---|---|---|
| Opening balance | 42,180.55 | |
| Total deposits | 88,412.10 | |
| Total withdrawals | 91,686.44 | |
| Closing balance | 38,906.21 | |
| Transaction count | 142 |
| Field | Extracted value | Confidence |
|---|---|---|
| Date | 2026-07-14 | |
| Description | ACH DEPOSIT STRIPE PAYOUT | |
| Amount | +3,284.10 | |
| Debit / credit | Credit | |
| Running balance | 51,902.44 | |
| Category | Card processor payout |
Ways to convert a bank statement to Excel, compared#
Two things decide which method works: whether the PDF holds real text or is a scan (if you can select or search its text, it holds text), and how many different banks you see.
| Method | Works on | Where it breaks |
|---|---|---|
| Copy and paste | A page or two from a text-based PDF | Columns land in one cell, every page is manual, and typos go unnoticed |
| Excel's Power Query | Text-based PDFs (in Excel for Windows: Data > Get Data > From File > From PDF) | Scans come back empty, and rows that wrap onto two lines need cleaning up |
| PDF converters and template OCR | Statements in layouts the tool knows or has a template for | A new or redesigned layout can need a new template, and results on poor scans vary |
| Document AI (OCR plus AI extraction) | Scans, photos and any bank's layout, at volume | Needs a pilot on your own statements, and unsure values still go to a person |
Microsoft's documentation notes that Power Query may not identify rows that run onto a second line, which then need cleaning up. A Microsoft moderator explains why scans fail: an image-only PDF gives it no text to read, so the import comes back empty. For converters and extraction platforms side by side, see the best bank statement extraction software.
What to look for in bank statement to Excel software#
Test any tool on your own worst statements before you pay for it. These are the differences that show up.
Reads scans, not just digital PDFs
Try a phone photo and an old scan, not only a clean bank download.Keeps the table whole
Wrapped descriptions and tables that cross pages come out as one row per transaction.Checks the math
Balances are reconciled before you download, so a dropped row is caught.Shows what it's unsure about
Low-confidence values are flagged with their source line, not quietly guessed.Exports what you use
Excel, CSV or an API, depending on where the data goes next.
How to convert a PDF bank statement to Excel with Docsumo#
Docsumo is an intelligent document processing (IDP) platform. Its bank statement extraction reads statements with pre-trained models, so there's no template to build for each bank, and the result downloads to Excel. It runs in the cloud and isn't a desktop tool for editing PDFs or making searchable files.
- Start a free trialSign up with a work email. The trial runs 14 days and covers up to 1,000 pages.
- Upload statementsAdd PDFs, scans or phone photos. Remove passwords from protected PDFs first.
- Let it extractThe pre-trained model reads the account details, balances and every transaction, and joins tables that run across pages into one table.
- Review what's flaggedFields the model is unsure about wait for a person. Click one to see its source line on the page; your corrections improve the model.
- Check the balancesRunning balances are checked against every transaction, so a missed or misread row shows up before you export.
- Download to ExcelDownload the data as an Excel file, or send it to other software through the API and webhooks.
Before and after you convert#
- Remove the passwordPassword-protected statements have to be saved without the password, or downloaded again unprotected, before any tool can read them.
- Get every page, flat and in focusCheck the page count ("page 3 of 6") and the period. A missing page means missing transactions, and a skewed or blurred scan means misread digits.
- Check the totals in ExcelOpening balance plus deposits minus withdrawals should equal the closing balance. Add a column that recalculates the running balance: the first row where it stops matching the statement is the row that went wrong.
- Protect the fileThe spreadsheet holds account numbers and every transaction. Keep it where only the people who need it can open it.
How to convert a credit card statement to Excel#
A credit card statement has the same parts as a bank statement, with a different summary to check. Under the CFPB's Regulation Z, a card statement shows the previous balance, each transaction, payments and credits, interest and fees, the closing date and new balance, and the payment due date.
| Part | Bank statement | Credit card statement |
|---|---|---|
| Header | Bank, account holder, account number, statement period | Issuer, cardholder, account number, billing cycle closing date |
| Summary | Opening and closing balance, total deposits and withdrawals | Previous balance, payments and credits, new charges, interest and fees, new balance |
| The check | Opening balance + deposits − withdrawals = closing balance | Previous balance − payments and credits + charges, interest and fees = new balance |
For your own card, download before you convert. American Express, for example, lets cardholders download recent activity and the past six billing statements as a CSV file or for Quicken and QuickBooks. For card statements you only have as PDFs, such as employees' or clients', the methods above work the same way. Docsumo reads them too: it handles any document type, not only the 250+ it has pre-trained models for.
The bottom line#
For one or two statements, copy and paste or Excel's PDF import is enough. For scans, many banks or a monthly stream of statements, use document AI that rebuilds the transaction table, checks the balances and sends unsure values to a person before the download. Either way, check that the totals add up before anyone relies on the spreadsheet. Lenders can see how this fits a wider lending workflow.
Book a demo with a few of your own statements, or start a free trial.
Frequently asked questions#
How do I convert a PDF bank statement to Excel?
In Excel for Windows, choose Data > Get Data > From File > From PDF and pick the transaction table; that works for text-based PDFs. For scans, or statements from many banks, use document AI, which reads the page, rebuilds the transaction table and downloads it to Excel. Copy and paste is fine for a page or two.
Can I convert a scanned bank statement to Excel?
Yes, but it needs OCR first. Excel's PDF import reads only PDFs that contain text, so a scan comes back empty. Document AI tools read scans and photos and send any value they're unsure about to a person to check.
How can I convert bank statements to Excel for free?
If it's your own account, download the transactions as a CSV file from online banking and open it in Excel. For a text-based PDF, Excel's own PDF import costs nothing extra. Docsumo's free trial covers 14 days and up to 1,000 pages, scans included.
How do I download a credit card statement into Excel?
Log in to your card account and look for a download option for activity or statements. American Express, for example, offers recent activity and the past six billing statements as a CSV file or for Quicken and QuickBooks. For a PDF statement, convert it the same way as a bank statement.
Is it safe to upload bank statements to a converter?
Check first: ask for a SOC 2 Type 2 report, where files are stored and for how long, and whether your documents train shared models. Docsumo is SOC 2 Type 2 audited, ISO/IEC 27001:2022 certified, and HIPAA and GDPR compliant, and your documents aren't used to train shared or third-party models. See how Docsumo handles security.
Sources
- Microsoft Learn: Power Query PDF connector
- Microsoft Support: Import data from data sources (Power Query)
- Microsoft Support: Power Query data sources in Excel versions
- Microsoft Q&A: Can't import PDF using Power Query (image-based PDFs return nothing, Feb 2026)
- American Express: Download transactions and statements
- CFPB: Regulation Z, 12 CFR 1026.7, periodic statement
First published . Last updated .