If you've ever needed a bank statement in Excel or CSV — for a loan application, tax filing, bookkeeping, or a reconciliation — you know the drill: your bank gives you a PDF, and the spreadsheet people want a CSV. Converting between the two is one of the most common (and most annoying) finance tasks in 2026.
Here's the honest comparison of all 5 realistic ways to do it, including how long each takes, what it costs, and — the part most guides skip — what happens to your financial data.
The 5 ways, compared at a glance
| Method | Time per statement | Cost | Privacy | Accuracy |
|---|---|---|---|---|
| 1. Manual retyping | 30–60 min | Free (your time) | Perfect | Human errors |
| 2. Bank's own export | 2–5 min | Free | Perfect | Best — but only if supported |
| 3. Free generic PDF→CSV converters | 1–3 min | Free / sketchy | ⚠️ Uploaded to random servers | Poor for tables |
| 4. Spreadsheet copy-paste | 10–20 min | Free | Good | Formatting-dependent |
| 5. BankToCSV | ~30 seconds | Free tier, then €5–€10 | Files processed & deleted | High, bank-format aware |
1. Manual retyping — free, but expensive
Typing transactions into a spreadsheet is the "free" option that costs the most. A single statement with 100 transactions takes 30–60 minutes, and typos in account numbers or amounts are nearly guaranteed. For a one-time need it's tolerable; for monthly bookkeeping it's a waste of a working day.
2. Your bank's own export — always check this first
Before doing anything else, log into your bank and look for Export → CSV (or Excel/OFX). Many modern banks — especially in Europe — offer native CSV export that is free, instant, and perfectly accurate. The catch: it's often limited to a date range, doesn't include the full statement layout, and some banks (especially in the US and Asia) simply don't offer it. When it exists, use it. When it doesn't, you need one of the options below.
3. Free generic PDF→CSV converters — the privacy trap
Free "PDF to CSV" sites look convenient, but two things go wrong: (1) generic converters treat your statement like a scanned document — they mangle columns, merge dates with descriptions, and produce data you still have to clean by hand; (2) you're uploading your entire financial history to a server run by someone you know nothing about. There's no such thing as a free lunch when the lunch is your bank statement.
4. Copy-paste into Excel or Google Sheets
If your statement PDF has selectable text, you can copy the transactions table and paste it into a spreadsheet with Text to Columns or Split text to columns. It works for simple layouts and keeps data on your machine. But multi-page statements, wrapped columns, and "Date Description Amount" mixes make this fragile — you'll spend 15 minutes fixing rows for every 5 minutes of pasting.
5. BankToCSV — built for bank statements specifically
BankToCSV is a purpose-built converter: upload your statement PDF, get a clean CSV back in about 30 seconds. Unlike generic converters, it understands common bank statement layouts (40+ bank formats), so dates, descriptions, and amounts land in the right columns the first time. It runs on a free tier for occasional use, and there's no subscription lock-in — you can also pay with BTC or USDC.
- Cost: free tier; Pro from €5–€10 — far cheaper than an accountant retyping it.
- Privacy: files are processed and not stored long-term — verify the current policy on the tool page.
- Output: clean CSV you can open in Excel, Google Sheets, QuickBooks, or your tax software.
Which method should you pick?
| Situation | Best method |
|---|---|
| Bank offers native CSV export | Bank's export (free, instant) |
| One statement, never again | Copy-paste (method 4) |
| Monthly bookkeeping / reconciliation | BankToCSV (method 5) |
| Scan-only / image PDF | BankToCSV with OCR — retyping is the only other option |
| Any situation, any method | Never upload to unknown free converters |
The rule of thumb: if your bank exports CSV natively, use it. If not, use a converter that respects your privacy and understands bank formats — your data is worth more than a free upload button.
What about Excel instead of CSV?
CSV is the universal format — Excel, Google Sheets, QuickBooks, and nearly every accounting tool import it. If you specifically need .xlsx, convert the CSV in Excel in one click (Data → From Text/CSV), or check out the free converters on Tooly. For anything invoice-related, InvoiceForge covers the billing side.