How to Export Amazon Orders to Excel and Google Spreadsheets (Updated for May 2023)

Amazon has recently changed how you access your Amazon order history, but the instructions on how to im

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.

How to Export Amazon Order History for 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

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.

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.

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!