How to Export an RBC Bank Statement to Excel or CSV

If you bank with RBC (Royal Bank of Canada) and need your transactions in a spreadsheet, there is one thing to know up front: RBC online and mobile banking generally hand you statements as PDF documents, not as Excel files. So the real task is two steps — download the PDF, then convert it to Excel or CSV. This guide walks through both, with a Canadian context in mind. (Menu labels and screen layouts change over time and differ between personal and business banking, so the steps below are kept general.)

Step 1: Download your RBC statement as a PDF

Whether you use RBC Online Banking on desktop or the mobile app, the flow is broadly the same:

1. Sign in to your RBC account on the website or open the mobile app.
2. Select the account you need a statement for — chequing, savings, or a credit card.
3. Look for the statements or documents area for that account.
4. Choose the statement period (statements are typically organized by monthly cycle).
5. Download or save the PDF to your device.

A few things worth keeping in mind:

• Chequing and savings statements and credit card statements may live in slightly different places, so check each account separately.
• If you need a continuous range — say, several months for a loan application or a full year for taxes — download each period individually and keep them together.
• How far back statements are available, and whether older ones are archived, can vary. If a period you need is not listed, you may have to request it through RBC directly.

Keep the original PDFs. They are your source documents, and you may need to refer back to them.

Step 2: Convert the PDF to Excel or CSV

A PDF is fine for reading, but you cannot sort, filter, total, or categorize it. To actually work with the numbers you need structured rows — one transaction per line, with date, description, and amount in their own columns.

The quickest route is an automated converter that reads the statement, detects the transaction table, and exports clean rows. Drop your RBC PDF into the free bank statement converter to export to Excel (XLSX) or CSV. If you would rather understand the manual options first — typing it in, or copy-pasting from the PDF and cleaning up the columns — see how to convert a bank statement to Excel.

Choosing a format:

• Export to XLSX if you want to add formulas, formatting, or multiple sheets for your own budget or bookkeeping.
• Export to CSV if you plan to import the data into accounting software. See saving a bank statement as CSV for why CSV is the common import format.

Step 3: Review the data against the PDF

Automated extraction is fast, but always sanity-check the result before you rely on it:

• Confirm the opening and closing balances in your spreadsheet match the PDF.
• Spot-check a handful of transactions — dates, amounts, and signs (debit vs credit).
• Watch for multi-line descriptions that may have wrapped or split across rows.

Once the numbers reconcile to the statement, the data is ready to use.

A note on Canadian taxes

If you are pulling statements together for a tax return, the Canada Revenue Agency (CRA) sets the rules on what records to keep and for how long. Bank statements are commonly used as supporting records for income and expenses, but the specifics depend on your situation, so check the official CRA guidance on keeping records rather than relying on a rule of thumb. Having your transactions in a clean spreadsheet makes it far easier to categorize income and expenses come filing time.

Other Canadian banks

Banking elsewhere too? The same two-step approach — download the PDF, then convert — applies. See the guides for downloading a TD statement and downloading a Scotiabank statement.