MobileRead Forums
Register Guidelines E-Books Today's Posts Search

Go Back   MobileRead Forums > E-Book Software > Calibre
Reload this Page List authors in Excel

Notices

Reply
 
Thread Tools Search this Thread
Old 06-30-2023, 03:40 AM   #1
Koosr1946
Member
Koosr1946 began at the beginning.
 
Posts: 15
Karma: 10
Join Date: Sep 2020
Device: Kobo Clara
List authors in Excel
Is it possible to get a list of all authors in Exel?

I need only the name and not the books
Koosr1946 is offline   Reply With Quote
Old 06-30-2023, 03:42 AM   #2
ownedbycats
Custom User Title
ownedbycats ought to be getting tired of karma fortunes by now.ownedbycats ought to be getting tired of karma fortunes by now.ownedbycats ought to be getting tired of karma fortunes by now.ownedbycats ought to be getting tired of karma fortunes by now.ownedbycats ought to be getting tired of karma fortunes by now.ownedbycats ought to be getting tired of karma fortunes by now.ownedbycats ought to be getting tired of karma fortunes by now.ownedbycats ought to be getting tired of karma fortunes by now.ownedbycats ought to be getting tired of karma fortunes by now.ownedbycats ought to be getting tired of karma fortunes by now.ownedbycats ought to be getting tired of karma fortunes by now.
 
ownedbycats's Avatar
 
Posts: 10,983
Karma: 75337983
Join Date: Oct 2018
Location: Canada
Device: Kobo Libra H2O, formerly Aura HD
Create Catalog option, CSV option, select only authors. You'll need to de-dupe it though.
Last edited by ownedbycats; 06-30-2023 at 03:45 AM.
ownedbycats is offline   Reply With Quote
Old 06-30-2023, 03:45 AM   #3
BetterRed
null operator (he/him)
BetterRed ought to be getting tired of karma fortunes by now.BetterRed ought to be getting tired of karma fortunes by now.BetterRed ought to be getting tired of karma fortunes by now.BetterRed ought to be getting tired of karma fortunes by now.BetterRed ought to be getting tired of karma fortunes by now.BetterRed ought to be getting tired of karma fortunes by now.BetterRed ought to be getting tired of karma fortunes by now.BetterRed ought to be getting tired of karma fortunes by now.BetterRed ought to be getting tired of karma fortunes by now.BetterRed ought to be getting tired of karma fortunes by now.BetterRed ought to be getting tired of karma fortunes by now.
 
Posts: 21,733
Karma: 29711016
Join Date: Mar 2012
Location: Sydney Australia
Device: none
See calibredb list-categories command ==>> list_categories

BR
BetterRed is offline   Reply With Quote
Old 06-30-2023, 03:46 AM   #4
ownedbycats
Custom User Title
ownedbycats ought to be getting tired of karma fortunes by now.ownedbycats ought to be getting tired of karma fortunes by now.ownedbycats ought to be getting tired of karma fortunes by now.ownedbycats ought to be getting tired of karma fortunes by now.ownedbycats ought to be getting tired of karma fortunes by now.ownedbycats ought to be getting tired of karma fortunes by now.ownedbycats ought to be getting tired of karma fortunes by now.ownedbycats ought to be getting tired of karma fortunes by now.ownedbycats ought to be getting tired of karma fortunes by now.ownedbycats ought to be getting tired of karma fortunes by now.ownedbycats ought to be getting tired of karma fortunes by now.
 
ownedbycats's Avatar
 
Posts: 10,983
Karma: 75337983
Join Date: Oct 2018
Location: Canada
Device: Kobo Libra H2O, formerly Aura HD
Quote:
Originally Posted by BetterRed View Post
See calibredb list-categories command ==>> list_categories

BR
This is a better option
ownedbycats is offline   Reply With Quote
Old 06-30-2023, 04:04 AM   #5
BetterRed
null operator (he/him)
BetterRed ought to be getting tired of karma fortunes by now.BetterRed ought to be getting tired of karma fortunes by now.BetterRed ought to be getting tired of karma fortunes by now.BetterRed ought to be getting tired of karma fortunes by now.BetterRed ought to be getting tired of karma fortunes by now.BetterRed ought to be getting tired of karma fortunes by now.BetterRed ought to be getting tired of karma fortunes by now.BetterRed ought to be getting tired of karma fortunes by now.BetterRed ought to be getting tired of karma fortunes by now.BetterRed ought to be getting tired of karma fortunes by now.BetterRed ought to be getting tired of karma fortunes by now.
 
