How to Convert an RBC Bank Statement PDF to Excel or CSV

RBC, like most Canadian banks, hands you statements as PDFs. That's fine for reading, but useless the moment you need to do anything with the numbers — total your spending, hand transactions to an accountant, or sort them by category. For that you need the data as rows in Excel, Google Sheets, or a CSV.

The problem is that an RBC statement isn't a table. It's a printed document that happens to contain a table-shaped list, and getting clean rows out of it is harder than it looks. Here are three ways to do it, from most manual to least.

---

Why RBC statements are awkward to convert

Before the methods, it helps to know what you're fighting:

• Multi-line transactions. A single purchase often wraps across two lines — merchant on one, location or reference on the next. Naive converters split this into two broken rows.
• Date columns that blur together. RBC statements show both a transaction date and a posting date. Tools frequently grab the wrong one or merge them.
• Running balance noise. The balance column repeats on most rows and clutters any export you actually want.
• Page headers and footers. Account summaries, legal text, and "continued on next page" lines get pulled in as fake transactions.

Any method that ignores these will give you a spreadsheet you spend an hour cleaning. Keep that in mind as you pick one.

---

Method 1: Copy and paste into Excel

The zero-tools approach:

1. Open the statement PDF and select the transaction rows (not the headers or summary).
2. Copy, then in Excel use Paste Special → Text so it doesn't import as one blob.
3. Use Data → Text to Columns and split on spaces or fixed widths to break dates, descriptions, and amounts into separate columns.
4. Manually fix the wrapped multi-line transactions and delete the header/footer rows that snuck in.

This costs nothing and works for a single short statement. It falls apart fast on twelve months of data, and the multi-line transactions make it genuinely tedious.

Method 2: Use a PDF-to-Excel converter

Generic PDF converters (the same ones that turn any PDF into a spreadsheet) will take a swing at it. They're faster than copy-paste, but they don't understand bank statements specifically — so they tend to choke on exactly the quirks above: wrapped rows, the double date column, the repeating balance. You'll usually get something, then spend time repairing it.

If you want to go this route, our general guide to converting a bank statement PDF to Excel or CSV walks through the trade-offs that apply to any bank, not just RBC.

Method 3: Let an AI reader extract the transactions

This is the approach Ledger AI was built for. Instead of treating the PDF as a generic document, it reads it as a bank statement — so it knows that a wrapped line belongs to the transaction above it, which date to keep, and that the balance column and page footers aren't transactions.

You upload the RBC statement — no bank login required — and get clean, categorized rows you can review, export, or just analyze in place. Because it's reading the statement file itself, your RBC online-banking credentials never enter the picture. (If handing your bank login to an app makes you uneasy, here's why that instinct is worth listening to.)

The point isn't that software is magic — it's that pulling clean rows out of a statement is a structure-recognition problem, and a tool that's seen thousands of statement layouts handles RBC's quirks better than a generic converter or your afternoon.

---

Which method should you use?

• One short statement, one time: copy-paste is fine.
• A few statements, you don't mind cleanup: a generic PDF converter.
• Many statements, or you want it categorized too: an AI statement reader, because the cleanup is where all the time goes.

Frequently asked questions

Can I download RBC transactions as CSV directly? RBC Online Banking lets you export recent transactions to CSV for some account types, but the official PDF statements — especially older ones and credit card statements — are PDF-only. Converting the PDF is how you get historical data into a spreadsheet.

Will converting my statement expose my login? Not if you work from the downloaded PDF. Methods that read the statement file never need your online-banking credentials — that's the whole advantage over apps that link to your account.

Does this work for RBC credit card statements too? Yes. Credit card statements have the same wrapped-line and footer issues as chequing statements, so the same methods — and the same cautions — apply.

---

Once your transactions are in rows, the next question is usually what do they tell me? Upload an RBC statement to Ledger AI and get clean, categorized transactions — plus a breakdown of where the money actually went — in under a minute.