I'm trying to gear up for Kindle lending and one of the things I want to do is to export my list of Kindle books from my Media Library or Your Orders section in Manage Your Kindle on Amazon into a Word or Excel document. I have read posts on the Amazon Kindle forum that people have done this but they don't/won't say how, which is annoying. Apart from Bufo Calvin and a few others over there, you'd think every trick was a state secret, grump, grump. 

Right now I'm stuck with opening each book in the Your Orders section, seeing if it is one that I can lend, and doing a Copy/Paste into a Word document. Since I've got, oh, about 1200 books there, this may truly take me the rest of my life. 

Ideas? Suggestions? Thank you! 

Amazon is having site issues right now. I was going to try it out for you but will have to wait until they are back in order.

In the meantime Im going to THE giant used book sale at the fairgrounds so will mess around with it when I get back. If I ever get back.

AND I DID IT...You need to have all your books in Calibre. Then go to Convert Books/Create Catalog of Books (its in the little down arrow next to the icon)in your library and it will convert what's in there to a .csv file.

Be careful. It asks you where you want to store the file and defaults to the parent directory- you can change this - make sure its somewhere you can find it!

I highlighted all my books (click and drag) then opened word ctrl+v to paste.  It wll look something like below.  The only book out of the 4 that can be loaned is Benjamin Franklin.  I have Word on view 2 pages, so I could get a snapshot of the entire page. 

Cons:

1. You can only do this by page, I can't see a way to increase how many per page.

2.  It copies everything pictures and other info you may not want.  However, highligting and deleting info you don't want is easy, though time consuming.

Ugh. OK. So really no easy way, is there.  I downloaded Calibre again. 1200 books to put in. Maybe I'll start tomorrow. :-) 

Thanks for the help, folks, I really do appreciate it! So far very few of my books will be available to lend, but I see St. Martin's Press is allowing it, so maybe I'll be able to offer some mysteries. 

Why couldnt Amazon make lending more easier?  This is beyond my brain...ugh

Oh, it's easy enough to lend. You just need someone's email address and it's very straightforward, just like Nook lending.

I'm trying to build my own little database of books that I can lend, one that I can keep on my own computer (compulsive list-maker, that's me) and it's a bit of a tedious process. I've never used Calibre to its full capability, just used it for conversions, so I'm starting from scratch after 3 years of ereading and about 1200 books from Amazon. Poor me. Poooor me. LOL! It'll give me something to do during the last dark dreary days of winter. 

Well Marilyn I started using it more because you liked it! Now I think if you plug in your kindle It will "see" what is on the device, then you can just go down the list and check them and it will add them to your database. it's been a couple weeks since I did this and I've been preoccupied but I will be off for a couple weeks after minor surgery next week and I will fool around with it then.

Ok!!  So how do you find out which books you Can Lend?  Everytime I got to the Amazon page its Down grr

Barbara, unfortunately, it doesn't show on the Kindle the way it does on the Nook. You have to go to your Manage Your Kindle page, Your Orders section and hit the + sign next to each book. Or you can look up the books you've bought on the individual book's page, and down with the publishing information it will say if it's lendable. People have been having some trouble with Amazon pages the last day or so I hear, although I've been navigating around there just fine. I sometimes have trouble with my internet connection when there's bad weather out east. 

Kathy, you know the definition of minor surgery? Surgery that's being done on someone else. Best wishes to you for speedy healing. 

I'll try that, try plugging it in. I really like Calibre for conversions, which is what I used it for, changing metadata as needed, and also occasionally for fetching news for me but I never used it to organize my library, didn't see the need. Freezing rain forecast for tomorrow, maybe I'll try then. Thank you! 

Turns out I couldnt find the "botton" to lend cause NONE of the books I paid for had it grrr  8 pages & only 8 books Lendable.  They were freebies thru Amazon for the past month.      Thanks Marilyn!!

To get your Amazon books into a Word doc:

1) Login to your Amazon account

2) Scroll down to the Digital Content section and click on Your Collection

3) In the View dropdown, choose Kindle Items then click the Print icon

4) When the Print dialog comes up, cancel it

5) Press ctrl+a (select all), then ctrl+c (copy the selected text)

6) Open a Word document and press ctrl+v (paste the copied text)

Thank you, Cathy! Worked like a charm. This gives me title, author, and date acquired when I do a paste unformatted. With a regular paste I get all that plus the cover art. Excellent. Thank you! 

ah ha!  thanks Cathy!

a slightly different way to use that would be go to Your Collection the same way, select Kindle items (either in View, or from the Your Collection tab), and then in those button in the top left, select the leftmost one for Thin View.  then you basically have a table that you can copy & paste directly into Excel.  unfortunately, as amazon seems to collapse the information as you scroll, it appears you'd have to copy one screenful at a time and you can't just do the whole table at once.  [at least when i tried it, using Firefox and Excel.]  it does copy the pictures and stuff though, so what i would do is paste all the pages into a temp spreadsheet, then copy just the interesting columns (title and creator) into another spreadsheet, then discard the temp spreadsheet without saving changes.  you can even do a Paste Special and select values during that step if you want the titles not to be links.

however, it does appear you still have to go through one at a time to find out if each book is lendable.  though once you had the list set up and saved, you could just add whatever was new once in a while.

You're both welcome!

I also played with the thin view Ellen, and found that I couldn't get the whole thing. It's one of those infinite scrolling grids, which I hate (I just had a "discussion" about those with my software design team at work the other day.)

In order to copy them all at once, they all have to appear in a single browser window. The only way I could get that was to do the print trick, though now I'm wondering what would happen if I turn off JavaScript. Maybe they'd give me the whole table then. I'll try that later on.

THANK YOU Cathy and Ellen!! 

Because of that one grid showing at a time copy crap - an infinite scrolling grid, huh? - it took a few copy/pastes, but now I have my kindle books up to date in one Excel spreadsheet.  If I keep the Excel chart up to date I should have an easy time copying these from now on - I just don't dare fall behind!

Kindle Book List in my library only shows 15 books at a time on Amazon site - which for me would take forever to copy/paste or print out page by page then go back through and check lendable status of each book since its over 500 pages worth - however - shelfari has a feature that allows you to simply import your Amazon purchases (books of course) if I don't crash my browser in the process. Once the books are in shelfari they can be exported to a .csv format which Excel will open and then saved as a regular Excel ss document. Still have to go back and check the lendable status but better than doing the copy/past or print and checking lendability on a gigantic library of ebooks.