Add existing booklist to calibre.

byingme · 12-28-2013, 09:39 AM

I have a book history list from my local library which uses 'Overdrive' software in its online site. There are over 550 books in the list that I have already read.
I would like to add/incorporate this into calibre so that I can avoid duplicating ebooks that I have already read.

Is there a way to add/merge this list into calibre?

I also have it in MS Excel format with just 'title' and 'author' so that I can print the list when I go to the library to check out new reads.

So, I don't want to download and convert these books....I just want to incorporate the list into calibre.

Is that possible?

Loosheesh · 12-28-2013, 10:48 AM

Quote:

Originally Posted by byingme

Is there a way to add/merge this list into calibre?

Check out the Import List plug-in; it may be helpful.

byingme · 12-30-2013, 06:23 PM

Import List plug-in seems to merge Title and Author fields into Title field in the default book list....what now?

BetterRed · 12-30-2013, 07:25 PM

@byingme - save the excel spreadsheet as a csv, suggest you use ';' as the separator (titles often have comma's), then import the csv - see attachment

BR

eschwartz · 12-31-2013, 01:42 PM

Quote:

Originally Posted by BetterRed

@byingme - save the excel spreadsheet as a csv, suggest you use ';' as the separator (titles often have comma's), then import the csv - see attachment

BR

Or quote the "Title, with, a, comma". Spreadsheets should do this automatically.

byingme · 01-03-2014, 10:39 AM

Using ";" in a CSV worked. Thank you for the help...I was getting verrrry frustrated.

12-28-2013, 09:39 AM	#1
byingme Junior Member Posts: 3 Karma: 10 Join Date: Dec 2013 Device: Nook Simple touch	Add existing booklist to calibre. I have a book history list from my local library which uses 'Overdrive' software in its online site. There are over 550 books in the list that I have already read. I would like to add/incorporate this into calibre so that I can avoid duplicating ebooks that I have already read. Is there a way to add/merge this list into calibre? I also have it in MS Excel format with just 'title' and 'author' so that I can print the list when I go to the library to check out new reads. So, I don't want to download and convert these books....I just want to incorporate the list into calibre. Is that possible?

12-30-2013, 07:25 PM	#4
BetterRed null operator (he/him) Posts: 21,660 Karma: 29711016 Join Date: Mar 2012 Location: Sydney Australia Device: none	@byingme - save the excel spreadsheet as a csv, suggest you use ';' as the separator (titles often have comma's), then import the csv - see attachment BR Attached Thumbnails

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
calibre - Not using existing metadata from *.opf files when Add books	rolandt99	Library Management	19	06-15-2020 04:43 PM
Sigil crashes when Add Existing Files.	frichrdsn	Sigil	2	05-28-2013 06:35 PM
Fonts - can't 'add existing file'	spinningdoc	Sigil	6	05-27-2012 03:09 AM
[?] Add downloaded tags not overwrite existing?	random43743	Calibre	7	01-11-2011 12:34 AM
Add'l formats for existing book(s)	jxh11215	Calibre	11	03-24-2010 04:13 PM

12-30-2013, 06:23 PM	#3
byingme Junior Member Posts: 3 Karma: 10 Join Date: Dec 2013 Device: Nook Simple touch	Import List plug-in seems to merge Title and Author fields into Title field in the default book list....what now?

01-03-2014, 10:39 AM	#6
byingme Junior Member Posts: 3 Karma: 10 Join Date: Dec 2013 Device: Nook Simple touch	Using ";" in a CSV worked. Thank you for the help...I was getting verrrry frustrated.

Advert

Advert