Create Custom Employee Badges With Avery Design & Print
This document contains a how-to step by step guide on how to create customized employee badges using the free online label generate provided by Avery.
For more information on using this module see the main instructions page linked HERE
For more information on adding Punch Clock to your Croptracker account contact support@croptracker.com
Step-By-Step Guide
Before starting log into your Croptracker account and go to Punch Clock > Employees
Click “Upload Employee Data” and then make sure the box “Include Current Employee Data” is checked
Click “Download Editable Employee CSV” and save the file to your computer
Open the file and delete all columns except Employee Number, First Name, Last Name (and other columns you want to show on the badges)
Navigate to https://www.avery.ca/en/design-and-print-online
Optional: Sign up for a new account in order to save progress
Select the option “Addressing & Shipping Labels”
Select the labels per page, for example, 6/sheet
Select the button at the top labeled “Upload a Complete Design”
Upload a blank design as png format (800x600 px), for example:
Click “Apply This Design”
On the far left side click “QR and Barcodes”
Click “Add QR Code or Barcode”
Select “Spreadsheet or Sequential Number” then click “Next”
Make sure “Spreadsheet” is selected and then click “Import Data”
Select the employee CSV file downloaded from Croptracker
Uncheck the first row of data (the column titles), and uncheck all columns except Employee Number
Make sure the rows are sorted by Employee Number descending (down), then click “Next”
Set the “Industry Standard Format” to QRCode
Drag the field Employee Number to the “Enter barcode text” field then click Finish
Drag and resize the barcode to an appropriate size (the larger the better)
Make sure to save regularly
Click “Import Data Mail Merge”
Click “Choose Fields”
Select the fields you want to put on the design by checking the column, for example, Employee Number, First Name, Last Name, etc.
Make sure the first row (the column titles) is unchecked then click “Next”
Drag the fields to create an appropriate arrangement then click “Next” then “Finish”
Drag and resize the data on the design
Once you finish your design click Preview & Print
Review the design then click “Print it Yourself”
Click Get PDF to Print
Click Open PDF to get the PDF
Print the PDF or save to your computer
Related articles
Need a little more support? Not sure you’re using your Croptracker account to the fullest? Get in touch with an expert at support@croptracker.com. You can also book 1-on-1 training with a Croptracker expert at Croptracker - 1-on-1 Training.