• Global community
    • Language:
      • Deutsch
      • English
      • Español
      • Français
      • Português
  • 日本語コミュニティ
    Dedicated community for Japanese speakers
  • 한국 커뮤니티
    Dedicated community for Korean speakers
Exit
3

Is It possible for a script to export photoshop or AI information into an excel sheet or text file?

Community Beginner ,
Jun 22, 2023 Jun 22, 2023

Copy link to clipboard

Copied

Im looking for a script that can record in a text file (preferably excel sheet) what the width and hieght is of a image file at a specifc give size. It the operation could batch for all images in a folder that would be ideal. 

Ex.1
Image File: 6x4
at 45": 45x30
at 36": 36x24
at 26": 26x17


Im not even sure if something like this can be made but  any assistance to finding a answer would be greatly appriciated! 

TOPICS
Actions and scripting , macOS , Windows

Views

142

Translate

Translate

Report

Report
Community guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
community guidelines

correct answers 1 Correct answer

Community Expert , Jun 22, 2023 Jun 22, 2023

To start:

 

https://prepression.blogspot.com/2016/08/extracting-metadata-to-csv.html

 

https://community.adobe.com/t5/photoshop-ecosystem-discussions/script-to-change-name-of-document-to-its-size-tag-and-save-overwrite/td-p/11736503

 

________

 

Edit: I just updated the previously mentioned blogpost to include the script from Mars Premedia and now Blogger has disabled the post! Here it is in full for now...

 

________

 

There are five common methods for extracting/exporting metadata from one or

...

Votes

Translate

Translate
Adobe
Community Expert ,
Jun 22, 2023 Jun 22, 2023

Copy link to clipboard

Copied

To start:

 

https://prepression.blogspot.com/2016/08/extracting-metadata-to-csv.html

 

https://community.adobe.com/t5/photoshop-ecosystem-discussions/script-to-change-name-of-document-to-...

 

________

 

Edit: I just updated the previously mentioned blogpost to include the script from Mars Premedia and now Blogger has disabled the post! Here it is in full for now...

 

________

 

There are five common methods for extracting/exporting metadata from one or more files to a comma separated value (.csv) or tab delimited text file.

 

Adobe Bridge Script – Extract Metadata, by Paul Riggott:

https://www.ps-scripts.com/viewtopic.php?f=72&t=24358&sid=6529114a378b6e37ff888bf74ba105cf

 

Adobe Bridge Script – Barred Rock Script “BSExportMetadata”:

http://creativescripting.net/blog/2009/01/free-stuff/ or

https://metadatatocsv.wordpress.com/scripts/

 

Adobe Bridge Script – VRA Panel Export-Import Tool

http://metadatadeluxe.pbworks.com/w/page/48025141/VRA%20Panel%20Export-Import%20Tool

 

Adobe Photoshop Script – Images Report, by Mars Premedia

https://www.marspremedia.com/software/photoshop/images-report

 

ExifTool – by Phil Harvey:

http://www.sno.phy.queensu.ca/~phil/exiftool/

http://www.sno.phy.queensu.ca/~phil/exiftool/exiftool_pod.html

 

An example of using ExifTool to write all metadata to a .csv file on the desktop using the source directory titled “test” on the desktop (the following code would be entered into Terminal.app on the Mac or the Command Prompt in MS Windows):

 

exiftool -r -all -csv '/Users/loggedinusername/Desktop/test' > '/Users/loggedinusername/Desktop/metadata-out.csv'

 

This code is formatted for the Mac OS, MS Windows would use straight double quote marks “ and the expected \ file path formatting. 

 

Of course, the flipside of exporting metadata is to import metadata, which is also a feature of ExifTool. For an Adobe Bridge solution, try the VRA Panel Export-Import Tool or Paul Riggott’s Do It Yourself Metadata Input script (also here) and for Photoshop there is Keywords from CSV from Mars Premedia.

 

Votes

Translate

Translate

Report

Report
Community guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
community guidelines
Community Beginner ,
Jun 26, 2023 Jun 26, 2023

Copy link to clipboard

Copied

LATEST

Thanks @Stephen_A_Marsh  for those links!  

I was actually able to find a script that gave me the information on a image in a .csv format (https://www.marspremedia.com/software/photoshop/images-report) . From there I was able to maniplate the the data to get my expected results!  

Votes

Translate

Translate

Report

Report
Community guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
community guidelines