How to Export Amazon Orders to Excel and Google Spreadsheets

Here's how to easily export Amazon orders into Excel and Google spreadsheets, plus tips for organizing and categorizing your purchase history.

We recently shared instructions for downloading your entire Amazon order history in three quick steps.

But once you’ve downloaded your CSV files from Amazon, you probably want to view them in Google Sheets or Microsoft Excel. That way you can analyze your purchase history with custom reports and visualizations, or back it up for safekeeping.

Here’s how to get started.

upf

How to Export Amazon Order History for Microsoft Excel

Amazon Item Report Uploaded to Microsoft Excel

Here are instructions for importing your Amazon Order History to Microsoft Excel:

  1. Log into your Microsoft account
  2. Click Excel
  3. Click Upload on the right side of the screen (some browsers allow you to simply drop the file in the browser window)
  4. Your Amazon report is now available for deeper analysis and archiving in Microsoft Excel

How to Export Amazon Order History for Google Sheets

Amazon Item Report Uploaded to Google Sheets

Here are instructions for importing your Amazon Order History to Microsoft Excel:

  1. Login to your Google Account and open a new Google Spreadsheet
  2. Click Open > Upload
  3. Drop your Amazon CSV file into the window or click “Select a file from your device”
  4. Your Amazon report is now available for deeper analysis and archiving in Google Sheets

Easier Amazon Order History Tracking With Tiller

If you already use Tiller, you know it’s the fastest, easiest way to manage your financial life with the flexibility of a spreadsheet.

That’s because Tiller automatically updates Google Sheets and Excel with your daily financial transactions. No more data entry, CSV bank files, or logging into multiple accounts.

Tiller already pulls in each of your Amazon order transactions, which look like this in Google Sheets:

However, you might want to track your Amazon purchases in greater detail.

upf

For example, the $50 Amazon purchase above might include items you want to categorize individually for more accurate tracking.

You could manually update the order line by line. But if you’re using Tiller to track your money, it’s much faster to use the free CSV Importer from the Tiller Community.

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

The CSV Importer streamlines the itemization of your Amazon orders into discrete line items in Google Sheets powered by Tiller.

As explained in the Tiller Community, “the magic of the add-on is that you will see discrete purchases that can be categorized without clumsy splits or time spent cross-referencing the Amazon site.”

The CSV Importer:

  • Automatically creates offsets to keep your cash flow reporting accurate
  • Creates new rows for each item purchased
  • Shows exactly what you paid for each item
  • Pulls in each product’s name and details

Once your order history is imported into your Tiller-powered Google spreadsheet, you can then categorize each transaction according to your preferences. In this example, we’re putting these items in our Supplies, Technolgy, and Pets categories:

You can manually categorize your Amazon items, or run AutoCat to efficiently auto-categorize some or all transactions based on custom rules.

To learn more about the CSV Importer, visit this thread in the Tiller Community. Comment there with any thoughts or questions!

Google Workspace Marketplace

Start Your Free Trial

Try Tiller free and track all your accounts in one place, always know where your money goes, and confidently plan your financial future.

Default image
Edward Shepard
Marketing Lead at Tiller. Writer. Spreadsheet nerd. Get in touch with partnership ideas at edward @ tillerhq.com.

Notable Replies

  1. Huge tiller fan here.
    This looks great. Is there any way for this tool to work with any bank? Isn’t it all about identifying and matching the right column headers?

    I had a solid workflow but once Yodlee stopped supporting UK (and many other) financial services it all broke.
    For now I’m trying to use formulas in G Sheets to trim and re-format the CSVs to match the tiller layout/format and paste but this solution is rather slow.
    I’ve also seen a python script (htt*s://d.pr/X5hjpA) the would format the csv data from Apple Card to work with tiller.
    The code probably needs to be adjusted as probably has the potential to work with any bank/financial institution?

  2. Avatar for randy randy says:

    Glad to hear you’re enjoying Tiller, @Mariusz.

    The tool can work with other banks but currently works with a preset list of remapping rules for known import types. (It is not currently programmed to recognize column names and dynamically remap them.)

    I think we’ve got Apple Card working though sometimes the outputs (and thereby unrecognized) are slightly different when using them internationally.

    I hope we are able to support you soon in the UK.

    Randy

  3. Thanks for the quick reply. Think I finally figured out what happened. Thanks for clarifying how the add on works. Basically, it is just importing the raw data from the Amazon order extract and doesn’t try to do any kind of matching of existing transactions. The main reason why I could reconcile is that I noticed what is imported from the Amazon Order history and what shows up on the credit card transaction is often not 1:1. Here are some findings:

    1. The Amazon order history does not factor in certain discounts like “Subscribe and Save”. So when I get a 5% off, my credit card transaction has a lower charge than what is imported from the Order history. This is a BUG in Amazon’s feed. I don’t know if this is an issue with other discounts like coupons, etc.

    2. The Amazon Order feed has the wrong ship date in some circumstances.
      For instance, the feed said the item shipped on 3/7 but on the website, the item actually shipped on 3/14 (this was a subscribe and save item). The credit card is charged on the actual ship date 3/14. I think subscribe and save really mucks with this feed.

    3. When you use a payment mechanism like an Amazon gift card for full or some of the order, there’s no credit card transaction or it’s much less but the Amazon Order import will include the full amount. In order to properly fix this, the user needs to remember to create a “transaction” in tiller when a gift card is added to the Amazon account.

    So in short, it feels like a good way to model this is to create a notion of an “Amazon” account (i.e., add a manual account) and have all the Amazon Items/Order be transactions in this account. So credit card payments to “Amazon” would be transfers to this account. When redeeming gift cards, these should be treated as “deposits” to the “Amazon” account.

    In the end, things won’t perfectly balance but you do get close. Definitely a fantastic feature but it will change your Amazon buying behavior somewhat to make things tie. :slight_smile:

    Mark

  4. Avatar for Larry Larry says:

    In case of any interest to newer folks working on Amazon autocat (like me), here is how I’m filtering and assigning a few discrete recurring Amazon charges and cleaning up the messy descriptions. (“Amazon Prime annual” subscription charges are discretely described by Amazon and I categorize these as a business expense. “Amzn Digital” in my case means Kindle books almost always. The 3 text strings here pick up about 7 or 8 different odd-looking text descriptions I get from my ordinary Amazon Item purchases.)

    Of course, each ordinary Amazon Item then must be individually categorized which is the whole point: e.g., "dog collar " goes to “Pets”. But this gets you started with a clean description and some easy categorizations.

    My Amazon autocat approach: columns shown here are Categories, Description Contains, and Description (rename)

    By the way, the importer is just a terrific tool/bot Randy!

  5. Avatar for randy randy says:

    I’ve got something similar in my AutoCat rules though not quite as thorough. Well done.
    Thanks for documenting this, @Larry.

Continue the discussion at community.tillerhq.com

11 more replies

Participants