May 9 2007 • 9:45 PM

Get a List of Images In Your Document

AMB wrote:

Is there a way to capture the names of all the linked files in the ‘links’ pallet/panel, and paste them into – say MS Word or Excel to sort them?

As with so many of these “secrets,” there’s good news and bad news. The good news is that it’s sort of possible. The bad news is that it’s not pleasant. One reasonable method to get a list of your links is to choose File > Preflight. Then click the Report button at the bottom of the Preflight dialog box.

linkreport1

When you open the report up in a text editor (such as NotePad or TextEdit), you can scroll down to see a list of all linked images:

linkreport2

Now, the hard part is getting all that data to format properly into a spreadsheet. I bet there’s a good way to do it in Excel, but pretty much everything about Excel gives me the willies. Any readers out there prepared to find a quick and easy way to convert this kind of text file to a spreadsheet (with the file name in one column, the link in another column, and so on)?

27 Responses discussing this post. Add yours below.

  1. May 9th, 2007 • 10:25 pm • Link

    The way I’ve done this in the past was to go to the folder containing all the links (using the Links palette’s Copy Links To if they weren’t already gathered into their own folder) in the Finder. Then in the Finder, choose Select All, copy, then jump to Word and choose Paste. All the filenames appear one after another.

    Not sure how you’d do that on Windows though.

    Of course if you need to capture the original paths, or you weren’t allowed for some reason to copy them to a new location first, then this method wouldn’t work.

  2. David Blatner
    May 9th, 2007 • 10:36 pm • Link

    Good point, Anne-Marie, though this would only work if the files actually existed (weren’t missing). This is strangely difficult to figure out on Windows. One way to get a listing of a directory on Windows is called Directory Printer (but you can “print” it to a txt file).

  3. Brendan
    May 10th, 2007 • 12:01 am • Link

    Hi guys, I’ve only seen this new feature demonstrated once, but couldn’t you use the new GREP search feature in InDesign CS3 to strip out all that miscellaneous information and end up with just the image file names ready to paste into Word/Excel?

  4. Steve Werner
    May 10th, 2007 • 12:52 am • Link

    This seems like a problem that cries out for a script! I just did a quick check of the Adobe Exchange, and don’t see anything there on first look. But it seems like that should be scriptable (except that I’m not a script writer!)

  5. Birgit
    May 10th, 2007 • 11:02 am • Link

    You can do this easily within InDesign. First you create the report with the preflight ( as stated above) Then you load this textfile back into InDesign (into a new text frame) and strip all the rest…

  6. Birgit
    May 10th, 2007 • 11:04 am • Link

    … (infomation about colors, fonts etc.) leaving only the information about pictures. Then do a search & replace. 1. search for ^p^p^p (this is between the blocks of information between 2 pictures)…

  7. Birgit
    May 10th, 2007 • 11:05 am • Link

    …and replace with something unusual (i always use *****) 2. search for ^p and replace with ^t. 3. Search for ***** and replace with ^p. …

  8. Birgit
    May 10th, 2007 • 11:05 am • Link

    … Then select all the text and convert to table. (tab between columns, paragraph between lines). Voilà!

  9. Birgit
    May 10th, 2007 • 11:10 am • Link

    You can now delete columns with unusable information, export the table, break up path names (e.g. change : to ^t) and so on.

  10. Birgit
    May 10th, 2007 • 11:12 am • Link

    This took me about 5 minutes for a document with 73 pictures.

  11. May 10th, 2007 • 11:35 am • Link

    Birgit, the limit in the reply field is 200 words, not characters ! ;-)

  12. May 10th, 2007 • 4:11 pm • Link

    I just posted a script to Adobe Exchange that will list the links used in a document. It’s called ListLinks. Let me know if you think it can be improved, currently it has options to list filenames, paths, and file types.

  13. Birgit
    May 10th, 2007 • 4:35 pm • Link

    @Branislav: Oh, shame :-( Did not read correctly. But next time…

  14. Sheila McGrath
    May 11th, 2007 • 2:00 am • Link

    To put an image list into Excel:Use Birgit’s method to replace paragraph returns with tabs, but save document as text only. Open an Excel spreadsheet, in the Data menu choose import Text file (be sure “delimited text” is checked) and choose your text file. Excel will place your data in columns for you. (If you need to remove redundant text (i.e. “File Name:” use Excel’s find and replace to remove all instances of it.) In Excel you can add a column with the name of the document you placed the images into – and keep a running record of images in documents by adding your image lists to the spreadsheet.

  15. David Blatner
    May 11th, 2007 • 3:11 pm • Link

    Steve, your script doesn’t appear to be on the Adobe Exchange yet. Perhaps it’s moderated and will be up there soon.

    In the meantime, Sacha Heck told me of a script written by Martin Fischer that would do this on their Swiss InDesign forum.

    We’ve uploaded that script to our site for your easy download. It appears to work pretty well and very quickly, simply making a text file in the same folder as the InDesign document. Please note that we put the script in a .zip wrapper so that it’s easily downloadable with a click. If you want the unzipped jsx file, click here.

  16. David Blatner
    May 11th, 2007 • 3:12 pm • Link

    By the way, for more on how to install scripts, see this post.

  17. May 11th, 2007 • 6:19 pm • Link

    David, you’re correct, Adobe checks out the file before they post it. So it could be a while. I’m sure the one by Martin Fischer does the job though.

  18. Jeremy from Seattle
    May 17th, 2007 • 9:27 pm • Link

    I just installed the script but got an error. It says Object does not support the property or method ‘geometricBounds’

  19. David Blatner
    May 17th, 2007 • 9:30 pm • Link

    Hm. Interesting. Are you using CS2 or CS3? (I have no idea if anything works on CS or earlier!)

  20. Jeremy from Seattle
    May 17th, 2007 • 9:43 pm • Link

    CS2.

  21. Jeremy from Seattle
    May 17th, 2007 • 9:43 pm • Link

    On a PC.

  22. David Blatner
    May 18th, 2007 • 11:54 pm • Link

    Hm. Strange. I just tried it in InDesign CS2 in Windows and it worked just fine. You sure you have at least one or two linked images in your document? I’m not sure what else the problem could be.

  23. Robin
    July 21st, 2007 • 6:00 pm • Link

    Hi all, I just wanted to say I use PC all the time at home, but usually use MACs at work. On PC, (I think this only works for linked files) package your document in InDesign and save to a folder (as usual), then open the folder in thumnail view through (PC) windows explorer (MAC-finder?) and select all. Com/Cntl + C, open Word and Com/Cntl – V. It worked for me, but I didn’t try it on embedded pics. Hope this helps.

  24. Elizabeth
    April 20th, 2008 • 4:41 pm • Link

    Thank you! LinkExport works like a dream.

  25. March 4th, 2009 • 12:40 am • Link

    My application
    ImageLister generates image reports in several formats, including tabbed clipboard text.

  26. CJ
    March 31st, 2009 • 4:33 am • Link

    My application
    ImageLister generates image reports in several formats, including tabbed clipboard text.

    … and is on a 30-day trial period. After that it costs 350 euro/ 480 USD.

    I think the script David Blatner posted worked like a charm. Thx!

  27. erique
    December 21st, 2009 • 12:21 am • Link

    Steve Wareham’s script may or may not have ever made it onto the Adobe Exchange, but as I write this it is available from his blog here http://www.stevewareham.com/listlinks.php and works like a charm!

    It creates a new text box in the very document that is being ’scripted’ for links, with information about names, paths and file types of the images in the file or any combination of these three.

    The only thing I should mention is that when I downloaded his script, it came across as a .TXT file and I had to compile it as a .JSX in ExtendScript Toolkit. However, that may not be a problem at Steve’s side of things, but rather one at my end.

Subscribe to the Discussion

Get the ongoing discussion surrounding "Get a List of Images In Your Document" delivered to you. Click here to subscribe via RSS.

Leave a Reply

You can use limited HTML tags, such as <em></em> for emphasis/italics and <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <strike> <strong> .

InDesignSecrets reserves the right to edit and/or remove posts and comments.