Skip to main content
M
MEONHOMES
Inspiring
February 21, 2025
Question

Sequential Numbering on Same Page (Avery Labels) - InDesign Data Merge

  • February 21, 2025
  • 2 replies
  • 1324 views

Help!!  I am trying to perform a Data Merge in InDesign (which I have done many times). However, the issue I am having is getting multple records (sequential numbers) on a SINGLE page. Please see attached PDF showing what I am trying to acheive.

 

I have 200 part numbers in a .CSV data file. In the originating Excel file, the numbers are listed in Column A, with the heading "NUM". My InDesign document is set up as a single page, 8.5x11. When creating the merged document, it repeats the first part number on page 1, the second number on page 2, and so forth.... I have tried playing with the Multiple Record Layout settings but it is not working.

 

How do I get it to put unique numbers on each page rather than repeating the same number?

 

Details in summary:

  • Avery label page size - 8.5x11
  • 5 labels per page (each label has one part number on it - see attached)
  • 200 part numbers / 5 labels per sheet = 40 sheets

2 replies

Peter Spier
Peter Spier
Community Expert
February 21, 2025

Show us your template...

For Data merge with multiple records per page you should have only one text frame the size of your label on the template.

And if you've used preview, re-make the template and try again without the preview step.

    M
    MEONHOMESAuthor
    Inspiring
    February 21, 2025

    Here is the iD test file I've been using - it has one text box, the avery template is "created" using guides. (For testing I have just been using the CSV file (previously attached) for simplicity...

    Peter Spier
    Peter Spier
    Community Expert
    February 21, 2025

    Sample file works fine here.

    Re-make the template and merge without preview.

      Robert at ID-Tasker
      Robert at ID-Tasker
      Brainiac
      February 21, 2025

      Can you show your CSV file?

       

      M
      MEONHOMESAuthor
      Inspiring
      February 21, 2025

      Added here.... thank you!

      Robert at ID-Tasker
      Robert at ID-Tasker
      Brainiac
      February 21, 2025

      Those are just numbers?

       

      If that's the only data you want to import, you have two options:

      - Import as a text and reflow between linked / threaded TextFrames,

      or

      - use Bullets and Numbering - and just empty paragraphs - in linked / threaded TextFrames.

       

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