How to Convert M&T Bank Statements to Excel or CSV

Key Takeaways

• M&T Bank's online banking may offer transaction downloads for recent activity, but official monthly statement PDFs cannot be exported directly to Excel — you need a conversion tool for archived statements.
• M&T Bank statement PDFs use a standard chronological layout, but multi-line descriptions, merged accounts on combined statements, and page-spanning tables can trip up generic extraction tools.
• Five methods exist for converting M&T Bank statements: manual copy-paste, Tabula (free, open-source), cloud converters, native transaction exports, and on-device converters — each with distinct trade-offs in accuracy, privacy, and cost.
• All processing in on-device tools like LocalExtract happens locally on your computer — no statement data is uploaded to any server.
• Always verify converted data against the original statement totals, regardless of which tool you use.

M&T Bank (Manufacturers and Traders Trust Company) is one of the largest regional banks in the northeastern United States, headquartered in Buffalo, New York. With over 1,000 branches across the Mid-Atlantic and Northeast — including New York, Pennsylvania, Maryland, Virginia, West Virginia, Delaware, Connecticut, Vermont, and Washington, D.C. — M&T serves millions of personal and commercial banking customers. Following its 2022 acquisition of People's United Financial, M&T Bank significantly expanded its footprint into New England, adding branches across Connecticut, Massachusetts, Vermont, New Hampshire, and Maine.

Whether you handle personal budgeting, manage bookkeeping for a small business, or prepare taxes for M&T Bank account holders, you have likely needed to get statement data into a spreadsheet at some point.

This guide covers the main methods for converting M&T Bank statement PDFs to Excel or CSV — what works, what doesn't, and the trade-offs involved.

Contents

• Why Convert M&T Bank Statements to Excel or CSV?
• What M&T Bank Statement Formats Does LocalExtract Support?
• How to Convert M&T Bank Statements — Step by Step
• What We Found in Testing
• Alternative Methods
• What the Output Looks Like
• Tool Comparison Summary
• Post-Conversion Verification Checklist
• Tips for Working with M&T Bank Statements
• Privacy Considerations for M&T Bank Statements
• FAQ
• Getting Started
• Conclusion

Why Convert M&T Bank Statements to Excel or CSV?

M&T Bank statement PDFs contain structured financial data — dates, descriptions, amounts, and balances — but the PDF format locks that data into a fixed visual layout. Converting to Excel or CSV unlocks several practical workflows:

• Bookkeeping and reconciliation — importing transactions into QuickBooks, Xero, Wave, or other accounting software requires CSV or Excel input. Manually retyping transactions from a PDF is slow and error-prone.
• Tax preparation — accountants and tax professionals need categorized transaction data to identify deductible expenses, business income, and reportable activity. A spreadsheet makes sorting, filtering, and summing transactions straightforward.
• Auditing and compliance — auditors reviewing bank activity need searchable, sortable data. PDF statements do not allow filtering by date range, amount threshold, or description keyword.
• Personal financial tracking — budgeting apps and personal spreadsheets require structured data. Converting an M&T Bank statement to CSV lets you import transactions into your preferred tracking tool. For small businesses, see our guide on bank statement converters for small business.
• Multi-period analysis — comparing spending or income across multiple months requires combining data from several statements. This is only practical when each statement is in spreadsheet form.
• Post-acquisition account migration — if you previously banked with People's United and your accounts migrated to M&T Bank, you may need to convert statements from both institutions to reconcile the transition period.

If you only need a handful of recent transactions, M&T Bank's online banking may allow you to download recent account activity. But for archived monthly statement PDFs — the official documents available under your account's statements section — you need a conversion tool.

What M&T Bank Statement Formats Does LocalExtract Support?

Before choosing a conversion method, it helps to understand what M&T Bank statement PDFs look like.

Digital PDFs (Downloaded from Online Banking)

M&T Bank statement PDFs downloaded from online banking are text-based — the transaction data is embedded as selectable text, not rendered as an image. You can verify this by opening the PDF and trying to highlight text with your cursor. If the text highlights, it is text-based.

Text-based PDFs are faster and more accurate to convert because the extraction engine reads the text directly rather than relying on optical character recognition (OCR).

M&T Bank Checking and Savings Statements typically include:

• A header block with account holder name, address, account number (partially masked), and statement period
• An account summary section showing beginning balance, total credits, total debits, service charges, and ending balance
• A transaction detail section organized chronologically with date, description, and amount columns
• Check images or check listing section (for accounts with check-writing activity)
• Service charges, fees, and disclosure information at the end

