Help with export re: isbns

[Jnassise]

I'm interested in exporting my 4000+ book library into a csv file for import into Goodreads.

Without realizing it, I seem to have collected both isbns and Amazon ASINs automatically into the ISBN field of my database (perhaps through auto download of metadata?)

Is there a way to bulk edit the isbn field so that only one isbn is contained in it? I'd rather not do this by hand with a library of this time. (Or, conversely, is there a way to clean up the csv file so that Goodreads will accept it?)

Thanks,
Joe

[DoctorOhh]

Originally Posted by Jnassise

I'm interested in exporting my 4000+ book library into a csv file for import into Goodreads.
...
Or, conversely, is there a way to clean up the csv file so that Goodreads will accept it?

Between the sample CSV file provided on this page of the Goodreads site and the create a catalog feature (see attached) that will export the data you select as a CSV file you should be good to go.

Additionally once you do the major import you can keep your calibre library and Goodreads in sync using the Goodreads Sync plugin.

Good Luck.

[tilia]

You can remove the amazon ids using search&replace.

Select the books with amazon-ids, choose search&replace under edit metadata.

Search-mode: regular expressions
Search field: identifiers
Identifiers type: amazon
Search for: .*
and don't type anything in the replace field

This should remove Asins, and keep the isbns. But please backup your library before you try!

[DoctorOhh]

@Jnassise I may not have been clear in my previous post. You do not have to remove any identifiers because the create catalog feature will allow the exporting of just the ISBNs (see attached) to the CSV formatted catalog. You do not need to include all of the identifiers if you only choose isbn that is all that you will get. No amazon numbers will be in the created csv file.