Authors Calibre to Exel in a CSV file

[Koosr1946]

I have a library in Calibre with a lot of different authors.
How can I put these authors in a CSV file so I can access them in Excel?
One record per author.
I'm not a professional, so I don't understand everything. Please use simple language.

[Sirtel]

Right-click on Convert Books -> Create Catalog, select the csv format and check the fields you want. You can't do it one record per author this way, though. Maybe there's another way.

[Comfy.n]

Not sure I understand the OP intent, but it reminds me what @chaley implemented here:

https://www.mobileread.com/forums/sh...0&postcount=19

To use it, make a stored template named whatever you want -- I use "get_one_book_per_field_value".

BTW chaley has a great gift of simplifying instructions. For beginners, I would add this: to make a stored template, you need to open Preferences -> Template Functions.

After creating the stored template, paste this into calibre's search box then run the search:

template:"""program: get_one_book_per_field_value('authors')#@#:b:yes"""

(then create the catalog as Sirtel instructed)

[Koosr1946]

Originally Posted by Sirtel

Right-click on Convert Books -> Create Catalog, select the csv format and check the fields you want. You can't do it one record per author this way, though. Maybe there's another way.

Thanks for the information, it works but if there are more books from an author, I get more of the same records whit the author's name.

Is it possible to change that

Sorry for my english

[Koosr1946]

Originally Posted by Comfy.n

Not sure I understand the OP intent, but it reminds me what @chaley implemented here:

https://www.mobileread.com/forums/sh...0&postcount=19

To use it, make a stored template named whatever you want -- I use "get_one_book_per_field_value".

BTW chaley has a great gift of simplifying instructions. For beginners, I would add this: to make a stored template, you need to open Preferences -> Template Functions.

After creating the stored template, paste this into calibre's search box then run the search:

template:"""program: get_one_book_per_field_value('authors')#@#:b:yes"""

(then create the catalog as Sirtel instructed)

Thanks for your answer but it is to difficult for a 80 years old man

[Sirtel]

Originally Posted by Koosr1946

Thanks for the information, it works but if there are more books from an author, I get more of the same records whit the author's name.

Is it possible to change that

Sorry for my english

No, it isn't possible, unless you follow Comfy.n's instructions.

[Koosr1946]

Originally Posted by Sirtel

No, it isn't possible, unless you follow Comfy.n's instructions.

It is good so, I have a list of all authors and by import to Exel I was able to have the duplicates removed.
The number of authors is nov exactly correct.

I wish you all a verry good Christmas and a happy 2026

[Sirtel]

Originally Posted by Koosr1946

It is good so, I have a list of all authors and by import to Exel I was able to have the duplicates removed.
The number of authors is nov exactly correct.

I wish you all a verry good Christmas and a happy 2026

Many thanks, and to you too!