Posts: 21,733
Karma: 29711016
Join Date: Mar 2012
Location: Sydney Australia
Device: none
Quote:
Originally Posted by ownedbycats View Post
This is a better option
Is that because it will work - I'm not sure your solution will produce anything useful.

BR
BetterRed is offline   Reply With Quote
Old 06-30-2023, 04:10 AM   #6
Sirtel
Grand Sorcerer
Sirtel ought to be getting tired of karma fortunes by now.Sirtel ought to be getting tired of karma fortunes by now.Sirtel ought to be getting tired of karma fortunes by now.Sirtel ought to be getting tired of karma fortunes by now.Sirtel ought to be getting tired of karma fortunes by now.Sirtel ought to be getting tired of karma fortunes by now.Sirtel ought to be getting tired of karma fortunes by now.Sirtel ought to be getting tired of karma fortunes by now.Sirtel ought to be getting tired of karma fortunes by now.Sirtel ought to be getting tired of karma fortunes by now.Sirtel ought to be getting tired of karma fortunes by now.
 
Sirtel's Avatar
 
Posts: 13,483
Karma: 239219543
Join Date: Jan 2014
Location: Estonia
Device: Kobo Sage & Libra 2
Quote:
Originally Posted by BetterRed View Post
Is that because it will work - I'm not sure your solution will produce anything useful.

BR
Catalog in csv will certainly produce a list of authors or any other category that can be used in Excel. I've used it several times.
Sirtel is offline   Reply With Quote
Old 06-30-2023, 04:31 AM   #7
ownedbycats
Custom User Title
ownedbycats ought to be getting tired of karma fortunes by now.ownedbycats ought to be getting tired of karma fortunes by now.ownedbycats ought to be getting tired of karma fortunes by now.ownedbycats ought to be getting tired of karma fortunes by now.ownedbycats ought to be getting tired of karma fortunes by now.ownedbycats ought to be getting tired of karma fortunes by now.ownedbycats ought to be getting tired of karma fortunes by now.ownedbycats ought to be getting tired of karma fortunes by now.ownedbycats ought to be getting tired of karma fortunes by now.ownedbycats ought to be getting tired of karma fortunes by now.ownedbycats ought to be getting tired of karma fortunes by now.
 
ownedbycats's Avatar
 
Posts: 10,983
Karma: 75337983
Join Date: Oct 2018
Location: Canada
Device: Kobo Libra H2O, formerly Aura HD
Quote:
Originally Posted by BetterRed View Post
Is that because it will work - I'm not sure your solution will produce anything useful.

BR
I tested it - I got the author names. Unfortunately, there were a zillion duplicate author names.
ownedbycats is offline   Reply With Quote
Old 06-30-2023, 04:39 AM   #8
Koosr1946
Member
Koosr1946 began at the beginning.
 
Posts: 15
Karma: 10
Join Date: Sep 2020
Device: Kobo Clara
I'm happy that you will help me, but I don't know how to begin to do this:
Create Catalog option, CSV option, select only authors. You'll need to de-dupe it though.

I hope you are a little patient because i'm a man of 76 years
Koosr1946 is offline   Reply With Quote
Old 06-30-2023, 04:59 AM   #9
Sirtel
Grand Sorcerer
Sirtel ought to be getting tired of karma fortunes by now.Sirtel ought to be getting tired of karma fortunes by now.Sirtel ought to be getting tired of karma fortunes by now.Sirtel ought to be getting tired of karma fortunes by now.Sirtel ought to be getting tired of karma fortunes by now.Sirtel ought to be getting tired of karma fortunes by now.Sirtel ought to be getting tired of karma fortunes by now.Sirtel ought to be getting tired of karma fortunes by now.Sirtel ought to be getting tired of karma fortunes by now.Sirtel ought to be getting tired of karma fortunes by now.Sirtel ought to be getting tired of karma fortunes by now.
 
Sirtel's Avatar
 
