Copying mobi file info from disc to excel

Clur · 11-12-2011, 09:46 AM

hi
My Dad has just been given a CD of 4000 free books for his Kindle. I wanted to create a full list for him that's grouped by author (the disk is A-Z on book title).
I thought I'd be able to look at the contents of the disk in my computer and copy the list and just paste in Excel but it just won't paste. I'm not great technically and I'm not sure if the data won't paste because of the .mobi file type or if it's a restriction on the disc.

Any help much appreciated as I really don't want to manually type a list of 4000 books!!!

Thanks

st_albert · 11-12-2011, 12:47 PM

I'm not sure what you're trying to copy, but if you want to get the directory of the CD into excel, just open a command prompt window and list the directory using the "dir" command. Then copy and paste it from the command window.

Or better still, redirect the output of "dir" to a text file like so:

Code:

dir d:\ >directory.txt

(assuming the CD is drive d:\) Then import the text file into excel.

HTH

HarryT · 11-13-2011, 03:14 AM

A somewhat unrelated warning - many of these CDs of "free" books are pirated; please do ensure that these really are public domain books and not pirated material.

Clur · 11-13-2011, 11:34 AM

Thanks st_albert, that's exactly what I needed. I've now got the full list in Excel so can start splitting the fields and sort by author A-Z rather than title A-Z. Much appreciated.

Thanks HarryT. I didn't know this was an issue, not sure how you establish if they're pirate or not. Have to get my dad to check with the person who gave him the CD.

Thanks again both, help is much appreciated.

HarryT · 11-13-2011, 11:45 AM

Quote:

Originally Posted by Clur

Thanks HarryT. I didn't know this was an issue, not sure how you establish if they're pirate or not. Have to get my dad to check with the person who gave him the CD.

Simply check to see if they are by living authors, or authors who have died more recently than 70 years ago. If they are all "classics" - Dickens, Eliot, Austen, etc - that's fine, but if you find Harry Potter, Twilight, Stephen King, etc, in there, it's illegal.

11-12-2011, 09:46 AM	#1
Clur Junior Member Posts: 2 Karma: 10 Join Date: Nov 2011 Device: Kindle	Copying mobi file info from disc to excel hi My Dad has just been given a CD of 4000 free books for his Kindle. I wanted to create a full list for him that's grouped by author (the disk is A-Z on book title). I thought I'd be able to look at the contents of the disk in my computer and copy the list and just paste in Excel but it just won't paste. I'm not great technically and I'm not sure if the data won't paste because of the .mobi file type or if it's a restriction on the disc. Any help much appreciated as I really don't want to manually type a list of 4000 books!!! Thanks

11-12-2011, 12:47 PM	#2
st_albert Guru Posts: 697 Karma: 150000 Join Date: Feb 2010 Device: none	I'm not sure what you're trying to copy, but if you want to get the directory of the CD into excel, just open a command prompt window and list the directory using the "dir" command. Then copy and paste it from the command window. Or better still, redirect the output of "dir" to a text file like so: Code: dir d:\ >directory.txt (assuming the CD is drive d:\) Then import the text file into excel. HTH

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
18MB EPUB converts to 40MB Mobi! What can I do to reduce Mobi file size?	perdman	Conversion	11	12-09-2017 04:18 AM
Update Mobi header/file metadata without doing a Mobi to Mobi conversion	RecQuery	Conversion	2	06-30-2012 11:43 AM
List of books on device/card exported to excel file	toby53	Library Management	2	04-26-2011 03:32 PM
Kindle Global file copying problems	johnes	Amazon Kindle	3	11-16-2009 02:58 AM
Correct missing author info in a Mobi file?	nekokami	Kindle Formats	5	12-15-2008 10:26 AM

11-13-2011, 03:14 AM	#3
HarryT eBook Enthusiast Posts: 85,544 Karma: 93383043 Join Date: Nov 2006 Location: UK Device: Kindle Oasis 2, iPad Pro 10.5", iPhone 6	A somewhat unrelated warning - many of these CDs of "free" books are pirated; please do ensure that these really are public domain books and not pirated material.

11-13-2011, 11:34 AM	#4
Clur Junior Member Posts: 2 Karma: 10 Join Date: Nov 2011 Device: Kindle	Thanks st_albert, that's exactly what I needed. I've now got the full list in Excel so can start splitting the fields and sort by author A-Z rather than title A-Z. Much appreciated. Thanks HarryT. I didn't know this was an issue, not sure how you establish if they're pirate or not. Have to get my dad to check with the person who gave him the CD. Thanks again both, help is much appreciated.

Advert

Advert