“Hi I have a personal and business amazon account.
I actually was using the Tiller Labs Add-on (not the standalone) when I wrote this: I accidentally posted this in the old standalone Amazon addon article earlier today but was pointed here. Comment there with any thoughts or questions! To learn more about the CSV Importer, visit this thread in the Tiller Community. You can manually categorize your Amazon items, or run AutoCat to efficiently auto-categorize some or all transactions based on custom rules. In this example, we’re putting these items in our Supplies, Technolgy, and Pets categories: Once your order history is imported into your Tiller-powered Google spreadsheet, you can then categorize each transaction according to your preferences. Pulls in each product’s name and details.Shows exactly what you paid for each item.Creates new rows for each item purchased.Automatically creates offsets to keep your cash flow reporting accurate.The CSV Importer streamlines the itemization of your Amazon orders into discrete line items in Google Sheets powered by Tiller.Īs 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.” CSV Importer for Amazon, Venmo, Apple Card, YNAB, Mint, PayPal But if you’re using Tiller to track your money, it’s much faster to use the free CSV Importer from the Tiller Community.
You could manually update the order line by line. 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.įor example, the $50 Amazon purchase above might include items you want to categorize individually for more accurate tracking. No more data entry, CSV bank files, or logging into multiple accounts. That’s because Tiller automatically updates Google Sheets and Excel with your daily financial transactions. If you already use Tiller, you know it’s the fastest, easiest way to manage your financial life with the flexibility of a spreadsheet. Your Amazon report is now available for deeper analysis and archiving in Google SheetsĮasier Amazon Order History Tracking With Tiller.Drop your Amazon CSV file into the window or click “Select a file from your device”.Login to your Google Account and open a new Google Spreadsheet.How to Export Amazon Order History for Google Sheets Amazon Item Report Uploaded to Google Sheets Your Amazon report is now available for deeper analysis and archiving in Microsoft Excel.
Click Upload on the right side of the screen (some browsers allow you to simply drop the file in the browser window).Here are instructions for importing your Amazon Order History to Microsoft Excel: How to Export Amazon Order History for Microsoft Excel Amazon Item Report Uploaded to Microsoft Excel That way you can analyze your purchase history with custom reports and visualizations, or back it up for safekeeping. Amazon has recently changed how you access your Amazon order history, but the instructions on how to imīut once you’ve downloaded your CSV files from Amazon, you probably want to view them in Google Sheets or Microsoft Excel.