Skip to main content
W
westk28239169
Participant
May 7, 2017
Answered

Transfer keywords from a Word table

  • May 7, 2017
  • 1 reply
  • 745 views

I have scanned approximately 1500 vintage family photographs.  I have documented the details of the images in a Microsoft word table.  Each image has a row in the table, with the columns containing information about the image.  For example, columns are 'file number', 'persons in image, listed left to right', 'comments written on image', 'comments about image', and 'scanning details'.  I would like the information for each image to appear as keyword data, so a future user could search the images by keyword.  What is the easiest way to transfer the words from the table to the associated images?  Thanks.

    This topic has been closed for replies.
    Correct answer john beardsworth

    westk28239169  wrote

    I have scanned approximately 1500 vintage family photographs.  I have documented the details of the images in a Microsoft word table.... What is the easiest way to transfer the words from the table to the associated images?

    Cut and paste, maybe. Or try https://www.photographers-toolbox.com/products/lrtransporter.php - you will have to convert the Word document to a CSV or tab-separated file first.

    John

    1 reply

    john beardsworth
    Community Expert
    john beardsworthCommunity ExpertCorrect answer
    Community Expert
    May 7, 2017

    westk28239169  wrote

    I have scanned approximately 1500 vintage family photographs.  I have documented the details of the images in a Microsoft word table.... What is the easiest way to transfer the words from the table to the associated images?

    Cut and paste, maybe. Or try https://www.photographers-toolbox.com/products/lrtransporter.php - you will have to convert the Word document to a CSV or tab-separated file first.

    John

    W
    westk28239169Author
    Participant
    May 19, 2017

    John -

    I saw your name in a related chain regarding the fact that LR forces keywords to be alphabetized.  I would prefer them not to be alphabetized.  Are keywords imported using Irtransporter rearranged by LR to be alphabetized?  Thanks again.

    johnrellis
    johnrellis
    Legend
    May 29, 2017

    Another question.  I discovered that one can apparently paste a rather lengthy set of text into the ' captions' metadata.  It also appears that the text is not changed by LR when exporting.  Furthermore, it appears that it is generally possible to search for images with specific words used in the captions metadata.  It also appears that the text is not always called 'captions' by various software used to view images.  In summary, it appears that entering text into 'captions' will meet my need to list persons in a photo from left to right, etc., and use search techniques to find images with specific names etc listed.    So the new question is:  can LRtransporter be used to import from a table into captions?

    Thanks again for your patience.


    LR/Transporter will import the captions from comma-separated values (CSV) file.  I don't believe Word can generate a CSV file -- you'd have to put your table of captions in Excel (or perhaps Google Docs) and then save the CSV file from there.  The free trial of LR/Transporter will let you try up to 10 files at a time, so you can make sure you've got a workflow that works for you before paying for the license.

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