This is an ideal job for Data Merge.
You set up one name tag with the correct positioning, and enough room in your text fields for the longest name.
Export your excel to csv or tab-delimited text, and use the data merge panel to link the fields to your tag.
You then set up and run a multiple record per page merge.
This is exactly what Data Merge does.
- Make sure your Excel columns have headings, e.g., firstName, lastName, etc.
- Save it in a delimited file format (.csv will work well if the entries don't contain commas) CLOSE IT
- In InDesign, setup a single name tag occupying 1/10th of the page at the top-left corner; and be certain another 9 (which InDesign will generate) will fit in the remaining space (some basic math is in order)
- Open the Data Merge panel: Window > Utilities > Data Merge
- Choose Select Data Source from the Data Merge panel menu; navigate to your saved .csv file and select it
- The Data Merge panel will become populated with the available column headings read in the data source file
- Set a text frame where you want the name to appear on the name tag, and with a live insertion point, (blinking cursor), double-click the desired column heading in the Data Merge panel to set the field in the frame.
- So you should have something like this:
You can style the fields however you'd like the names to appear.
- Choose Create Merged Document from the Data Merge panel menu
- In the Create Merged Document dialog, choose Multiple Records from the Records Per Document Page menu
- Switch to the Multiple Record Layout tab, tick Preview Multiple Record Layout and make adjustments if needed.