Skip to main content
Adobe Photoshop Family

25 Messages

 • 

306 Points

Sat, Oct 17, 2020 7:33 PM

Lightroom Classic: Export metadata to CSV

It would be very useful if there would be an easy way to export metadata fields of an image or video of the catalogue to csv .

Specially for those of us that catalogue videos and keyword them we are asked to supply CSV files as Video files do not unfortunatelly include those metadata as IPTC as images. I wish it was this way.

Is there a simple way to export selected metadata as CSV

Thank you

www.cristianbaitg.com

Responses

30 Messages

 • 

894 Points

9 years ago

Are there any easy ways to export text from Lightroom?

For example, if I wanted to be able to export a text document with a list of file names, is that doable?

I'd love to be able to export assorted text and variables as text documents, CSV files, or even custom XML files according to pre-built templates. Any way to do this?
Note: This comment was created from a merged conversation originally titled Lightroom: Is there a way to export CSV, XML or other text from Lightroom?

86 Messages

 • 

1.3K Points

There are two plug-ins that can do this for you:
LR/Transporter
http://www.photographers-toolbox.com/...
and ListView
http://www.photographers-toolbox.com/...

25 Messages

 • 

306 Points

LR/Transporter looks complicated as hell . Listview seems much easier but I don't know if you can have full control on what fields you want to export.

www.cristianbaitg.com

53 Messages

 • 

1.8K Points

10 days ago

Perhaps this discussion will help.

25 Messages

 • 

306 Points

10 days ago

Yes I saw the thread. All the options beside Listview are overly complicated and don't want to loose a whole day trying plugins or software that should be as simple as selecting a group of files and with a button give the order export as CSV.

Listview is simple enough . I found a few quirks and hope that the author can explain if I am making something wrong, like being able to control what fields are exported to the CSV.

In any case I think that it would be a useful feature to include to lightroom as default.

 

In any case thank you for pointing into the discussion.

www.cristianbaitg.com

165 Messages

 • 

2.9K Points

Just bear in mind if exporting to CSV that if you use commas in descriptive text fields (e.g. captions, copyright) and as the separator, you may get errors when loading the exported metadata in whatever app you're creating the CSV for.

 

If you're savvy enough to prevent potential CSV issues, then this tool should be something to try: https://exiftool.org/ 

Champion

 • 

5.1K Messages

 • 

93.2K Points

"if you use commas in descriptive text fields (e.g. captions, copyright) and as the separator, you may get errors when loading the exported metadata in whatever app you're creating the CSV for."

 

These days, most apps that provide for CSV import/export follow the informal standards and allow commas and other special characters in fields. There are of course some poorly written apps that don't.

Champion

 • 

5.1K Messages

 • 

93.2K Points

"being able to control what fields are exported to the CSV"

 

ListView always displays 10 columns, and whatever is displayed is what gets exported. You can change the field in a column by clicking the down-triangle:

 

25 Messages

 • 

306 Points

Yes I saw that but what happens that I don't want 10 columns I just want 3 I would like to remove all the others. In your sample what if I want just the file name and title and want to remove (not change the field) of that column?

www.cristianbaitg.com

82 Messages

 • 

1.6K Points

10 days ago

As an alternative, how about instead if Adobe would give us a utility that would allow us to edit an XMP file?  XMP sidecar files are recognized way to exchange metadata between applications.  I would rather edit an XMP file that have to deal with all the hassles around CSV import and export.  Too many ways to make time-consuming mistakes and false tries.

165 Messages

 • 

2.9K Points

