Tiller Google Sheets: Templates, Excel Add-in and History

Quick Answer: Tiller is a paid service that pulls your bank and card transactions into a Google Sheets or Excel workbook once a day, with a ready-made budget called the Foundation Template. It is sold as a $99 annual subscription after a 30-day trial, there is no free tier, and it usually fetches only about 90 days of history. For older months, Tiller's CSV Importer takes transactions from a CSV file.

Tiller is not a template you download; it is a data feed that fills a spreadsheet you own. You connect accounts through Yodlee or Plaid, Tiller checks them daily, and new rows land in a Transactions sheet in Google Sheets or Excel. The budget, category and net-worth tabs are formulas built on that sheet, which is why you can rearrange them freely.

What does Tiller actually put in your spreadsheet?

Tiller's help article What is Tiller and how does it work (read on 26 October 2026) describes three moving parts:

1. Connections. Tiller links to checking, savings, credit card, loan and investment accounts through two data providers, Yodlee and Plaid, which it says support over 10,000 financial institutions between them.
2. Daily updates. It checks for new transactions and balances every day and makes them ready to fill into your workbook.
3. Your sheet. Each transaction arrives in the Transactions sheet for you to review and categorise. Tiller deliberately does not auto-categorise everything for you; it offers a rules tool called AutoCat instead.

One limit shapes who can use it at all: Tiller says it supports U.S. customers only and uses U.S. dollars and U.S. date formats. Its getting-started FAQ adds that it cannot offer connections to EU or UK banks because of Open Banking rules.

The Foundation Template, tab by tab

When you set up Tiller for the first time it creates the Foundation Template, which Tiller supports in both Google Sheets and Excel. According to Tiller's Foundation Template article, it contains:

People searching for a "Tiller budget template" usually mean the Monthly and Yearly Budget sheets above. Beyond the Foundation, the Templates feature inside the Tiller Money Feeds add-on lists Tiller-built extras such as a debt snowball sheet and savings goals, plus some community-built ones. Anything installed from the Tiller Community is supported by the community rather than Tiller's support team.

Is there a free Tiller spreadsheet?

Not in the sense most searchers hope. Tiller's FAQ says your card is charged the $99 annual subscription fee, plus sales tax where it applies, when the 30-day free trial ends. The trial itself is the full product: both Google Sheets and Excel, up to 5 spreadsheets, daily updates and human support.

What does stay free is the file. Tiller's article on what happens after you cancel says spreadsheets you created remain in Google Drive, OneDrive or on your computer. The daily feed stops at the end of the billing period, and your Tiller account, bank data and connections are deleted from Tiller's systems 30 days after the cancellation takes effect. So a cancelled Tiller workbook keeps working as an ordinary spreadsheet; it just stops refilling. Tiller also notes that refunds are not automatic and are offered up to 30 days after payment.

If you want a budget sheet with no subscription at all, the realistic route is a template of your own fed by CSV files you export or convert yourself. Our guide to importing bank data into Google Sheets for budgeting walks through that approach, and auto-importing bank transactions into a spreadsheet compares feed services like Tiller with the manual route.

Does Tiller work with Excel?

Yes, through the Tiller Money Feeds add-in for Microsoft Excel, which you open from the Data ribbon. The catches are in Tiller's Excel FAQ:

• Microsoft 365 only. The add-in and the Foundation Template work with Excel installed through a Microsoft 365 subscription, or with Excel Online. Older standalone versions of Excel are not supported.
• Personal Microsoft account for sign-in. Tiller can only accept a personal or family Microsoft login, not a work or school account.
• Separate template libraries. Google Sheets templates and community solutions do not work in Excel. To move, Tiller suggests downloading your Google Sheet as CSV or Excel and pasting the transactions into the Excel workbook, watching the column order because the Transactions columns differ slightly between the two.
• Manual fills. In Excel, Tiller pulls data about once a day into its database, and you click a button in the add-in to fill the workbook.

Tiller's own advice in Sheets or Excel? is to start with Google Sheets unless you already pay for Microsoft 365. Google Sheets has more Tiller features and community templates, gets new features and betas first, and needs nothing installed. One subscription covers both, so you can try the Excel version later without a new account.

How do you add transactions older than Tiller's 90 days?

This is where most new Tiller users hit a wall. Tiller's getting-started FAQ says it can typically pull up to 90 days of historical transactions from most institutions, varying by bank. If you start in October and want a full-year budget, January to July is missing.

Tiller's answer is the CSV Importer, released on 1 October 2025 and documented in Import bank CSVs into Tiller. The steps:

1. Log in to the Tiller Console at my.tiller.com.
2. Click Accounts in the left menu, then Import CSV at the top right.
3. Drop your CSV file into the blue box.
4. Choose the account the file belongs to.
5. Map the CSV columns to Tiller's columns and click Finish.
6. Fill the data: Google Sheets on Direct Fills updates automatically; in Excel, or older Sheets on Sidebar Fills, launch Tiller Money Feeds and fill.

Tiller lists the rules your file has to meet, and they matter more than the steps:

• Amounts need one of three shapes: a single Amount column with positive and negative values; an Amount column of absolute values plus a Type column reading credit or debit; or two columns headed Inflow and Outflow, or Credit and Debit.
• Dates should be MM/DD/YYYY, and every row must have one. A missing date makes the import fail without an error message.
• No de-duplication. If your file overlaps the 90 days Tiller already pulled, you get duplicates. Set the date range so the file stops where the feed begins.
• Balances are not updated by an import; for a manually tracked account you update the balance yourself.
• Mistakes can be undone from Import History, which deletes everything from that import in Tiller's database (not from your sheet).

Tiller recommends adding an Import Tag column to the Transactions sheet so imported rows can be identified later.

When your bank's CSV does not go back far enough

The importer needs a CSV, and many banks only export a few months of transactions while keeping years of PDF statements. In that case the statement PDFs are the record. Download the months you are missing (our guide on getting old bank statements covers where banks keep them), then turn them into CSV. QuickBankConvert does that for statement PDFs: each transaction becomes a row with date, description, category and a signed amount where money out is negative, which matches Tiller's single Amount column format. Before importing, check the date column reads MM/DD/YYYY and leave columns Tiller does not need unmapped. Each converted file holds one account, so it maps to one Tiller account.

A free account downloads CSV for 3 statements a month, up to 10 pages each, enough for a few missing months; a backlog of a year or more across several accounts fits a paid plan on the pricing page better. Your files are uploaded and processed on our servers. If your bank does offer CSV for the dates you need, use that instead: it is one step fewer.

Tiller alternatives worth considering

• Your bank's own export plus a simple template, if you only have one or two accounts.
• Google Sheets with converted PDFs, when you mainly need history rather than a daily feed; see PDF to Google Sheets.
• Tiller's Import & Track Manually option, which lets you use the Foundation Template and AutoCat without connecting any bank, useful if your institution does not connect reliably.

Related guides

• Auto-import bank transactions into a spreadsheet
• Import bank data into Google Sheets for budgeting
• PDF bank statement to CSV
• PDF bank statement to Google Sheets