M&T Bank Combined Statements — M&T may issue combined statements that include multiple accounts (checking, savings, money market) on a single PDF. This format includes separate transaction sections for each account, which some conversion tools may not handle cleanly.

Scanned Paper Statements (OCR)

If you have a paper M&T Bank statement that was scanned to PDF — for example, older statements from before online banking was available, People's United statements predating the M&T acquisition, or statements received by mail and digitized with a scanner — the PDF contains images rather than selectable text.

LocalExtract includes a built-in OCR engine (based on PP-OCRv5 running locally via ONNX Runtime) that can extract text from scanned statement images. OCR-based extraction is supported but may be less accurate than text-based extraction, particularly for:

• Low-resolution scans (below 200 DPI)
• Skewed or rotated pages
• Statements with stamps, handwriting, or physical damage overlapping the printed text

For best results with scanned statements, use a flatbed scanner at 300 DPI or higher, and ensure the page is aligned straight.

How to Convert M&T Bank Statements — Step by Step

Here is the complete process for converting an M&T Bank statement PDF to Excel or CSV using LocalExtract.

Step 1: Download Your M&T Bank Statement PDF

1. Log in to M&T Bank's online banking at mtb.com and navigate to your account
2. Go to the statements section (typically under Account Services or Documents)
3. Select the statement period you need
4. Download the statement as a PDF file to your computer

Step 2: Open LocalExtract

Launch LocalExtract on your Mac or Windows PC. If you have not installed it yet, download it here — free to start, no account required.

Step 3: Import the M&T Bank Statement

Drag and drop the M&T Bank PDF into the LocalExtract window, or click "Select PDF" to browse. The engine detects the bank format automatically — no need to select "M&T Bank" from a dropdown or configure any settings.

All processing happens locally on your device. The PDF is never uploaded to any server.

Step 4: Review the Extracted Data

LocalExtract displays the extracted transactions in a preview table. Check that:

• The statement period dates are correct
• Transaction dates, descriptions, and amounts align properly
• The beginning and ending balances match your statement
• Deposits and withdrawals have the correct signs — deposits positive, withdrawals negative

Step 5: Export to Excel or CSV

Click "Export" and choose your format:

• CSV — universal format, works with any spreadsheet app or accounting software. See our guide on how to convert bank statement PDFs to CSV.
• Excel (.xlsx) — formatted spreadsheet with column headers. Best for manual review or sharing with clients. See our guide on how to convert bank statement PDFs to Excel.

The entire process — from drag-and-drop to export — takes under 10 seconds for a typical M&T Bank statement.

What We Found in Testing

We converted 16 sample M&T Bank statements — 13 checking account statements and 3 combined statements (checking plus savings) — spanning mid-2024 through early 2026. Here is what we observed:

• Accuracy: Transaction dates, descriptions, and amounts were extracted correctly across all single-account checking statements. Running balance columns matched the original PDFs. The sum of credits and debits aligned with the account summary section in every case we tested.
• Format quirks: M&T Bank combined statements — where checking and savings appear in a single PDF — required the engine to detect account section boundaries. In our samples, the engine correctly separated the two account sections and produced distinct transaction groups. However, we recommend verifying account separation manually when processing combined statements for the first time. M&T Bank's check listing section, which appears after the transaction table on statements with check activity, was correctly identified as a separate section and excluded from the transaction output.
• Processing time: Single-account statements averaged 3 pages and converted in under 3 seconds on a MacBook Air M2. Combined statements with 5-6 pages took about 5 seconds. A full year of monthly statements (12 PDFs) processed in batch in under 35 seconds.

One edge case worth noting: a statement from a former People's United customer who migrated to M&T Bank in 2022 used a transitional format with slightly different header positioning. The engine handled it correctly, but if you have statements spanning the People's United migration, verify the first conversion carefully. For a broader overview of how these tools work, see our article on what a bank statement converter is.

Alternative Methods

Manual Copy-Paste from PDF

The most basic approach: open the M&T Bank statement PDF, select the transaction table, copy, and paste into Excel or Google Sheets.

The problems:

• Column misalignment — dates, descriptions, and amounts land in the wrong columns or merge into a single cell
• Multi-line descriptions — M&T Bank transaction descriptions that include merchant details, reference numbers, or card numbers across multiple lines merge or split unpredictably when pasted
• Headers and footers mix in — page breaks inject account headers, page numbers, and disclosure text into your transaction data
• Combined statement complexity — if your M&T statement includes multiple accounts, copy-paste will jumble account sections together
• Time cost — a three-page statement takes 15-30 minutes to manually clean up, and errors are common

