All Collections
Workflows
Working with Manual Data
Importing Your Mint.com Transaction Data into Google Sheets
Importing Your Mint.com Transaction Data into Google Sheets

Quick and easy steps to get your Mint.com data into a spreadsheet.

Heather Phillips avatar
Written by Heather Phillips
Updated over a week ago

Note: these steps are for Tiller-powered Google Sheets.

1. Start with the Foundation template for Google Sheets

You can skip these steps if you've already started a Google Sheet with Tiller Money Feeds

  1. On the Console click "Create a spreadsheet" and then Start with Google Sheets

  2. Follow the instructions on the Install Help tab to install the Tiller Money Feeds add-on and feed your bank data into the Google Sheet

2. Get your data out of Mint

  1. Log into your Mint.com account.

  2. Choose the Transactions menu option.

  3. Click the export link at the bottom of the page to automatically download a CSV file of your transactions.

3. (optional) Grab your categories

If you've already spent some time setting up Categories in your Foundation template you probably want to skip this step. If you're brand new to Tiller you may want to quickly get started with those existing categories from Mint and customize later.

  1. Navigate to your Google Drive at https://drive.google.com

  2. Drag & drop your Mint CSV export into your Google Drive

  3. Double click the CSV file and choose "Open with Google Sheets" at the top

  4. Use the quick formula below in a blank cell to grab a unique list of categories from your data

  5. Copy the list of categories

  6. Paste it into the Categories sheet and overwrite the example categories by right clicking and choose Paste Special > Values only

=unique(F2:F)

4. (optional) Clear your transaction data

If you'd like to just move over the Mint data with all the categorizations, and you have all your data up to today's date, you can clear the Transactions sheet making sure to leave the header row (row 1).

Alternatively, you can just bring in a segment of historical data that pre-dates the Transaction data Tiller was able to automatically pull into your Google Sheet.

5. Import your Mint CSV

  1. Choose Tools > Import CSV Line Items

  2. Upload the Mint CSV from your computer

  3. On the summary screen, choose a date range for the data you'd like to add to the Tiller-powered sheet

  4. Click "Add to Transactions sheet"

6. Customize Categories

You can customize your categories on the Categories sheet. You can totally re-think the way you want to categorize transactions. Update category names or delete ones you no longer want or need. Each category should have a Group and a Type.

To update Transactions that have already been categorized:

  1. Turn on the Filter in the Transactions sheet

  2. Sort the Category column from A>Z

  3. Update one invalid entry (red triangle in upper right)

  4. Use the quick fill square to update the other entries

  5. Repeat for each category you want to adjust

Alternatively, you can use AutoCat and run it on "All Transactions" to help you update categories and build a ruleset for ongoing automatic categorization.

7. Start Budgeting

Set your Budget targets for each category on the Categories sheet in column E (you may need to expand these columns.) These values will cascade across to all months in the budgeting year. Edit any month directly.

Did this answer your question?