Here is exactly how to download your RBC bank statement data in a format ready for Excel. 1. Sign In to RBC Online Banking
RBC’s CSV export is generally clean, but you may want to perform these quick steps to make it more readable:
To ensure the file works with Excel, you need to select the correct parameters:
Explain how to of data into one master sheet
Immediately go to and change the file type to Excel Workbook (.xlsx) to ensure any formatting or formulas you add later are saved. 5. Tips for Formatting Your Data
Alternatively, click into a specific account (e.g., your Day to Day Banking or Credit Card account) and look for the icon or link near the top of the transaction list. 3. Configure Your Export Settings