For a single short statement with a few transactions, manual copy-paste is tolerable. For anything recurring, it is not practical.

Tabula (Free, Open-Source)

Tabula is a free, open-source tool specifically designed to extract tables from PDF files. It runs locally on your computer (Java-based) and does not upload your data to any server.

How to use Tabula with M&T Bank statements:

1. Download and install Tabula from tabula.technology (requires Java)
2. Open Tabula in your browser (it runs a local web server)
3. Upload your M&T Bank statement PDF (the file stays on your machine — Tabula's server is local)
4. Draw selection boxes around the transaction tables on each page, or use the "Autodetect Tables" feature
5. Click "Preview & Export Data" and choose CSV or TSV format

Strengths:

• Completely free and open-source (GitHub)
• Data never leaves your computer
• Works across Mac, Windows, and Linux

Limitations:

• Manual table selection — you need to draw bounding boxes around each table on each page, which is tedious for multi-page statements
• No bank-specific awareness — Tabula extracts whatever table region you select. It does not understand M&T Bank's statement structure, so summary sections and multi-line descriptions require manual adjustment
• Multi-line row handling — M&T Bank descriptions that wrap to a second line often become separate rows in Tabula's output, requiring cleanup
• No batch processing — each PDF must be processed individually with manual table selection
• Requires Java — Tabula needs a Java runtime environment installed

Tabula is a reasonable choice if you have a small number of M&T Bank statements to convert and are comfortable with manual cleanup.

Cloud-Based Converters

Cloud-based PDF converters let you upload an M&T Bank statement PDF to their server, which processes it and returns a CSV or Excel file. Several services handle bank statements specifically:

• DocuClipper — specializes in bank statement conversion. Supports multiple banks. Offers batch processing and accounting software integration
• BankStatementConverter.com — focused on bank statement PDFs. Charges per page
• General PDF converters (Adobe Acrobat online, Smallpdf, etc.) — not bank-specific, but can extract tables from any PDF

Advantages:

• Automated extraction — no manual table selection
• No software installation required
• Cloud-based AI services may adapt to format changes more quickly, since the provider can update their models server-side
• Some services offer batch processing and accounting software integration

Concerns:

• Data leaves your device — your M&T Bank statement is uploaded to a third-party server, including your account number, routing number, and full transaction history for that period
• Retention policies vary — data retention periods differ between providers. Review each service's privacy policy before uploading financial documents
• Ongoing cost — most charge per page or per statement, which adds up for bookkeepers processing many statements monthly

M&T Bank's Native Export Options

M&T Bank's online banking platform may allow you to download recent transaction activity in CSV or other formats. This is separate from your official monthly statement PDFs. Key limitations to be aware of:

• Transaction downloads typically cover recent activity only — not the full statement with summary, beginning/ending balances, and fee details
• The availability window for downloadable transactions may be shorter than the statement archive period
• Downloaded transaction files may not match the statement PDF exactly in terms of descriptions or categorization
• If your account migrated from People's United, historical transactions from before the migration may have different formatting or limited availability

If you need the complete official statement converted — including the account summary, all transaction details, and fee breakdowns — you need to convert the statement PDF directly.

What the Output Looks Like

A well-converted M&T Bank checking statement produces clean, consistently structured rows that you can open directly in Excel or Google Sheets.

Sample CSV output (data redacted):

Date,Description,Amount,Balance
03/01/2026,"DIRECT DEPOSIT - PAYROLL",2950.00,7412.88
03/03/2026,"DEBIT CARD PURCHASE - WEGMANS",-94.23,7318.65
03/05/2026,"ONLINE BILL PAY - NATIONAL GRID",-187.50,7131.15
03/08/2026,"ATM WITHDRAWAL",-200.00,6931.15
03/11/2026,"CHECK #3045",-350.00,6581.15

The exact columns depend on the tool you use and the statement type, but a typical converted M&T Bank statement includes:

Column	Description
Date	Transaction date in MM/DD/YYYY format
Description	Merchant name, transaction type, reference numbers — multi-line descriptions merged into a single field
Amount	Signed amount — positive for deposits and credits, negative for withdrawals and debits
Balance	Running balance after each transaction (when available on the original statement)

For details on structuring CSV output for accounting software import, see our guide on bank statement CSV format for accounting.

Tool Comparison Summary

Method	Cost	Privacy	Accuracy	Effort	Best For
Manual copy-paste	Free	High	Low (requires cleanup)	High	One-off, small statements
Tabula (open-source)	Free	High (local)	Medium (manual selection)	Medium	Occasional use, tech-comfortable users
Cloud converters	Per-page/subscription	Lower (data uploaded)	High (with bank-specific services)	Low	Convenience, integration needs
On-device converter (LocalExtract)	Free tier (10 pages), Pro $10/month or $60/year	High (local)	High (for supported formats)	Low	Privacy-sensitive, recurring use

No single tool is best for everyone. Your choice depends on how many statements you process, your privacy requirements, and your budget.

Post-Conversion Verification Checklist

Regardless of which method or tool you use, always verify the converted data against your original M&T Bank PDF. Conversion errors — from any tool — can cause problems in bookkeeping, tax preparation, and reconciliation.

• Beginning balance — does the first balance in your spreadsheet match the "Beginning Balance" shown in the account summary on the PDF?
• Ending balance — does the last balance or your computed ending balance match the "Ending Balance" on the PDF?
• Total credits — sum all positive amounts (deposits, credits) in your spreadsheet and compare to the total credits shown in the statement summary
• Total debits — sum all negative amounts (withdrawals, debits) and compare to the total debits in the summary
• Transaction count — count the rows in your spreadsheet and compare to the number of transactions on the PDF. Multi-line descriptions are the most common cause of row-count mismatches
• Date range — confirm the first and last transaction dates fall within the statement period shown on the PDF
• Spot-check amounts — pick 3-5 transactions at random and verify the date, description, and amount match exactly

This verification step takes 2-3 minutes and catches the most common conversion errors before they propagate into your accounting.

Tips for Working with M&T Bank Statements

Download Statements Promptly

Banks retain downloadable statement PDFs online for a limited period. Check your M&T Bank account for the specific retention window available to you. If you need statements for tax preparation or auditing, download them as soon as they become available and store them in a secure local folder.

Former People's United Customers

If your account was originally with People's United Financial and migrated to M&T Bank in 2022, you may have statements from both institutions for that transition year. People's United statement PDFs use a different format than M&T Bank statements, so you may need to convert them separately and reconcile the overlap period. Keep both sets of original PDFs for your records.

Batch Processing for Multiple Months

If you need to convert a full year of M&T Bank statements (12 PDFs), choose a tool that supports batch input. Processing files one at a time with manual steps (as with Tabula or copy-paste) is impractical at volume. LocalExtract accepts multiple files at once. Some cloud converters also support batch upload.

Handling Multi-Line Descriptions

M&T Bank transaction descriptions sometimes span multiple lines — for example, a debit card purchase might show the merchant name on one line and the city/state or reference number on the next. When evaluating any conversion tool, check that these multi-line descriptions are merged into a single row rather than split into separate rows. A split description creates a phantom transaction row with no amount, which inflates your transaction count.

Combined Statements

If your M&T Bank statement is a combined statement that includes multiple accounts (checking, savings, money market), be aware that some conversion tools may merge transaction sections from different accounts into a single output. Verify that each account's transactions are correctly separated, and check beginning/ending balances for each account individually.

Verify After Every Conversion

Even if a tool worked perfectly on last month's statement, always verify the current conversion. Banks periodically update statement layouts, and a format change can affect conversion accuracy without warning. The verification checklist above takes only a few minutes and prevents errors from reaching your books.

Keep the Original PDF

Always retain the original M&T Bank statement PDF as the authoritative record. The converted CSV or Excel file is a working copy for analysis and import — not a replacement for the official statement. For tax and audit purposes, the PDF is the primary document.

Looking Ahead

The statement conversion space is evolving rapidly. Open Banking frameworks — already mature in the UK and EU — are gradually taking shape in the US, and future API-based transaction access could reduce reliance on PDF statements for routine bookkeeping at institutions like M&T Bank. In the meantime, privacy-first on-device tools are becoming the default for professionals handling sensitive client data, replacing cloud-based services that require uploading financial documents to third-party servers. Real-time export integrations, where transactions flow directly from bank systems into accounting software, are another development to watch. Until these capabilities are universally available, PDF-to-spreadsheet conversion remains a critical workflow for tax preparers, bookkeepers, and auditors. For a comparison of tool options, see our guide on free vs. paid bank statement converters.

Privacy Considerations for M&T Bank Statements

M&T Bank statements contain highly sensitive information:

• Full or partial account numbers — even masked numbers combined with other statement data can be used for social engineering
• ABA routing number — printed on every checking statement
• Transaction descriptions — reveal spending patterns, merchants, income sources, employer name, and subscription services
• Balance information — shows exact financial position at the start and end of each period

When choosing a conversion method, consider where your data goes:

• Methods that keep data local (manual copy-paste, Tabula, on-device converters like LocalExtract): your statement never leaves your computer
• Methods that upload data (cloud converters): review the provider's privacy policy, data retention period, encryption practices, and server locations before uploading

For bookkeepers and tax professionals managing M&T Bank statements for multiple clients, the privacy decision affects not just your own data but your clients' data as well. Consider your professional obligations under the FTC Safeguards Rule and IRS Publication 4557: Safeguarding Taxpayer Data, which outlines security requirements for tax preparers handling client financial information.

For a deeper comparison of cloud versus local processing approaches, see our guide on cloud vs. local bank statement converters.

FAQ

Can I download M&T Bank statements as CSV directly from online banking? M&T Bank's online banking may offer a transaction download feature for recent account activity. However, your official monthly statement PDFs — available in the statements or documents section of your account — can only be downloaded as PDF files. To get statement data into CSV or Excel format, you need to convert the PDF using one of the methods described above.

Does M&T Bank provide statements in Excel format? No. M&T Bank monthly statements are available only as PDF documents. Any transaction download features cover recent activity only and do not include the full statement with summary, beginning/ending balances, and fee details.

I was a People's United customer. Can I convert my old People's United statements? People's United statement PDFs use a different format than M&T Bank. LocalExtract's engine detects bank formats automatically, so you can try converting a People's United PDF the same way — drag and drop it in and review the results. The accuracy depends on the specific statement format. Always verify the output against the original PDF.

Does LocalExtract work with scanned M&T Bank statements? Yes. LocalExtract includes a built-in OCR engine that can extract text from scanned statement images. However, OCR-based extraction may be less accurate than text-based extraction from digitally downloaded PDFs. For best results, scan at 300 DPI or higher with the page aligned straight.

What output formats does LocalExtract support? LocalExtract currently exports to CSV and Excel (.xlsx). It does not currently support QBO (QuickBooks) or OFX formats. If you need QBO or OFX, you may need to use a cloud-based converter or import the CSV into your accounting software, which typically has its own CSV import feature.

Is the converted data accurate enough for tax preparation? No converter is 100% accurate in all cases. For tax preparation, always verify converted data against the original PDF using the verification checklist above. Compare totals, spot-check individual transactions, and confirm that no rows are missing or duplicated. The original PDF remains the authoritative document — converted data is a working copy.

How much does LocalExtract cost? LocalExtract offers a free tier that processes up to 10 pages (lifetime). The Pro plan is $10/month or $60/year, with unlimited pages. No account is required to start with the free tier.

Getting Started

If you have M&T Bank statement PDFs that need converting, here is the quickest path:

1. Download LocalExtract — free for Mac and Windows, no account required
2. Drop in your M&T Bank PDF — the engine detects the format automatically
3. Review and export — verify the extracted data, then export to CSV or Excel

The free tier includes 10 pages, which is enough to test the tool against your own M&T Bank statements and verify the output quality before committing to a plan. All processing happens on your device — your statement data is never uploaded anywhere.

For more on converting bank statements from other institutions, see our guides on how to convert bank statement PDFs to Excel, bank statement converters for accountants, and offline bank statement converters. If you need to digitize older paper statements from before M&T's online banking era, our guide on how to digitize bank statements covers scanning best practices. For importing converted data into Xero, see our walkthrough on importing bank statements to Xero.

Conclusion

Converting M&T Bank statement PDFs to Excel or CSV is a well-supported workflow with options ranging from free open-source tools to automated on-device converters. The right choice depends on your volume, privacy requirements, and whether you need to handle combined statements or legacy People's United formats. For bookkeepers and tax professionals, on-device processing eliminates the regulatory burden of uploading client financial data to third-party servers. Whichever method you choose, always verify the converted output against the original PDF before relying on it for bookkeeping, tax preparation, or reconciliation.

---

This article is published by the LocalExtract team. LocalExtract is one of several tools that can convert M&T Bank statement PDFs to CSV and Excel. Competing products were not tested under the same conditions.