MobileRead Forums - View Single Post - Import and update author, title, and other metadata

KnotHolme · 07-07-2018, 10:50 PM

I have a library that has grown over time to a few thousand books. My standards for the library have also evolved over time and now I find that I would like to go back and clean up a lot of the data. This will include changes to authors, titles and other metadata (genre, tags, ratings, comments, etc).

I have used the "Create a catalog of books" function to export a CSV file containing all the data I would like to update.

My question is, is there a way to edit the data in the CSV file - including all of the columns mentioned above - and then re-import it into Calibre and have it make the appropriate updates? Making all the changes manually using the Metadata editor screen will be, given the number of books needing updating, very painful. Given the presence of an ID and UUID field in the export CSV, I believe that the CSV does contain the information needed to accurately determine which book in the library each line in the CSV refers to even if author and title are altered.

Is this do-able?

Thanks!

07-07-2018, 10:50 PM	#1
KnotHolme Junior Member Posts: 8 Karma: 10 Join Date: Jul 2018 Device: Nook Color, Samsung Tab A6, Kindle	Import and update author, title, and other metadata I have a library that has grown over time to a few thousand books. My standards for the library have also evolved over time and now I find that I would like to go back and clean up a lot of the data. This will include changes to authors, titles and other metadata (genre, tags, ratings, comments, etc). I have used the "Create a catalog of books" function to export a CSV file containing all the data I would like to update. My question is, is there a way to edit the data in the CSV file - including all of the columns mentioned above - and then re-import it into Calibre and have it make the appropriate updates? Making all the changes manually using the Metadata editor screen will be, given the number of books needing updating, very painful. Given the presence of an ID and UUID field in the export CSV, I believe that the CSV does contain the information needed to accurately determine which book in the library each line in the CSV refers to even if author and title are altered. Is this do-able? Thanks!