Sorry, but your browser does not support the tag here's a link to the movie. To use my solution, you'll need to download your Amazon data and install one of the two versions of the Excel workbook. In addition to the search tool, the final product includes a summary of spending over the years-here's how that looks with some sample data…
Once I had all my data, I set to work on the workbook, learning quite a bit about some obscure Excel features along the way. Using that extension (in Chrome, of course), I was able to download all my historical data-it's a bit time consuming if you've got a long history with Amazon, as you have to do one year at a time. Never one to be deterred by a lack of official support, I did some more digging, and found the Amazon Order History extension for Chrome. Still, if all you want is your data downloaded, the above URL makes it really simple. (If you know of a working link to download your history, please share here and then everyone can ignore the rest of this post!)Īs noted above, the URL works again, but the data doesn't match the Chrome export, so it won't work with my workbooks. From what I found, the following URL used to be available to everyone…Īlas, when I (and a few friends) tried it, that URL just landed on the standard orders page. My adventure started with a search for any official download solution from Amazon. Getting from "this should be possible" to "it works!" was (as usual) more of a challenge than I anticipated, but it is now working as I wished. I enter a year and amount on my Search sheet, and any matches appear immediately: Nonetheless, after way too much work, I now have an Excel workbook that makes it very easy to find any of our historical transactions.
As it turns out, there is a way, but it's far from simple. I thought there must be a simple way to download your Amazon purchase history-once downloaded, I could use a spreadsheet to search my transactions. Recently I was trying to enter our Amazon purchase details into Quicken-the transactions download automatically, but they're generically assigned to "Shopping." I was using Amazon's order history page to match transactions and assign categories, but it was slow and painful going given the layout of the orders page. I'll see about modifying the spreadsheet to work directly with Amazon's data. For now, if you want to use my workbooks, keep using the Chrome extension. However, the data is in a completely different format than what's provided by the Chrome extension, so it needs to be massaged to work with my spreadsheet. Update: The Amazon export URL appears to be functional again, which is great news.
0 kommentar(er)
