![]() |
#1 |
Junior Member
![]() Posts: 6
Karma: 10
Join Date: Feb 2023
Location: PNW
Device: Kindle Oasis
|
How to Export a list of Tags to Excel
I had the same question (how do I export a list of all my tags?) and found some long threads on it. When I went to add how I did it to the thread, the Mobile Read UI suggested I create a new thread. So here are step-by-step instruction for how I did it in case it's helpful:
In Calibre - Add Books | Add Empty Book - Select the Empty Book - Edit Metadata - Open Tag Editor (button to the left of the Tags dropdown control) - Drag-select all the tags by holding down the CTRL key (in Windows) - Add all the tags by pressing the “>” button - Double-click on the tags control to select all the tags - Ctrl-C to copy them In Excel - Select an empty cell - CTRL-V to paste the list of tags into a single cell - Data | Text to Columns - Choose Delimited, Next - Select Comma, Unselect Tab, Next - Finish (you now have each tag in its own cell/column) - CTRL-SHIFT-Right Arrow (to select all the columns with tags) - CTRL-C to copy - Select a blank cell - Home | Paste | Transpose You now have your list of tags in a single column in Excel. |
![]() |
![]() |
![]() |
#2 |
Well trained by Cats
![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() Posts: 30,288
Karma: 57979022
Join Date: Aug 2009
Location: The Central Coast of California
Device: Kobo Libra2,Kobo Aura2v1, K4NT(Fixed: New Bat.), Galaxy Tab A
|
Easier
Get a SQLlite browser and export any table in metadata.db as CSV |
![]() |
![]() |
![]() |
#3 |
null operator (he/him)
![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() Posts: 20,858
Karma: 27620684
Join Date: Mar 2012
Location: Sydney Australia
Device: none
|
Even easier, use the calibredb list_categories feature ==>> https://manual.calibre-ebook.com/gen...ist-categories
BR |
![]() |
![]() |
![]() |
Tags |
excel, export, tags |
|
![]() |
||||
Thread | Thread Starter | Forum | Replies | Last Post |
Can you export a list of tags? | bhagerty | Library Management | 17 | 12-14-2022 04:00 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 catalog to Excel | myki | Library Management | 17 | 03-19-2015 01:19 PM |
Export list to excel? | Belle2Be | Library Management | 7 | 01-15-2014 06:14 AM |