Posts: 13,483
Karma: 239219543
Join Date: Jan 2014
Location: Estonia
Device: Kobo Sage & Libra 2
Quote:
Originally Posted by Koosr1946 View Post
I'm happy that you will help me, but I don't know how to begin to do this:
Create Catalog option, CSV option, select only authors. You'll need to de-dupe it though.

I hope you are a little patient because i'm a man of 76 years
Right-click on the Convert button -> select Create Catalog. Then select CSV from the drop-down menu. Click on the CSV options tab.
Sirtel is offline   Reply With Quote
Old 06-30-2023, 05:13 AM   #10
Koosr1946
Member
Koosr1946 began at the beginning.
 
Posts: 15
Karma: 10
Join Date: Sep 2020
Device: Kobo Clara
Sorry, I don't see CSV

Is ik possible to add a JPG
Koosr1946 is offline   Reply With Quote
Old 06-30-2023, 05:39 AM   #11
theducks
Well trained by Cats
theducks ought to be getting tired of karma fortunes by now.theducks ought to be getting tired of karma fortunes by now.theducks ought to be getting tired of karma fortunes by now.theducks ought to be getting tired of karma fortunes by now.theducks ought to be getting tired of karma fortunes by now.theducks ought to be getting tired of karma fortunes by now.theducks ought to be getting tired of karma fortunes by now.theducks ought to be getting tired of karma fortunes by now.theducks ought to be getting tired of karma fortunes by now.theducks ought to be getting tired of karma fortunes by now.theducks ought to be getting tired of karma fortunes by now.
 
theducks's Avatar
 
Posts: 31,064
Karma: 60358908
Join Date: Aug 2009
Location: The Central Coast of California
Device: Kobo Libra2,Kobo Aura2v1, K4NT(Fixed: New Bat.), Galaxy Tab A
Quote:
Originally Posted by Koosr1946 View Post
Sorry, I don't see CSV

Is ik possible to add a JPG
Change the Catalog Format. See the little down arrow: That means more choices
Then you can set The choices on the CSV,XML... TAB)
theducks is offline   Reply With Quote
Old 06-30-2023, 05:46 AM   #12
Sirtel
Grand Sorcerer
Sirtel ought to be getting tired of karma fortunes by now.Sirtel ought to be getting tired of karma fortunes by now.Sirtel ought to be getting tired of karma fortunes by now.Sirtel ought to be getting tired of karma fortunes by now.Sirtel ought to be getting tired of karma fortunes by now.Sirtel ought to be getting tired of karma fortunes by now.Sirtel ought to be getting tired of karma fortunes by now.Sirtel ought to be getting tired of karma fortunes by now.Sirtel ought to be getting tired of karma fortunes by now.Sirtel ought to be getting tired of karma fortunes by now.Sirtel ought to be getting tired of karma fortunes by now.
 
Sirtel's Avatar
 
Posts: 13,483
Karma: 239219543
Join Date: Jan 2014
Location: Estonia
Device: Kobo Sage & Libra 2
Quote:
Originally Posted by Koosr1946 View Post
Sorry, I don't see CSV

Is ik possible to add a JPG
Here is the pic
Attached Thumbnails
Click image for larger version Name: 30-06-2023 12-43-31 (2).jpg Views: 100 Size: 283.0 KB ID: 202368  
Sirtel is offline   Reply With Quote
Old 06-30-2023, 05:52 AM   #13
Koosr1946
Member
Koosr1946 began at the beginning.
 
Posts: 15
Karma: 10
Join Date: Sep 2020
Device: Kobo Clara
With the help of a plug-in I have a csv file with all authors

A lot of thanks for everybody and a nice weekend
Koosr1946 is offline   Reply With Quote
Reply

Tags
exel

« Previous Thread | Next Thread »

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
How to Export a list of Tags to Excel tsundoku Library Management 2 03-31-2023 06:05 PM
Export library list to excel ayjay3 Calibre 2 08-07-2020 10:15 AM
KIndle Content - excel list GrandClaude Library Management 3 01-26-2018 12:35 PM
Export list to excel? Belle2Be Library Management 7 01-15-2014 06:14 AM
Create a list of authors-titles for Excel? bigjaba Library Management 5 06-25-2013 10:56 PM


All times are GMT -4. The time now is 11:31 AM.

Contact Us - FAQ - Guidelines - Privacy - Top

MobileRead.com is a privately owned, operated and funded community.