3 Replies Latest reply: Nov 14, 2012 10:02 AM by john beardsworth RSS

    keyword file format with {synonyms} is too finicky

    nahcr Community Member

      I just created a 4000 term keyword file, hierarchically organized.  i used excel to create the organization.  this was not an easy task because it seems that lightroom requires a file organized to look like this

      main keyword

                     subkeyword

                               subsubkeyword {synonym}

      main keyword2

                     subkeyword2

                          subsubkeyword2

                               subsubsubsubkeyword {synonym}

       

      etc

      my original excel file looked like this

      main keyword        subkeyword          subsubkeyword                                        {synonym}

      main keyword2      subkeyword2       subsubkeyword2 subsubsubkeyword {synonym2}

       

      It was not easy to get all of the synonyms lined up with the final subkeyword, because the hierarchy length varied.  I couldnt just remove repeated tabs because the keywords had to have repeated tabs to end up at the right level.

       

      it would be great if lightroom could use a more standard spreadsheet format.  Of course, perhaps there is a simpler way that i am overlooking.