@phil_burton_7735307 Someone from Adobe can confirm, but XMP files are just text files, so you can use any text editor, provided you understand its structure (Adobe provides the XMP Toolkit for guidance: https://www.adobe.com/devnet/xmp.html ).

 

Or you can use Lightroom to modify individual photo's IPTC/EXIF metadata via its graphical user interface.

 

Or you can choose from many other tools already available (some paid, most free), but just be very mindful about what you're doing if they allow changes to multiple photos at once...

25 Messages

 • 

406 Points

9 days ago

This plugin may be more flexible and capable than Listview. Video metadata is quirky though so I'm not sure it will help with that issue. https://www.photographers-toolbox.com/products/lrtransporter.php 

25 Messages

 • 

306 Points

Thank you Linda. I looked at the how to texts of the plugin and found it very confusing so I tried Listview and I have to say it is quite easy to work with . I rather have simplicity than many features and Listview seems more straightforward

www.cristianbaitg.com

Champion

 • 

5.1K Messages

 • 

93.2K Points

9 days ago

Using Any Filter's Sort command to export metadata to CSV is pretty straightforward, and it gives you control over which fields get exported:

 

 

 
Click Add Sort Field to add a new column, then click the magnifying glass to select the field for that column.

 

 

(edited)

25 Messages

 • 

306 Points

Hello: Unfortunately Any Filter does not work with my system. I have excel 2007 and latest version of Lightroom. When save to CSV I get this format that is of no use to me. I have no clue of excel but I need the file name and beside it a column for every field I have selected, not in this format that is incomprehensible for me .

www.cristianbaitg.com

Champion

 • 

5.1K Messages

 • 

93.2K Points

Here are instructions for how to open a CSV file in Excel 2007:

https://support.microsoft.com/en-us/office/import-or-export-text-txt-or-csv-files-5250ac4c-663c-47ce-937b-339e391393ba 

 

See the second heading, "Import a text file by opening it in Excel".  

25 Messages

 • 

306 Points

I followed them Open with Excel and always get the screenshot. As I am no proficient with excel I prefer to look for a solution that is more straightforward . In Kyno for example I export CSV and it gets perfectly shown in columns. unfortunately Kyno works more than a browser and not a catalogue like Lightroom but I am looking for a straightforward solution that you can export and open in Excel and everything is showed in columns with every field a the top. In any case thank you for your help.

www.cristianbaitg.com

Champion

 • 

5.1K Messages

 • 

93.2K Points

Something's going wrong with your Excel 2007 -- Excel has always opened CSV files from the earliest versions.  

 

If you click the grey Excel button in List View, does it open in Excel correctly?

 

25 Messages

 • 

306 Points

You are showing me now Listview. with Listview with this plugin it shows fine in columns it is AnyFilter save to csv file that saves a weird file that I gave the screenshot. It also takes forever to open unless you open it from inside excel. The Listview plugin gives me no problems like Anyfilter, only that I think it is not possible to just disable the fields that I dont want if I don't want the 10 it has by default, it seems you can assign different fields but I have not figure out how to completely disable fields, only want to show the ones I want in the excel sheet.

www.cristianbaitg.com

Champion

 • 

5.1K Messages

 • 

93.2K Points

I suspect you may have been creating HTML files with List View, rather than CSV files. The green Excel button in List View creates an HTML file, while the grey Excel button creates a CSV file. Are you clicking the grey button (to produce a CSV file), and does it open properly in Excel?

25 Messages

 • 

306 Points

As I said Listview gives me no problem It is Anyfilter that I have problems with the CSV file.

www.cristianbaitg.com

Champion

 • 

5.1K Messages

 • 

93.2K Points

Yes, but are you clicking the green button or the grey button?

25 Messages

 • 

306 Points

In Anyfilter there are not any green or blue buttons Those are in Listview.

 

www.cristianbaitg.com

Champion

 • 

5.1K Messages

 • 

93.2K Points

In List View, are you clicking the green button or the grey button? In List View the green button makes an HTML file, while the grey button makes a CSV file.   I'm worried that you're clicking the green button and not in fact making a CSV file.

25 Messages

 • 

306 Points

Ok I don't know at this point if we are talking different languajes and you don't understand me or I don't understand you. Listview is a lightroom plugin, CSV export works. Anyfilter is a different lightroom plugin CSV export does NOT work with this one. 

www.cristianbaitg.com

Champion

 • 

5.1K Messages

 • 

93.2K Points

I'm trying to help you get to a solution that works best for you, whether it's with List View or another plugin.  You say that List View export is working for you, but I'm worried that in fact it isn't doing what you think it is.  I suspect you may be clicking the List View green button, not the grey button, and what you're seeing in Excel 2007 is an HTML file, not a CSV file.

 

Thus, are you clicking the green button or the grey button in List View?   

 

 

 

 

165 Messages

 • 

2.9K Points

Hi John! Having re-read the threads above, I think Cristian is saying that when the metadata is exported using the Any Filter app, he's able to select the 3 metadata fileds he wants but the resulting export (which he expects to be CSV) is not being displayed in separate columns in Excel 2007 like other CSV files.

 

However, with the Listview app, he's getting the various metadata fields from the CSV export file to display as expected in separate columns in Excel 2007. But he doesn't yet know how to get Listview to export only the 3 metadata fields he'd like to choose (rather than the 10 he sees being displayed by default). That's the question he asked just above this sub-thread.

 

So, he needs either of the following:

  • how to get Any Filter to export to a straightforward CSV text file, as it doesn't seem to be doing so (question on this sub-thread); -OR-
  • how to get Listview to export only 3 user-selected metatdata fields (question from the other sub-thread above)?

Hope this helps...

(edited)

25 Messages

 • 

306 Points

Green button:

Grey button

www.cristianbaitg.com

25 Messages

 • 

306 Points

I am no expert in excel csv etc but I am just guessing that the agency want to see the green button as for me the information is clear here. I might be wrong because they ask for CSV but to me the CSV export option (grey) seems totally confusing and does not give usable information at all. Again I might be wrong and when they ingest the for me incomprehensible csv file it automatically extracts the data and it gets translated to Caption,description and keywords into their files info so clients can search for the clips.

www.cristianbaitg.com

165 Messages

 • 

2.9K Points

I think that's what John was trying to explain above. It looks like the Listview's grey button exports to another format besides CSV (e.g. HTML), which gives the same mangled result as Any Filter when you open the export file in Excel 2007.

 

Until you get a solution for Any Filter, perhaps you can use Listview as follows to get what you want:

Hope this workaround helps...

25 Messages

 • 

306 Points

Thank you. I also think that right now until something better comes along its the best solution. It's really pity that you cannot discard the fields you want in Listview. It seems from the outside it should be very easy to do so but maybe not, plugins have their limitations. 

Someday the IPTC video metadata coalition might get through the main software producers to adopt an universal video IPTC . Until then we are stucked with more convoluted methods. 

Best

Cristian

www.cristianbaitg.com

Champion

 • 

5.1K Messages

 • 

93.2K Points

The core issue is unrelated to either Listview or Any Filter: Your Excel 2008 (very old) is not opening CSV files as formatted columns.  Both plugins are producing correctly formatted CSV files, but your Excel 2008 isn't opening them properly.   You can verify the files are correct by examining them closely and looking for the commas that separate the columns (CSV = "comma separated values").

If you harbor any remaining doubt, you could upload the files to this fee web site to view them:
https://www.convertcsv.com/csv-viewer-editor.htm 

Or use the free Google Docs (click the Open File Picker folder icon in the upper-right, then click Upload).

I'm sure that some more troubleshooting could resolve your Excel 2008 issue, since as I mentioned, Excel has always supported CSV files. Excel 2008 requires multiple steps to open a CSV file, as described in the help article I linked to, and it may be there's some subtlety in the steps that you're missing or that isn't documented. If you have a local IT person on hand, ask her to help you troubleshoot, or we can try to troubleshoot via this forum, which will take more time and patience, with lots of screenshots.

Your options going forward:

- Use List View's grey button, putting your desired columns first, and asking the agency to ignore the remaining columns.

- Use List View's green button, delete the unwanted columns from the spreadsheet, and do File > Save As to save the file as a CSV file (which you won't be able to view currently in your Excel 2008, without troubleshooting).

