11. January 2015 · Comments Off on Exporting a list of bought and borrowed Kindle books from Amazon · Categories: Programming · Tags: , , , ,

This is a very quick-and-dirty method to pull all the books that Amazon knows you have bought or borrowed for your Kindle. There are various ways to export the list of purchased books from Amazon but I read a lot of e-books from the library and couldn’t find a way to export those. (Oct 20th, 2016 Update: Fixed code after Amazon tweaked their layout – thanks for letting me know, Annie!

(click here to hide directions)

Directions:

This is not a very simple process. At a high level we need to log into Amazon, find the page that lists all the books, and then copy the HTML code that makes up that page. Finally paste that code into the text box below and it will create a table listing the titles, authors and the date purchased or borrowed.

  1. Go to Amazon’s "Manage Your Content and Devices (you may have to log into Amazon). If the link doesn’t work, go to amazon.com and click "Your Account" and then "Manage Your Content and Devices".
  2. Scroll to the very end. Amazon only loads a few books to the screen at a time. If you want them all then scroll down, wait for the page to get more books, and then scroll down again. Eventually it will stop adding new books which means you’re at the end.
  3. You need to view the source code behind this webpage but, because Amazon dynamically loads the list of books, you can’t just use View Source. Instead you need to get to the Developer Tools, which is <F12> on most browsers. Once you do this, you should see a new frame come up on the bottom of your screen.
  4. In the new frame (which is the developer tools), there should be an icon with a box and an arrow pointing to that box, typically on the top-left of the new frame. Hovering your mouse over this will say something like, "Select Element". Click this button, and move your cursor up to the main window. When you put your mouse over something, it will turn blue. Move your mouse basically to the middle of the screen (so you’re over a book title) and then move it slowly left until the entire table of books is highlighted. Click (left-click). The text in the bottom frame will probably jump and a line will be highlighted.
    Select Element
  5. In the bottom frame, right-click on the highlighted line and select "Copy" or "Copy Inner HTML" depending on your browser.
    Copy Code
  6. Come back to this (the parser) screen, click in the text area below and Paste. You should get a big bunch of code pasted in the box.
  7. Click the "Parse" button and, if all goes well, a table below will appear with your information!
  8. You can easily copy and paste the table into Excel or other spreadsheets if you prefer to save the data locally that way.

(click here to hide directions)

Paste the code from Amazon’s "Manage Your Content and Devices” page here:





(paste data and click "Parse")

Title Author Date Purchased / Borrowed
(data not yet loaded)    

Comments closed.