Reply To: Auto import hundreds of images

#60862
Amy Gilbert
Participant

If you are on a Mac, you can copy/paste the files from Finder right into Excel. That'll give you filenames. If your ID file, Excel file and images are in the same directory, I don't think you'll need the full path – but there's a way to do that too with some Excel and Word tricks.

If you are on a PC, at a DOS prompt type

dir > filename.txt

from the directory where all the files reside. This will give you the file names with a lot of other garbage you don't need, but it is a fixed width text file so when you bring it in to excel, choose “fixed width” in the Text Import dialog and when you click “Next” you'll be able to set up your columns so that one column is just the file name. Then you can delete the rest.

This article was last modified on October 20, 2011

Comments (0)

Loading comments...