Quantity Columns & Multiple Labels
Generate multiple labels per spreadsheet row using quantity columns, print copies, and per-item multipliers
Some label jobs need more than one label for a single row. For example, one product row may need 12 shelf labels, one asset row may need 2 duplicate stickers, or one order row may need several package labels.
Label Designer supports two related patterns:
- Generate Labels by Quantity Column in the Data Manager
- Print Copies in Print Layout
Use the quantity column when the number of labels changes per row. Use print copies when every current label should be repeated the same number of times.
Quantity Column
Use Generate Labels by Quantity Column when your spreadsheet has a column such as quantity, qty, count, or copies.
Example:
| product_name | sku | quantity |
|---|---|---|
| Olive Ceramic Mug | SKU-1001 | 4 |
| Linen Market Tote | SKU-1002 | 3 |
| Handmade Soap Trio | SKU-1003 | 6 |
After expansion, the first row prints 4 labels, the second row prints 3 labels, and the third row prints 6 labels.
How to Generate Labels by Quantity
- Open Edit Data.
- Import or paste your spreadsheet rows.
- Open the data menu.
- Choose Generate Labels by Quantity Column.
- Select the column that contains the quantity.
- Click Apply.
Rows with 0 or invalid quantity values are skipped by default. If you want rows with empty or invalid quantities to still print once, enable the option to generate 1 label for invalid quantities.
Print Copies
Use Print Copies in the Print Layout settings when every current label should repeat the same number of times.
For example:
- If your data has 20 rows and Print Copies is
2, the export contains 40 labels. - If you are printing a single design with no imported data and Print Copies is
30, the same design fills 30 label slots.
Print Copies is a global multiplier. Quantity-column expansion happens in Edit Data before the print layout multiplier.
Which Option Should I Use?
| Need | Use |
|---|---|
| Every row prints once | No quantity setting needed |
| Each row prints a different number of labels | Generate Labels by Quantity Column |
| Every current label prints the same number of times | Print Copies |
| Fill one page with a single design | Print Copies or the Fill 1 page shortcut |
Best Practices
- Keep quantity values as whole numbers.
- Remove blank rows before expanding quantities.
- Preview the full sheet after expansion.
- Use a small test export before generating thousands of labels.
- Remember the export limit shown in Print Layout.