Inspiring

Answered

Export Metadata to Excel

Forum|Forum|7 years ago
November 24, 2018
7 replies
24098 views

I am using Lightroom 5 as a standalone app on my Windows based computer. I have some selected metadata in my "creditline" field that I need to export to Excel. Right now I am having to copy the metadata from each image to the clipboard and paste it into an Excel spreadsheet, which is very time consuming and tedious.

It looks like the Lightroom export feature will only export photo files. Does anyone know of a Lightroom plug-in that will allow me to export my metadata to a .csv, .txt or Excel file?

This topic has been closed for replies.

Correct answer Niesha Arya

Please try this https://alloyphoto.com/plugins/export-list/ download and install it once done click export > enable export list

use the trail for 30 days after that you need to buy it.

Niesha AryaCorrect answer

Adobe Employee

Please try this https://alloyphoto.com/plugins/export-list/ download and install it once done click export > enable export list

use the trail for 30 days after that you need to buy it.

S

Susan CD

Participant

worked great until it didn't. vendor not response so far....

S

Susan CD

Participant

Vendor not responsive after 4 requests; paid for plug in that worked for four months.

S

stevej72342657

Participating Frequently

Hi everyone,

I just spotted this post from 2019 and I wonder if someone can answer ,why would you want or need to export all your keywords out of LRC?

I`m intrigued because you can now do this easily in the latest version 12.2, and I found out about this when watching a YT video going through all the new things in 12.2 and the presenter went into detail as to how you could now do this easily, but didnt say why you would want to do this.

I wonder if I`m missing out on a feature that might be super useful to me?

Kind regards

Steve

johnrellis

Legend

You could always export keywords from LR as a structured tab-separated file -- LR 12.2 made it easier to import the output into Excel by using a better structure in the format of the file that's more friendly for Excel.

There are many reasons for wanting to export the keyword list:

- Share the keywords with another LR catalog or another application.

- Use the more capable features of a text editor to examine your keyword hierarchy for consistency, spelling, redundant keywords, etc., e.g. with its Find command or spelling corrector.

- To count the number of keywords to see if you've exceeded the Windows LR limit of about 1500 (all sorts of strange things happen when you do).

S

stevej72342657

Participating Frequently

Hi John, Thank for answering my question.

I understand a bit more now about something that until only a few weeks ago I`d never heard of. I guess after you Export your keywords list and spell check it you then re-import it back into LRC? That YT video only mentioned Exporting not Importing.

Cheers

Steve

johnrellis

Legend

"Does your plug in work with the latest version of Adobe Photoshop Lightroom(3.1)? I am not seeing anywhere to add PlugIns in this version."

Unfortunately, the cloud version of Lightroom doesn't support plugins. Only Lightroom Classic (the original Lightroom) allows plugins.

johnrellis

Legend

The List View developer John Beardsworth is already on this thread and is very responsive about his plugins, so I expect he'll reply soon. I just did a quick test using List View to export filename and keywords and I didn't get the error. You might try restarting LR and then trying again -- I've seen similar errors fixed by restarting.

johnrellis

Legend

"I'm also trying to find a way to export metadata, specifically keywords. Cmgap, does Bridge have a solution for me?"

If you're looking for a Lightroom solution, see this previous reply: https://community.adobe.com/t5/lightroom-classic/export-metadata-to-excel/m-p/10177858#M127812

If you're looking for a Bridge solution, you'll get more authoritative answers faster if you post in the Bridge forum instead: https://community.adobe.com/t5/bridge/bd-p/bridge

J

jackibee

Participant

Thanks, John. I'm in process of troubleshooting an error I'm receiving when I use the trial version of ListView. If it can be resolved, this might be my product. I've written the developer, but if anyone else has experienced it and has a solution, here's the issue:

I've downloaded a trial version and tried to export 20 photos to Excel or as a CSV file. I received this error message:

menu_list.lua:908: attempt to concatenate global 'fileName' (a nil value)

My naming protocol looks like this:

20190904_servicedesk.jpg

What might be the issue with my file naming that causes the error? I'm running LightRoom Classic 8.4.1 Release.

cmgap

Community Expert

Do you use Bridge?

Jeff A. GouldenAuthor

Inspiring

I do not use Bridge, just stand-alone Lightroom.

johnrellis

Legend

At least four plugins will export metadata as a .csv or .tsv: LR/Transporter, List View, Any Filter, and Data Explorer. They provide much different additional functionality, so you might look at all four before picking the one that best meets your needs.

Jeff A. GouldenAuthor

Inspiring

It looked like LR/Transporter and List View might do what I wanted so I installed both plugins to Lightroom. When I tried exporting metadata on a few files, neither program made any sense to me and didn't export anything. I tried reaching out for some technical help but so far no reply.

All I want to do is select a group of files in Lightroom and export one metadata field "Creditline" to a singel Excel or .csv file. It seems like an easy thing to do.

john beardsworth

Community Expert

Well, you didn't contact me, so it's unrealistic to expect a reply.

ListView opens as a list, and has an Excel button.

Sign up

To post, reply, or follow discussions, please sign in with your Adobe ID.

Sign in to Adobe Community

To post, reply, or follow discussions, please sign in with your Adobe ID.

Scanning file for viruses.

This file cannot be downloaded