Amazon does not make it easy to get a list of the e-books you own, especially if you want to put the list into a spreadsheet. This solution uses a javascript bookmarklet, a small piece of code that you drag and drop onto your bookmark tool bar in your browser.
Below is the code, and below that is a link containing the code that you can drag to the bookmark toolbar.
books = window.open();
books.document.open();
books.document.write("<html><head></head><body>");
$("div.contentTableListRow_myx").each(function()
{
books.document.write( $(this).find("div[bo-text='tab.title']").attr('title') +" | ");
books.document.write( $(this).find("div[bo-text='tab.author']").attr('title') +"<br>");
});
books.document.write("</body></html>");(drag this to your bookmarks bar or right-click and add to bookmarks)
Once you have the bookmarklet installed you need to log into your amazon account and go to the “content and devices” page.
Make sure the “show all books” indicators are set, and that all of your books are listed on the page. Then click on the bookmark on your bookmark toolbar.
A new window will open showing all of your books.
You can copy and paste the list into a word document or a spreadsheet.
I used the bookmarklet generator at http://benalman.com/code/test/jquery-run-code-bookmarklet/