RBC Royal Bank bank statement to CSV
Convert RBC Royal Bank bank statements from PDF into a clean spreadsheet with dates, descriptions, signed amounts and balances. Free, no signup, and your file is never stored.
Also known as Royal Bank of Canada.
Convert a RBC Royal Bank statement
Drop your RBC Royal Bank PDF statement here
or click to browse · 10MB max · nothing is stored
About RBC Royal Bank statements
RBC statements use the Canadian convention of withdrawals, deposits and balance columns, with dates that omit the year inside the table. That missing year is the classic import error.
How to download your RBC Royal Bank statement as a PDF
Sign in to RBC Online Banking, open the account, choose Statements, and download the PDF.
Always take the statement file the bank issues rather than printing a transaction list from the browser. The issued statement is the document of record, and it converts more reliably than a printed page.
What a RBC Royal Bank statement looks like
A dated table lists description, withdrawals, deposits and balance, with the statement period printed in the header.
RBC Royal Bank quirks to watch for
These are the details that break a copy-paste into Excel, and the reason a RBC Royal Bank statement rarely lands cleanly on the first try:
- Transaction dates often omit the year, which has to be taken from the statement period.
- Statements spanning a year boundary need careful date handling.
- Cheque entries are listed with their numbers in the description.
- Canadian statements frequently omit the year inside the transaction table. The year is taken from the statement period, including periods that cross into January.
What you get back
Every RBC Royal Bank conversion returns the same columns, in CAD, so statements from different months and different accounts stack in one spreadsheet without rework:
| Date | Description | Amount | Balance |
|---|---|---|---|
| 2026-03-04 | CARD PAYMENT TO SUPERMARKET | -64.20 | 2,481.19 |
Check the export before you use it: opening balance plus the sum of the amount column should equal the closing balance printed on your RBC Royal Bank statement.
Why not just export from RBC Royal Bank directly?
Use the direct export when it covers the period you need. It rarely does. Direct CSV, OFX and QBO downloads are usually capped at a recent window, while PDF statements stay available for years, and they are the only thing left once an account is closed. Converting the PDF removes the date limit entirely.
Frequently asked questions
+How is the missing year handled?
The year is taken from the statement period header and applied to each row, including statements that cross into January.
+Are amounts in Canadian dollars?
Yes, and USD accounts held at RBC are read in their own currency.
+Is the RBC Royal Bank statement converter free?
Yes. No signup, no email and no watermark on the output. The only limit is a 10MB file size.
+Do you store my RBC Royal Bank statement?
No. The PDF is processed in memory to build the CSV and is never written to disk or retained.
+Is this service affiliated with RBC Royal Bank?
No. This is an independent tool with no connection to RBC Royal Bank. It reads a PDF you already have and never connects to your account.