CSV Importer for Amazon, Venmo, Apple Card, YNAB, Mint, PayPal

Save time and improve accuracy when importing Amazon, Venmo, Paypal, or Apple Card spending into Google Sheets. Also cleanly imports Mint, YNAB, and Personal Capital data.

About the CSV Line Item Importer

Note: read exporting your Amazon order history into Google Sheets

The Import CSV Line Items workflow makes importing CSV files into Google Sheet easier by:

  • Recognizing & validating your import data source
  • Remapping fields to match up with your Tiller spreadsheet
  • Creating offsets to zero-out credit card charges from your feeds
  • Itemizing orders into discrete line-items to facilitate accurate categorization (Amazon imports only)
  • Tracking imported data and preventing the import of duplicates (not all data sources)
  • Storing searchable metadata in the Transactions sheet
  • Providing one-click filtering of uncategorized imported line items

Who Is This For?

This workflow is designed for spreadsheets powered by Tiller Money Feeds. The CSV Importer saves time and improves accuracy when tracking how money was spent for personal finance and small-business users who regularly transact on the following services: Amazon, Venmo, Paypal, or Apple Card.

The workflow will also help to migrate users who wish to move data from another personal finance platform such as Mint, YNAB, or Personal Capital.

What Data Sources Are Supported?

The Import CSV Line Items workflow will recognize the following types of CSV files:

  • Amazon purchases (USA only)
  • Amazon refunds (USA only)
  • Apple Card purchases
  • Mint transactions register
  • Paypal transactions
  • Personal Capital transactions register
  • Venmo transactions
  • YNAB transactions register
  • Basic Bank CSV

Why use this workflow?

  • If your account is not supported for automated feeds from Tiller Money.
  • If there is a temporary outage for your institution.
  • You want to get historical data from before the first automated import via Tiller Money Feeds

More questions?

Read more and ask any questions about the CSV importer here in the Tiller Community.

How to install this template

Start your free Tiller trial, set up your Foundation Template, then install this template with the free Tiller Community Solutions add-on for Google Sheets.

Tiller Community Solutions FAQ

Is this template free?

This is a free template created by a member of the Tiller Community. While it's free for anyone to use, it's designed for Google Sheets automated by Tiller. Additionally, it's recommended for use within the Foundation Template.

What is Tiller?

Tiller is the only automated personal finance service for Google Sheets and Excel. Tiller keeps all your daily spending, income, and account balances updated in your spreadsheets, so you can easily see where you stand at a glance and gain powerful insights about your money. Learn more →

Does this template have any dependencies or special requirements?

This template for Google Sheets works best when installed in Tiller's Foundation Template.

Have questions about this template?

Visit the Tiller Community with any questions about this template.

Randy Hulett
Randy Hulett

Read Randy's blog posts below. You can also browse spreadsheet templates created by Randy, and see what he's been up to in the Tiller Money Community

Articles: 10