The Tiller Money Feeds add-in for Microsoft Excel allows you to automate your bank transactions and balances to an Excel workbook.

Table of Contents

How to Install the Tiller Money Feeds add-in

Signing in to the Tiller Money Feeds add-in

Setting up the data feed connection

Keeping your bank data fresh

Disconnecting a workbook

Stopping the data feed for an account

How to uninstall the Excel add-in

How to Install the Tiller Money Feeds add-in

The Tiller Money Feeds add-in is only compatible with Excel for Desktop when installed from a Microsoft 365 subscription or Excel Online.

  1. Open My Add-ins from the Insert ribbon in an Excel workbook

  2. Search for "Tiller" in the Store

  3. Click "Add" and the add-in will appear in your Data ribbon.

Signing in to the Tiller Money Feeds add-in

When getting started with Tiller for Excel, after you've installed the add-in, you'll need to sign in to the Tiller service via the add-in using the account that's associated with your Tiller subscription. This might not be the account you use for Microsoft 365 and that’s okay.

You may also need to sign in again if your already linked workbook has been closed for a while.

How to sign in to the Excel add-in

  1. Open the Data ribbon in Excel

  2. Click the blue "Open Tiller" button

  3. Click "Sign in to Tiller"

  4. Authenticate with the account you use for Tiller.

⚠️ If you used a Google account to sign up for Tiller and you get a "browser is insecure" error when you try to sign in to the Excel add-in follow the steps in this troubleshooting guide to link a Microsoft account to your Tiller subscription.

Setting up the data feed connection

In order to establish a data feed to an Excel workbook you must first link it to the Tiller Console via the Tiller add-in for Excel. This link establishes a connection between the Excel workbook and Tiller’s databases.

You should save the Excel workbook before you can link it to the Tiller Console.

The workbook will appear on your Tiller Console, denoted with an “Excel” flag. It also counts toward your five sheet limit.

How to link an Excel workbook to Tiller:

  1. Make sure the workbook has been saved with a unique name. Choose a storage location you’ll remember. If you’re storing your Excel workbook on OneDrive, be sure to pay attention to the account associated with the OneDrive as this could be different than the account used for Tiller.

  2. Open and sign in to the Tiller add-in in Excel.

  3. Click the “Link workbook” button.

  4. Confirm that you would like to link the workbook.

Linking accounts to your Excel workbook

You can link accounts to your Excel workbooks directly in the workbook via the Tiller add-in or via the Tiller Console so that Tiller will pull the data into the Excel workbook when you click “Update” in the add-in.

  1. Open and sign in to the Tiller add-in in Excel.

  2. Click the “Link accounts” button in the add-in task pane.

  3. Toggle on any account you want linked to this workbook for automated data feeds. If you don’t see all your accounts listed, try scrolling down in the task pane.

  4. Click “Confirm” to link the accounts.

  5. Click the “Fill” button to pull in data from the newly linked account.

To add more accounts for linking visit the Tiller Console and click “Add accounts” under the Account Summary to connect more institutions to Tiller.

Keeping your bank data fresh

Click the “Fill” button in the Tiller Money Feeds add-in for Excel to pull in the latest bank transactions and balances into your workbook. When new data is available to add to your sheet the Fill button will be blue.

  1. Open the Excel add-in from the Data ribbon at the top of your workbook.

  2. Click the “Fill” button at the top. A blue "Fill" button indicates that new bank data is available to add to your workbook.

  3. Save your workbook. Filled transactions and balances may not be re-filled if you forget to save.

For accounts that can automatically refresh, Tiller pulls data from your bank about once a day, which makes it available in our databases. Once it’s available, clicking the "Fill" button will pull it into your Excel workbook.

If the Fill button is not blue indicating new data is available from your banks try visiting the Tiller Console at https://sheets.tillerhq.com/auth/login to refresh accounts under the Account Summary.

Some accounts cannot automatically refresh and will require you to visit the Console at https://sheets.tillerhq.com/auth/login to refresh them.

Learn more about automatic refreshes

Disconnecting a Workbook

If you would like to disconnect the data feed for an Excel workbook you can unlink it. You can unlink it from directly within the Excel workbook via the Tiller Money Feeds add-in.

Unlinking a workbook will remove it from your Tiller Console, free up one of your five sheet slots, and you will no longer be able to fill it with data from Tiller.

How to unlink a workbook

  1. Open and sign in to the Tiller add-in in Excel.

  2. Click on the Settings tab

  3. Click the “Unlink workbook” button.

  4. Confirm that you want to unlink the workbook.

Note: If you relink a workbook that has previously been linked to your Tiller Console you will likely end up with duplicate transactions in the workbook.

Stopping the data feed for an account

If you no longer wish to pull data from an account into your Excel workbook you can unlink it from the Tiller Console or directly from the add-in.

ℹ️ Unlinking a workbook does not remove the data Tiller has already pulled into the workbook.

If you no longer wish to see data for an unlinked account in your workbook you will need to manually remove it from the Transactions sheet and the Balance History sheet.

  1. Open and sign in to the Tiller add-in in Excel.

  2. Click the vertical “...” in the top right of the Linked Accounts area at the top of the add-in.

  3. Toggle off any account you no longer want linked to this workbook for automated data feeds.

  4. Click “Confirm” to unlink the accounts.

  5. (Optional) manually remove data for the account from the Transactions and Balance History sheets. Review the guide here.

How to Uninstall the Excel Add-In

If you need to uninstall the Excel add-in you can use the following steps.

  1. Open Microsoft Excel.

  2. Click the Insert tab.

  3. Click the "My add-ins" button.

  4. Click the ... next to the Tiller add-in

  5. Choose Remove.

  6. Read the notice that appears regarding other devices and click Remove.

Did this answer your question?