tool · excel

Bank statement to Excel

Convert any bank statement PDF into a clean, analysis-ready CSV. Open it in Excel, build pivot tables, and audit every transaction without manual data entry.

100% private
PDF parsed locally. Your bank data never reaches a server.
Under a second
Multi-month statements convert instantly in your browser.
Excel-ready
CSV with Date, Description, Amount, and Balance columns — just open it.

Why Excel is the best place for bank statements

Pivot tables
Group transactions by month, category, or merchant in seconds. Excel can summarize thousands of rows without writing a single formula.
Custom formulas
Use SUMIF, COUNTIF, and VLOOKUP to flag duplicates, calculate running totals, or compare against a budget.
Audit trails
Add a Category column, annotate suspicious rows, and share a clean workbook with your accountant or bookkeeper.
Charts and trends
Turn raw spending into visual reports that make it obvious where money is going every month.

The 3-step PDF → Excel workflow

  1. 01
    Export the monthly statement PDF from your bank's online portal — every major bank provides a PDF download.
  2. 02
    Drop the PDF into convertbank.online/converter. The parser finds the date, description, amount, and balance columns automatically.
  3. 03
    Download the CSV and open it in Excel or Google Sheets. Now you can sort, filter, categorize, and build reports.

What the CSV looks like in Excel

The converter exports a clean 4-column CSV that maps directly to Excel columns:

Date,Description,Amount,Balance
06/03/2026,Whole Foods,-87.42,1422.18
06/03/2026,Stripe payout,2410.00,3832.18
06/04/2026,AWS,-312.55,3519.63

After opening in Excel, select any cell and insert a PivotTable → drag Date to Rows and Amount to Values. You now have a monthly spending summary in one click.

Excel formulas that make auditing easy

Running balance check
Add a column with =SUM($C$2:C2) and compare it against the bank's Balance column. Any mismatch means a missing or duplicated row.
Find duplicates
Use Conditional Formatting → Highlight Cells Rules → Duplicate Values on the Description column to catch repeated transactions.
Categorize fast
Add a Category column and use =IF(ISNUMBER(SEARCH("grocery",B2)),"Groceries","Other") to auto-tag common merchants.
Monthly totals
Use =SUMIFS(C:C,A:A,">="&DATE(2026,6,1),A:A,"<"&DATE(2026,7,1)) to get a total for any month.

Common Excel import gotchas

Excel drops leading zeros
If descriptions contain reference numbers like 001234, Excel may strip them. Import via Data → From Text/CSV and set that column as Text.
Dates flip day/month
U.S. banks use MM/DD/YYYY; U.K. banks use DD/MM/YYYY. Format the Date column correctly before sorting, or use the CSV cleaner.
Negative numbers show in red
Excel formats negative amounts as red by default. That is expected for debits and helps spot spending quickly.
CSV is read-only
You can edit and Save As → XLSX to keep formulas, but keep the original CSV as a backup of the raw bank data.

Frequently asked questions

Can I convert a bank statement PDF directly to Excel?+

PDFs are not spreadsheets. convertbank extracts the transaction table from the PDF and gives you a clean CSV file, which opens perfectly in Microsoft Excel, Google Sheets, and Apple Numbers. No copy-paste, no manual retyping.

What Excel format should I use — CSV or XLSX?+

CSV is the most reliable export from bank statements. It imports into Excel without formatting issues, works with formulas immediately, and is small enough to email. XLSX is useful when you want multiple formatted sheets or embedded charts. The converter gives you CSV; you can then Save As → XLSX in Excel.

How do I audit my spending in Excel after converting?+

Once the CSV is in Excel, add a new column for Category, use SUMIF or pivot tables to group by month, and create a chart to spot spending trends. Because the converter preserves Date, Description, Amount, and Balance columns, you have everything you need for reconciliation.

Will the formulas and formatting stay intact?+

The CSV contains raw data, so any formulas, conditional formatting, or charts you add in Excel stay separate in your workbook. That is actually a benefit — you can re-import a new month and the same analysis sheet updates automatically when you point it at the new CSV.

Is the file uploaded anywhere?+

No. The PDF is parsed in your browser using WebAssembly. Nothing is uploaded, logged, or stored. You can verify in DevTools → Network — there are zero outbound requests with file contents.

Convert your first statement to Excel

Free preview, $4.99 one-time unlock per file for the full download. Private, no signup.

Open the converter