Others

BMO Harris Bank Missing from Money in Excel: Import Transactions

Emma BrownEmma Brown Nov 14, 2026 869 views

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.

BMO Harris Bank Missing from Money in Excel: Import Transactions
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.
Before you start

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.

Solution 1Recommended

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.

1
Export your transactions

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.

2
Import the file

Open Excel and select Data > From Text/CSV. Choose the downloaded CSV file and review the import preview.

3
Load and review the data

Select Load, then check the dates, amounts, and transaction descriptions in the worksheet. Save the workbook as an Excel file if needed.

Import BMO transactions into Excel from a CSV file
Manual updates required: A CSV import does not create a live bank connection. Download and import a new transaction file when you need updated data.
Free Microsoft Office alternative

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.

Open available CSV transaction exports for manual review.Compatible with Microsoft Excel XLS and XLSX files.Use a familiar spreadsheet interface to organize transactions.Move existing Excel workbooks into a free, lightweight office suite.
microsoft office alternative - wps office

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.