export library list

[nazareno]

I am searching for a possibility in calibre how to export my huge library in a simple list form, which includes only the main meta-datas, as for example:
title, author, tag.
Preferably this list should be in .txt, .doc or some similar simple format.

I simply would like to see all my books in a compacted list which would be able to save and to export.

Thank you for your help!

[Gunnerp245]

Menu Convert Books/Create a catalog

[BetterRed]

Originally Posted by Gunnerp245

Menu Convert Books/Create a catalog

For a simple list, create a csv catalogue, import into a spreadsheet (MS Excel, LO Calc or GD Sheet) or word processor table (MS Word, LO Writer, GD Doc (??))

Or convert the CSV to HTML and then convert the HTML to EPUB/MOBI etc, there are lots of tools (many online) to convert CSV to HTML, I use this Windows utility ==>> CSVFileView - CSV file viewer and converter. It provides simple row sorting and column re-arranging.

BR

[theducks]

don't forget the CLI
calibredb --list

[nazareno]

thank you very much.
Seems not so easy though - Open office calc shows the csv-list in an odd form: you would find each word of the title etc in a new colum, so you can't do anything useful with it.

Theduck - could you please explain the calibredb option a little more detailed? Thank you

[theducks]

Originally Posted by nazareno

thank you very much.
Seems not so easy though - Open office calc shows the csv-list in an odd form: you would find each word of the title etc in a new colum, so you can't do anything useful with it.

Theduck - could you please explain the calibredb option a little more detailed? Thank you

It is explained in the Calibre Help site: CLI Section way better that I can

I used the CLI with OO long before the 'Catalog'.
Depending on your (switch) choices, you typically get a column per Calibre column

[BetterRed]

@nazareno - LO Calc (v 4.3.0.4) works fine for me

Attached is what I have in the CSV Import settings, which pops when I open a CSV file. The settings you see are the defaults.

BTW a csv file can be read into a Text Editor, e.g. Notepad++ (Windows), Text Wrangler (OSX), Vim (Linux).

BR

[eschwartz]

Very important to choose what separates columns. If your CSV Import settings tell OpenOffice/LibreOffice to treat spaces as a separator, you will end up with way too many columns.

[eschwartz]

Originally Posted by BetterRed

@nazareno - LO Calc (v 4.3.0.4) works fine for me

Attached is what I have in the CSV Import settings, which pops when I open a CSV file. The settings you see are the defaults.

BTW a csv file can be read into a Text Editor, e.g. Notepad++ (Windows), Text Wrangler (OSX), Vim (Linux).

BR

gedit (linux)



vim, if it likely to be used (you know if you are the type), is cross-platform, but isn't strictly necessary on linux. For most people, gedit or similar clones is far more suitable.

[BetterRed]

Originally Posted by eschwartz

gedit (linux)



vim, if it likely to be used (you know if you are the type), is cross-platform, but isn't strictly necessary on linux. For most people, gedit or similar clones is far more suitable.

I wasn't being proscriptive, NP++, Text Wrangler, & Vim were the first 3 that came to mind, could have just as easily wrote - BowPad, TextMate, and Emacs. I suppose I should've spelt out exempli gratia in full

Main thing is that it supports LF only end ends, hence notepad's no good as it wants CRLF

Not familiar with gmate.

IMO - the csv catalogue does need a couple of options a) Separator character, I'd probably use '^', and b) a Normalise date checkbox (i.e adjust for timezone offset), default to checked.

BR

[nazareno]

Thank You, BetterRed, this was the solution - just click the 'Komma'-Option.
Now it's simply perfect!