Discussion Forums - eBook readers eBook readers

Topic: Is there an easy way to export Kindle Library list into Word or Excel?

Club rule - Please, if you cannot be courteous and respectful, do not post in this forum.
  Unlock Forum posting with Annual Membership.
Subject: Is there an easy way to export Kindle Library list into Word or Excel?
Date Posted: 2/13/2011 8:31 AM ET
Member Since: 11/24/2005
Posts: 5,638
Back To Top

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! 

Date Posted: 2/13/2011 9:35 AM ET
Member Since: 4/23/2007
Posts: 9,515
Back To Top

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.

Date Posted: 2/13/2011 9:57 AM ET
Member Since: 4/23/2007
Posts: 9,515
Back To Top

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!



Last Edited on: 2/13/11 10:01 AM ET - Total times edited: 2
Date Posted: 2/13/2011 10:17 AM ET
Member Since: 5/14/2009
Posts: 6,852
Back To Top

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.

NewPicture9.jpg

Date Posted: 2/13/2011 6:56 PM ET
Member Since: 11/24/2005
Posts: 5,638
Back To Top

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. 

Date Posted: 2/13/2011 9:32 PM ET
Member Since: 10/7/2007
Posts: 7,751
Back To Top

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

Date Posted: 2/13/2011 11:23 PM ET
Member Since: 11/24/2005
Posts: 5,638
Back To Top

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. 

Date Posted: 2/14/2011 9:30 PM ET
Member Since: 4/23/2007
Posts: 9,515
Back To Top

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.

Date Posted: 2/14/2011 9:54 PM ET
Member Since: 10/7/2007
Posts: 7,751
Back To Top

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

Date Posted: 2/14/2011 10:38 PM ET
Member Since: 11/24/2005
Posts: 5,638
Back To Top

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! 



Last Edited on: 3/4/11 9:26 PM ET - Total times edited: 1
Date Posted: 2/15/2011 3:43 AM ET
Member Since: 10/7/2007
Posts: 7,751
Back To Top

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!!

Cathy A. (Cathy) - ,
Date Posted: 2/15/2011 9:07 PM ET
Member Since: 12/27/2005
Posts: 4,135
Back To Top

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)

 

Date Posted: 2/15/2011 9:40 PM ET
Member Since: 11/24/2005
Posts: 5,638
Back To Top

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! 

Date Posted: 2/16/2011 1:19 AM ET
Member Since: 1/19/2008
Posts: 14,777
Back To Top

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.



Last Edited on: 2/16/11 1:20 AM ET - Total times edited: 1
Cathy A. (Cathy) - ,
Date Posted: 2/16/2011 10:28 AM ET
Member Since: 12/27/2005
Posts: 4,135
Back To Top

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.

M.E. (ryenke) -
Date Posted: 2/16/2011 11:34 AM ET
Member Since: 1/6/2009
Posts: 625
Back To Top

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!

 

Subject: Cataloging Kindle Library
Date Posted: 2/2/2014 2:02 AM ET
Member Since: 7/25/2007
Posts: 1
Back To Top

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.