For anyone coming to this thread the following info should easily clear up how to create a list of the books in your calibre library. Below are quotes from this thread.
First itimpi points to a great sticky post that outlines precisely how to create a catalog of the books in your library using the feature built into calibre. When you get to this link be sure to click on the spoiler buttons for more in depth explanations.
Quote:
Originally Posted by itimpi
|
The sticky post above explains all options for creating a catalog. If an actual list is desired it tells you to use CSV format. Once you have the catalog in CSV format what do you do? itimpi explains below.
Quote:
Originally Posted by itimpi
If you create a CSV file then you can load the results into any spreadsheet program, arrange the results into the format you prefer and print that.
|
BetterRed goes a step further and explains that a CSV file can also be opened in a simple text editor if spreadsheets are too daunting. Or he adds maybe a simple ebook version of the books would suffice.
Quote:
Originally Posted by BetterRed
CSV (Comma Separated Variables) is useful if you have a spreadsheet program like Excel and you're familiar with using it, or you have a text editor that can lay out a CSV as a list of fixed width columns.
Try one of the ebook formats (AZW. EPUB or MOBI)
|
More info to clarify some of the items you'll come across when usnig CSV format.
Quote:
Originally Posted by BetterRed
Depending which format you choose you then have the option of selecting what and how to group in the second tab, when you select CSV option in Create Catalog you can select the columns you want 'printed'
You can read the CSV file into Libre Office Calc, maybe you can import it into Libre Office Writer as a Table
|
In case it is still unclear maybe a list of instructions may clear it up.
Quote:
Originally Posted by PeterT
- Click on the ARROW besides the CONVERT BOOKS icon at the top of the screen
- Select the CREATE A CATALOG OF THE BOOKS IN YOUR CALIBRE LIBRARY
- For CATALOG FORMAT on the OPTIONS tab select CSV
- Supply a NAME for the CATALOG TITLE
- In the CSV/XML options tab select what FIELDS you want to include in your catalog
- Click the OK button at the bottom of the screen
You will see a spinning ICON in the bottom right of the calibre screen while a job runs to make the catalog
When this job ENDS, you will be prompted for a location to store this catalog.
That file can now be opened via a tool like EXCEL or Open Office and printed. |
Once you get the CSV file if you are confused the link provided below will guide you to a forum that can help you import the CSV file into Libre Office Calc.
Quote:
Originally Posted by BetterRed
- save the csv file someplace
- open the csv you just saved someplace in Office Calc
- arrange columns and widths to suit and hit the Print button
- If you need help with Libre Office Calc then I suggest you enquire at this forum ==>> http://libreofficeforum.org/
|
If all of the above is just too much maybe a different perspective. The below link takes you to the Calibre user's manual covering the catalog creation feature.
Quote:
Originally Posted by DoctorOhh
|
If you have the CSV file and the forum to which you were previously referred to isn't any help then maybe a Google search could shed some light on importing the CSV file into a spread sheet.
Quote:
Originally Posted by DoctorOhh
|
If the CSV file is still too complicated but you have been able to create an ePub version of your catalog there is still hope of printing out a list. Below suggests an ePub to PDF conversion might be worth a try. Once in PDF format, Adobe Acrobat Reader can be used to print out the list.
Quote:
Originally Posted by DoctorOhh
Non of those are going to go to Libre Writer. To print convert to PDF with the PDF output set to the correct paper size. Then print the PDF.
|
Just for good measure lets remind everyone now that the CSV file can be opened in a simple text editor. It might be worth a shot.
Quote:
Originally Posted by BetterRed
the csv file is in fact a text file, so open it in notepad, replace all the commas with four spaces and print it (probably best to use landscape orientation) - it won't be very pretty - but you will have 300 lines at say 30 lines a page so it should be about 10 pages.
|
Below are recent Testimonials from folks that have followed these instructions:
Quote:
Originally Posted by holleydl
Dear Peter (& all helpers),
I've been trying to develop an Excel datasheet of my books in a simple list like this for about a year. I've followed all the other members questions, and the answers provided by all of the kind and patient helpers.
Seriously, God bless you for stating this in terms that even I could follow, and make it happen.
I now have a simple list of 8,001 books that I can sort by author (first) name or title, that I can open on my computer or Kindle Fire!!! And, by knowing this simple method, I will just delete each list and replace it with each new addition to my library.
You rock friend... Thank you so very much.
Dan H
|
You're Welcome Dan, the kind folks here are always ready to lend a hand.
Quote:
Originally Posted by alanHd
you have been given correct and useful advice by multiple users, it has just taken me two minutes to create a csv. file of my books and open it in open office.
|
alanHd I'm glad after reading the directions you were able to produce a suitable list.
To those that find this info helpful all we ask is that you pass on your newly acquired knowledge to those that follow.
