![Advanced ip lookup](https://cdn1.cdnme.se/5447227/9-3/2_64e61dfa9606ee7f98e9879b.png)
To import image directories in excel, go to the data tab at the top of the page and press the “Get Data” button. Additionally, do not have your datasource file saved to this directory yet, as it will also be imported which could misorder the images as well.
![indesign data merge google sheets indesign data merge google sheets](https://infoinspired.com/wp-content/uploads/2019/02/merging-tables-type-2.jpg)
Even if you have an alphabetized list of names, if just one photo associated with a name is missing, then all the names listed after will be paired with the wrong image. If you do intend on importing image data into excel, I would recommend doing it before adding any other information as images are always imported in alphabetical order. It is possible within Excel to import the file names and directories from a folder, which may be convenient if you’re working with lots of images. Obviously though, this will vary depending on where the files are saved.
![indesign data merge google sheets indesign data merge google sheets](https://i.pinimg.com/originals/b8/2a/5f/b82a5fc782dbb1fe9f962b9d0f9f9e6f.png)
If your image files are stored in such a way that this isn’t possible, then you can put the full directory which would likely look something like That way, simply putting the file name and extension will find the correct file (john-smith.jpg). For the sake of simplicity, I’d recommend placing your datasource within the folder containing all your images. InDesign searches file paths relative to the location of the datasource file, which in this case is our excel document.
![Advanced ip lookup](https://cdn1.cdnme.se/5447227/9-3/2_64e61dfa9606ee7f98e9879b.png)