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

Post Reply
ChrisM
Posts: 18
Joined: 24 May 22 18:57

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

Post by 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.
Attachments
Screen Shot 2022-11-14 at 11.48.09 AM.png
Screen Shot 2022-11-14 at 11.48.09 AM.png (2.78 MiB) Viewed 125 times
Hert
Posts: 7400
Joined: 13 Sep 03 6:24

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

Post by 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
This is a user-to-user forum. If you need product support then please send a message
ChrisM
Posts: 18
Joined: 24 May 22 18:57

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

Post by 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
Posts: 7400
Joined: 13 Sep 03 6:24

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

Post by Hert »

ChrisM wrote: 16 Nov 22 16:56One 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
This is a user-to-user forum. If you need product support then please send a message
Post Reply