• Welcome to the Lightroom Queen Forums! We're a friendly bunch, so please feel free to register and join in the conversation. If you're not familiar with forums, you'll find step by step instructions on how to post your first thread under Help at the bottom of the page. You're also welcome to download our free Lightroom Quick Start eBooks and explore our other FAQ resources.
  • Stop struggling with Lightroom! There's no need to spend hours hunting for the answers to your Lightroom Classic questions. All the information you need is in Adobe Lightroom Classic - The Missing FAQ!

    To help you get started, there's a series of easy tutorials to guide you through a simple workflow. As you grow in confidence, the book switches to a conversational FAQ format, so you can quickly find answers to advanced questions. And better still, the eBooks are updated for every release, so it's always up to date.

Export Export Catalog Folder Structure to Excel

Joined
Apr 24, 2018
Messages
6
Location
Austin TX
Lightroom Experience
Intermediate
Lightroom Version
Classic
Lightroom Version
9.3
Operating System
macOS 10.15 Catalina
I have a series of collections in a folder structure. I'd like to export that structure to an excel sheet. I' want to create a checklist of metadata I need to add to each folder and file. So, for example I have a series of scans with no date and no location. I'd like to methodically go through the entire collection and include all the data I decide I need. Then I check off that folder and move to the next one, and so on. Until I'm done. Without the checklist, I'll never know if I'm done. Export just at the folder level is all that is needed. The screen shot attached is part of the Collection folder structure. Thx much in advance. BTW, there's probably 600-700 folders
 

Attachments

Joined
May 9, 2015
Messages
639
Location
Palo Alto, CA
Lightroom Experience
Power User
Lightroom Version
Classic
Just for reference, containers in the Collections Panel are called "Collection Sets" (not folders even though they look and act like folders). When you use the word "Folder" in relation to LrC, we think you're talking about what you see in the "Folders" panel.

If the purpose of the Excel is merely to function as a check list, it is much easier to use "Folder" or "Collection Set" color labels to mark the ones you've completed as shown in this screen shot for the circled collection (Asia) for which I added a "red" color label. You can apply them to Collections, Collection Sets, and folders by right clicking on the item and selected from the context menu.

1596071461525.png
 
Joined
Apr 24, 2018
Messages
6
Location
Austin TX
Lightroom Experience
Intermediate
Lightroom Version
Classic
Thx for your reply. Much appreciated. I’ve used these color tags in the past and work great for single flags. I’m updating up to a dozen metadata items and need to track which ones are completed. In some cases I may be in the Map module just geotagging a set of images then move to date time editing, them move to keyword editing, the camera type etc. I’ve got about 90,000 images to update, many are scanned.
 
Joined
May 9, 2015
Messages
639
Location
Palo Alto, CA
Lightroom Experience
Power User
Lightroom Version
Classic
two things come to mind.
1) [Old school] Screen shot the LrC panel, print it on paper. use pencil to mark as desired

2) [New school] Use keywords on images as you go.

Even though your situation is a bit different than mine (I don't need to reset date/time or camera info) but is basically the same, you can take a look at a blog I wrote to aid me in managing my workflow and showing me very clearly what images have missed which steps. Right now (due to the Stay at Home orders) I'm pretty caught up but you can see my Smart Collections that will show me immediately what images have missed - or are in need of - which steps. As you can see below, there are 4 images that need a geo tag, need a "shoot" group keyword, need "location" group keywords, Need IPTC location info, and I haven't rated or stacked. There are also 683 two star images without a subject keyword (my current project), etc. You can read my blog on how I do this here: https://www.danhartfordphoto.com/blog/2013/5/lr004-use-lightroom-smart-collections-keywords-for-workflow

1596299879915.png
 
Joined
Apr 24, 2018
Messages
6
Location
Austin TX
Lightroom Experience
Intermediate
Lightroom Version
Classic
Thx Dan , this is very helpful. Appreciate all the footwork here. Been taking pictures since 1968 so I have a good collection of film plus digital. I see you're in Palo Alto. I'm in Austin, but originally from San Mateo.
 
Top