Best Black Friday deals 2015 live blog: When is Black Friday & what are the best tech Black Friday…
I have recently purchased a Kindle Paperwhite, to complement my wife's two year old one. She has been complaining for some time about my purchase of books - not just for the Kindle. Having conceeded some time ago that we need to make a list of the 2 - 3,000 or so we have I have noticed that the Kindle can download documents to it. So I have been thinking about doing a book list. However what we need to do is to get the book list and then arrange it alphabetically. This I know how to do in Excel, but if we make the list in Excel, I will then have to copy/paste it into a word document, because Excel files can not be downloaded on to the Kindle. However this means EVERY time we buy another book we will have to enter it into the spreadsheet, sort the list, copy/paste that into a word document, and downlaod it onto the Kindle. Yup, a bit cumbersome, but the only way I can see of doing it. However, I can see two other possible solutions, which I hope one of you very kind people may be able to help me with.
As it is a Word document to be downloaded, it would be more sensible to have the list of the books in a Word document, sort it and then do the download. The only option with this is, try as I might I can not find a way of sorting a Word file as one can an Excel file. Can this sorting be done in Word?
The second option would be to get a PDA/organiser sort of unit. BUT I can only find ones that are either less than £10 or over £300. I do not wish to sound mean but £300 is a little much just for a list of books!!! For something that will take about - say - 6 - 8,000 books, authors, title, whether we have it in physical form or on a Kindle, whether we have read the book, and is it worth reading again I am willing to pay a reasonable sum, but I can not find one, does anyone know or can reccomend one that is not too expensive? I think these have gone out of fashion which is why I am having the trouble I am, but if someone could point me in the direction of one I would be very grateful!!
Many thanks in anticipation.
Broken link, copy and Paste!
You could keep the list in an Excel file and sort it as required and then copy and paste the results of the sorted list into a Word document and save it.
When you have to update your list of books, do so to the Excel file and then repeat the sort, copy and paste process.
If you need to resort to a PDA, why not use a netbook, with Wondows 7, which you should be able to obtain for about £200 - £250? Load it with Libre Office and you should be able to do all that you want.
Peter: this from the OP...
"This I know how to do in Excel, but if we make the list in Excel, I will then have to copy/paste it into a word document, because Excel files can not be downloaded on to the Kindle. However this means EVERY time we buy another book we will have to enter it into the spreadsheet, sort the list, copy/paste that into a word document, and downlaod it onto the Kindle."
"The second option would be to get a PDA/organiser sort of unit. BUT I can only find ones that are either less than £10 or over £300. I do not wish to sound mean but £300 is a little much just for a list of books!!!"
Err, why make a word doc list to put on the kindle?
Kindle can sort/index books either by: Most Recent First, Author, Title or Collection. (collection is a folder (index) you make and add whatever books you want to - I have made my own collections/folders not just for authors name but also for series and also folders for 'Finished These' and a couple of other ones.
You could create a table in Word and sort that.
If you want to keep the books and 'Library list' on your pc or on a separate ext harddrive without having to do any typing of all the titles etc. This is what I do and use in conjunction with my kindle:
Free library management program http://calibre-ebook.com/about
Not perfect but you can edit the comments for a book in the Calibre Library and covert books etc. and transfer books to and from your kindle (but not the comments only the actual book file) (obviously it can't transfer a 'kindle collection folder' as that is really just an index file on the kindle)
I also have the Kindle app on my pc (free from Amazon) but don't use that much as find that Calibre does what I want.
Good Afternoon, AGAIN, Gentlemen. This is my second attempt at posting. I shall write this in Word and copy-paste on to the site. The first attempt was just wiped out!
SillBill I will checkout your suggestion
Peter I think your post has been answered by Ian in Northampton, many thanks for that.
lotvic Yes I know how to create a collection on the Kindle, I have all my books in at least one collection. The only drawback with that is that you need a copy of a book on the Kindle to be able to do anything with it. What I didn’t make clear was that we wish to list an author and ALL his books, determine which we want or note that we have it. I am sorry I did not make this clear. Your second suggestion is something I will check out, though as it would appear to be what we want.
Woolwell I was not aware that tables could be sorted in Word. My wife is the Word ‘expert’ so I will have words with her and see how easy this is.
Gentlemen, once again many, many thanks for your posts. It is really worthwhile asking a question on here when you get so many replies that can help you sort out almost anything!!
Sort the Contents of a Table in WORD - enter link description here
I believe that the kindle can read PDF files.
MS Excel 2007-10 can be saved as a PDF file so why not save a PDF copy and transfer to your Kindle
This thread is now locked and can not be replied to.