- Ask the Listview developer (John Beardsworth), an active participant in this forums, to enhance Listview to discard the unwanted columns.

- Ask the agency if they will accept an HTML file (Listview's green button). They may not, since their tools and processes may not be able to read it. 

- Use the Any Filter > Sort command.

(edited)

25 Messages

 • 

306 Points

Well I tried finally to open it with Office online that is free (latest version)and the same problem happens. I attach image grab of both programs used to open the CSV file with Office online.

I am sorry to say but this plugins to export CSV sheets for Lightroom just don't work. Maybe they have not been updated in a long time and if so I hope Adobe remarks on them that they might not works as intended as it seems is the case.  I wish it was not this way but they do not export CSV files properly..

In any case thank you for your help. I will try to find another way or software to export CSV files from Lightroom and if it is not possible I will have to use KYNO even if it is not a database I can wrote metadata and perfectly export as CSV that are properly shown in columns.

(edited)

www.cristianbaitg.com

25 Messages

 • 

406 Points

Are you using a Paste command? You should be using File > Import and choose CSV File.

Champion

 • 

5.1K Messages

 • 

93.2K Points

4 days ago

All the evidence indicates the problem is very specific to your computer. The plugins are actively maintained and used by many, many others.  To troubleshoot this, please:

 

- Upload a Listview-generated .csv to Dropbox, Google Drive, Onebox, or similar and post the sharing link here. With a sample file, I most likely can narrow down the problem with your computer.

 

- Copy and paste the first ten lines from LR's menu command Help > System Info, which will tell us exactly which version of LR and Windows/Mac you're running.

 

I tested Listview and Any Filter on two computers running LR 10, one Windows and one Mac. I successfully opened the Windows LR and Mac LR .csvs in Windows Excel Office 365, Mac Excel Office 365,  Office.com Excel, Google Sheets, and Dropbox.  See the screenshots below:

25 Messages

 • 

406 Points

4 days ago

Rather than Open with Excel, can you just go to the File menu in Excel? Choose Import... and then select CSV file and choose your .csv file.

Champion

 • 

5.1K Messages

 • 

93.2K Points

Cristian has already tried that: https://feedback.photoshop.com/conversations/lightroom-classic/lightroom-classic-export-metadata-to-csv/5f8b470535f40c45ff5755e4?commentId=5f8c871bc17a065683f95a89&replyId=5f8c94bd72a09d3b07501bd7

There is something strange specific to his computer that is causing CSVs to be written by LR in such a way that other programs can't open them.  Without knowing his version of LR and Windows/Mac, and without having one of the problem CSVs, it's hard to guess what that might be. Perhaps the CSVs are getting encoded in UTF-16 for some bizarre reason caused by an old version of Windows, or a bug in LR is causing a caption or keyword to get written to the CSVs that contains an invalid character.