Steps
- Put one label per row in a spreadsheet, with a header row that names each column.
- Export the sheet as CSV.
- Make a label template with a field for each value that changes from label to label.
- Map each field to a column, starting with the fields every label needs.
- Review the rows with problems before printing; a row that is missing a required value should not print.
- Print the first row as a test, then print the batch.
Prepare the spreadsheet
- Keep one header row and no merged cells.
- Type each value exactly as the label should show it.
- Remove empty rows at the end of the sheet.