Skip to main content
A
Angel25979808g6uh
Participant
June 23, 2023
Answered

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

  • June 23, 2023
  • 1 reply
  • 599 views

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! 

    This topic has been closed for replies.
    Correct answer Stephen Marsh

    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 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.

     

    1 reply

    Stephen Marsh
    Community Expert
    Stephen MarshCommunity ExpertCorrect answer
    Community Expert
    June 23, 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 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.

     

      A
      Angel25979808g6uhAuthor
      Participant
      June 26, 2023

      Thanks @Stephen 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!  

        Terms & ConditionsAccessibility statement
        Using the community Terms of use Privacy Cookie preferences Do not sell or share my personal information ad choicesAdChoices