How to copy and paste certain metadata fields into excel- or export them

[ChrisM]

Hi

I am trying to isolate certain metadata fields- ie filename. file size photo date and description and export them to an excel or csv file. I am in Grid view- with description added
I tried copy- it PS alerted me that I had copied 65 files to the clipboard, but paste is greyed out.

I found a script that gave me an error. I found add script from repository- exif tool metadata output- but all 65 files were then presented in a window with ALL metadata, and again I couldn't find how to export.

I am starting to feel like by UI skills are deficient.

[Hert]

It's not that difficult:

1. Select the thumbnails (or rows in your case) that you want to export metadata for
2. Right click on a selected thumbnail/row
3. Metadata -> Export Metadata to CSV File

Is that what you need?

Ps. If you only want to copy file names then:
1. Select thumbs/rows
2. Right click -> Run Script from Repository-> File System -> Copy Filename to Clipboard

[ChrisM]

Hi

Thanks so much as always for your help.
One small issue: I had filename, description and keywords showing in my catalog- i did get a csv usinig the method 1 above- but the csv instead of giving me filenames gave me file path? It wasn't clear how to adjust?

And the second method above for filename select- copy and paste- also paste shows the file path not file name.... I would prefer filename if possible?

Cheers,
Christina

[Hert]

One small issue: I had filename, description and keywords showing in my catalog- i did get a csv usinig the method 1 above- but the csv instead of giving me filenames gave me file path? It wasn't clear how to adjust?

You can create a custom field (macro type) and add %filename there. Then you can select that to be included in your export

And the second method above for filename select- copy and paste- also paste shows the file path not file name.... I would prefer filename if possible?

There is now a script to:
1. Copy File Name to Clipboard
2. Copy File Path to Clipboard
3. Copy Folder Name to Clipboard

Use the new "Copy File Name to Clipboard" with right click -> Run Script from Repository -> File System

Hope that helps