If you need to migrate financial data from one spreadsheet to another you can use these basic manual steps below. If you're migrating from one Google Sheet to another, you might consider using the Migration Helper in the Tiller Community Solutions add-on to automate these steps. ⚠️ the Migration Helper is an experimental tool built and supported by the Tiller Community.
Table of Contents
Migrate Your Categories
ℹ️ Double check that the column order in the Categories sheet is the same in both the old and new sheet. If it's not, click, hold and drag the column header letter of individual columns in the old sheet so they match the order in the new sheet.
Open the Categories sheet in the original spreadsheet.
Select row 2 in the Category column by clicking the row number.
Hold the shift key.
Scroll down and select the last category row by right clicking the row number.
Open the Categories sheet in the new spreadsheet.
Select all the category data starting with row two and press the delete key to clear the example category data.
Right click cell A2 and choose Paste Special > Paste Values Only to paste in your categories list.
Migrate Your Transactions
ℹ️ Make sure that you have the same accounts linked to the two sheets on the Tiller Console.
ℹ️ Double check that the column order in the Transactions sheet is the same in both the old and new sheet. If it's not, click, hold and drag the column header letter of individual columns in the old sheet so they match the order in the new sheet.
Navigate to the Transactions sheet in the new spreadsheet, click the row number to select row 2. Do not select the header row.
Scroll down to the last transaction in the list, hold down the shift key and then click the last row number.
Press the delete or backspace key to clear the contents of the rows.
Navigate to the Transactions sheet in your original Tiller spreadsheet.
Click the row number to select the first transaction in the list, starting with row 2 if that’s the first transaction you want to copy over.
Scroll down to the last transaction you’d like to copy over into the new sheet, hold down the shift key, then click the last row number.
Right click the row number and choose copy.
Navigate back to the Transactions sheet in the new spreadsheet and right click row 2, then choose Paste Special > Paste Values Only.
Double check your categorizations and correct any errors if you’ve renamed any categories.
Migrate Your Manual Accounts' Balance History
ℹ️ You only need to perform these steps if you have been manually tracking non-automated accounts.
ℹ️ Double check that the column order in the Balance History sheet is the same in both the old and new sheet. If it's not, click, hold and drag the column header letter of individual columns in the old sheet so they match the order in the new sheet.
1. In the original spreadsheet, open the Balance History sheet
2. Select all the data in the sheet and turn on the filter.
3. Sort the sheet by the Account column.
4. Unhide the Account ID and/or Index columns. (click small triangles between column header letters to unhide hidden columns). Some sheets will not have Account ID, and some will not have Index.
5. Copy all rows for any entry that has an account ID that begins with manual: or an index number of 9999
6. Carefully copy/paste these rows into the bottom of the Balance History sheet in the new spreadsheet paying close attention to column order.
7. In the new sheet, add the manual accounts using the Tiller Money Feeds add-on using the steps in this guide.
8. Select all the data in the Balance History sheet and turn on the filter.
9. Sort the sheet by the Account column.
10. Copy/paste the Account ID assigned by the Tiller Money Feeds add-on into the cells for all the prior manually added balance history entries for the non-automated account.
Migrate Your AutoCat Rules
Copy the URL of your new sheet
Open your old sheet and right click the "AutoCat" tab
Choose "Copy to > Existing spreadsheet"
Paste the URL of your new sheet into the bottom of the window that appears
In your new sheet, rename the "Copy of AutoCat" tab to just "AutoCat" (double click the tab name to rename it)
Migrate Your Budget Targets
Since we have had several budget templates over the years there may be a few places you'll find your budget targets and these are general tips on migrating budget targets vs explicit steps.
Our latest Foundation Template budget has 12 budget months in the Categories sheet by default.
If your old and new sheet also have 12 budget months in the Categories sheet, and the months in row 1 are the same, you can just copy/paste your budget values from the old sheet to the new sheet.
If your old sheet does not have 12 month columns in the Categories sheet, but the new ones does, just reference the budget values in your budget dashboard and type them into column E on the Categories sheet in your new sheet.
Migrate from Excel to Google Sheets
You can use the same manual steps above to carefully copy/paste data from your Excel workbook to a Google Sheet or vice versa.
If you'd like to use the Migration Helper in the Tiller Community Solutions add-on you can try these steps:
Save your Excel workbook as a CSV
Upload the CSV to your Google Drive
Open the CSV file in Google Drive then choose to open as a Google Sheet when prompted at the top
Grab the URL of the Google Sheet and use it as the source URL in the migration helper workflow