Expression >
Forums Home
>
Expression Studio Forums
>
Expression Media
>
How do you convert MS Excel Document data to Exif or IPTC metadata
How do you convert MS Excel Document data to Exif or IPTC metadata
- I have several thousand records for art prints (titles of images and date, photographers name, edition etc) listed in an MS Excel document and want to convert this to metadeta, or upload it directly to Expression, or preferably Lightroom or Aperture.I wanted to know if there was a way of importing/exporting this data into the metadata, or will I have to manually key they lot! Yawn!Best wishes,J
Answers
J,
What a delightful username - not.
Your choices include the following:
- Develop a script to read the contents of your spreadsheet and add them to your images. Beyond all but the most determined coders. Any solution would be specific to your spreadsheet so even if someone else has developed something it would be difficult to amend to your requirements.
- Pay for someone who has done the above to help you - see http://www.beardsworth.co.uk/iview.php for xlTransformer, which may do what you want.
- Convert your spreadsheet into XML. It needs to be in the exact format Expression Media can use for its XML Import function. Tricky to do and again only for the most dedicated.
- Use the spreadsheet to create a DOS batch file (or Mac equivalent) containing the necessary commands to allow ExifTool to add your data to your images. Tricky, but easier than coding the above two options. Once the data is in the images you then catalogue them into Expression Media.
- Do it manually by typing it all in to Expression Media. This is the easiest option, but probably the most time-consuming.
Ian
- Marked As Answer byAnita OakleyMSFT, ModeratorFriday, July 03, 2009 6:15 PM
All Replies
J,
What a delightful username - not.
Your choices include the following:
- Develop a script to read the contents of your spreadsheet and add them to your images. Beyond all but the most determined coders. Any solution would be specific to your spreadsheet so even if someone else has developed something it would be difficult to amend to your requirements.
- Pay for someone who has done the above to help you - see http://www.beardsworth.co.uk/iview.php for xlTransformer, which may do what you want.
- Convert your spreadsheet into XML. It needs to be in the exact format Expression Media can use for its XML Import function. Tricky to do and again only for the most dedicated.
- Use the spreadsheet to create a DOS batch file (or Mac equivalent) containing the necessary commands to allow ExifTool to add your data to your images. Tricky, but easier than coding the above two options. Once the data is in the images you then catalogue them into Expression Media.
- Do it manually by typing it all in to Expression Media. This is the easiest option, but probably the most time-consuming.
Ian
- Marked As Answer byAnita OakleyMSFT, ModeratorFriday, July 03, 2009 6:15 PM
- Thanks Ian,you are genius.BTW the user name just came to mind after spending 40 minutes on the phone with MS customer services.Best wishes,J
A friend of mine has written a script to read data from Excel sheets and put them in the fields of corresponding Expression Media records. He'll be able to help you.
