Skip to main content
M
Muhammad Wase38076271idl6
Participant
October 17, 2024
Question

How to Match and Place Image File Names Next to Supplied Names in Excel for Data Merge with InDesign

  • October 17, 2024
  • 2 replies
  • 839 views

Hi

can anyone help me please ,, i have 1 question about data merge from excel to indesign.

i have huge pictures from ""photographer"" with file names  like this, 

  • B49I1384.JPG
  • B49I1396.JPG
  • B49I1397.JPG
  • B49I1188.JPG
  • B49I1178.JPG  

 

but client supplied excel sheet which is already mentioned real names in it, 

  • Brian
  • Christopher
  • Ricky
  • George
  • Henry
  • Keith
  • Joseph

my question is how to place these huge files names excat in excel next column of real names.

 

Your kindness is deeply appreciated, thank you.

 

 

<Title renamed by MOD>

This topic has been closed for replies.

2 replies

Sparrowhawk-AES
Sparrowhawk-AES
Known Participant
October 30, 2024

I would love to help but I am unclear about one detail, the content of said spreadsheet. Is the image name included in row with the "English name"?  I am unclear of the obstacle. If the speadsheet has at some unique identifier that relates name to image then the rest is an easy excel formula.  I process hundreds of photos linking, renaming and finding missing photos. I think I can help.  

    L
    Community Expert
    LaubenderCommunity Expert
    Community Expert
    October 17, 2024

    Hi @Muhammad Wase38076271idl6 ,

    I see no way to do this. Do the image files hold any meta information about the depicted persons?

    Then you could place all the images in InDesign as first step and create an automatic caption with the meta information showing the name. Use the option to group image and caption. The second step would be a custom script that could use the grouped images with their captions and does a list of names and image names. Or a script that would read out the meta data directly from all image files of a certain folder…

     

    Note: I do not think that data merge will work with whole paths in InDesign 2024. Did not test with 2025 yet.

    To circumvent this problem, place the data merge source file in the folder where all images are stored and use the file names only, not the full paths.

     

    Regards,
    Uwe Laubender
    ( Adobe Community Expert )

    Sparrowhawk-AES
    Sparrowhawk-AES
    Known Participant
    October 31, 2024

    I use full paths in excel to merge spreadsheet data in InDesign and generate captions photo slicks for clients to verify image assignments. Whole paths continue to work with data merge.

    Sparrowhawk-AES
    Sparrowhawk-AES
    Known Participant
    October 31, 2024

    Here is a sampling of how I prepare data in Excel to validate and prepare to rename.

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