BMO Harris Bank Missing from Money in Excel: Import Transactions
Question details
The user needs a way to work with BMO Harris Bank transactions in Excel when the bank is not listed in Money in Excel.

- Product
- Money in Excel
- Device & OS
- not provided
- Scenario
- The user wants to connect a BMO Harris Bank account directly to Money in Excel.
- Observed behavior
- BMO Harris Bank is not listed as a supported institution, so the user cannot connect the account directly.
Check whether your bank offers a CSV export of your transactions through online banking. Money in Excel was discontinued on June 30, 2023, so its bank connection service is no longer available.
Import BMO transactions into Excel from a CSV file
Use a bank transaction export to work with your account activity in Excel without Money in Excel.
Sign in to BMO online banking, open the relevant account, and look for a download or export option in the transaction history. Select CSV if it is available.
Open Excel and select Data > From Text/CSV. Choose the downloaded CSV file and review the import preview.
Select Load, then check the dates, amounts, and transaction descriptions in the worksheet. Save the workbook as an Excel file if needed.

Review bank transaction exports in WPS Spreadsheets
WPS Office is a free, lightweight alternative with a familiar interface and support for Excel files, making it easy to move existing workbooks and review bank transaction exports. It does not restore Money in Excel or its bank connections.

Frequently Asked Questions
Can I still connect BMO Harris Bank through Money in Excel?
No. Money in Excel was discontinued on June 30, 2023, so its bank connection service is no longer available.
How do I bring BMO transactions into Excel?
If your bank provides a CSV download, export the transactions from online banking, then use Data > From Text/CSV in Excel to import the file.
Will an imported CSV update automatically?
No. A downloaded CSV is a snapshot of the transactions included in that file. Export and import a new file when you need more recent activity.
Can WPS Office restore the Money in Excel bank connection?
No. WPS Office cannot restore the discontinued Microsoft service, but WPS Spreadsheets can open available CSV exports and Excel workbooks for manual transaction review.




