Skip navigation
Currently Being Moderated

How to repeat data with Data Merge?

Jun 17, 2013 1:31 PM

Tags: #cs5 #mac_os_x #merge

How can I repeat data in the same text block with Data Merge? I have an Excel file with a class schedule that I need to import but when I use Data Merge, it wants to create a new page for each line. I want to keep the data in one text block per page and use Data Merge so when I get the new Excel file, it will be easy to update. This seems like it would be a simple thing to do, but I can't find the answer. Can anyone help?

  • Currently Being Moderated
    Jun 17, 2013 2:43 PM   in reply to cpctrip

    Data Merge does a single frame for each record. It sounds like you've got it set also to do a single record per page, but you can do multiple records, but each record will remain in its own frame.


    I think you may have better luck placing the Excel table directly. You can link it so it updates when the file changes, but unless you use table and cell styles you will lose any formatting you apply ing ID when you do an update.

    Mark as:
  • Currently Being Moderated
    Jun 17, 2013 3:39 PM   in reply to cpctrip

    Time for me to sound like a broken record. Data merge could be used for this but I don't think it was ever intended for such recurring publications like you are making. There will always be a lot of repetitive work that always will need to be performed after each update.


    Instead, I think you should read up on using an XML workflow. Now, the XML out of excel needs transformed to be viable inside ID. But that is reasonably easy and can be done in an XML editor or upon importing into ID. Though it has been set aside for a time, I am making an example of a college course catalog for a customer. I'll see if I can finish it off by the weekend. If so, I'll post it to this thread.


    Take care, Mike

    Mark as:

More Like This

  • Retrieving data ...

Bookmarked By (0)

Answers + Points = Status

  • 10 points awarded for Correct Answers
  • 5 points awarded for Helpful Answers
  • 10,000+ points
  • 1,001-10,000 points
  • 501-1,000 points
  • 5-500 points