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

  1. Before starting log into your Croptracker account and go to Punch Clock > Employees

  2. Click “Upload Employee Data” and then make sure the box “Include Current Employee Data” is checked

  3. Click “Download Editable Employee CSV” and save the file to your computer

  4. Open the file and delete all columns except Employee Number, First Name, Last Name (and other columns you want to show on the badges)

  5. Navigate to https://www.avery.ca/en/design-and-print-online

  6. Optional: Sign up for a new account in order to save progress

  7. Select the option “Addressing & Shipping Labels”

  8. Select the labels per page, for example, 6/sheet

  9. Select the button at the top labeled “Upload a Complete Design”

  10. Upload a blank design as png format (800x600 px), for example:

  11. Click “Apply This Design”

  12. On the far left side click “QR and Barcodes”

  13. Click “Add QR Code or Barcode”

  14. Select “Spreadsheet or Sequential Number” then click “Next”

  15. Make sure “Spreadsheet” is selected and then click “Import Data”

  16. Select the employee CSV file downloaded from Croptracker

  17. Uncheck the first row of data (the column titles), and uncheck all columns except Employee Number

  18. Make sure the rows are sorted by Employee Number descending (down), then click “Next”

  19. Set the “Industry Standard Format” to QRCode

  20. Drag the field Employee Number to the “Enter barcode text” field then click Finish

  21. Drag and resize the barcode to an appropriate size (the larger the better)

  22. Make sure to save regularly

  23. Click “Import Data Mail Merge”

  24. Click “Choose Fields”

  25. Select the fields you want to put on the design by checking the column, for example, Employee Number, First Name, Last Name, etc.

  26. Make sure the first row (the column titles) is unchecked then click “Next”

  27. Drag the fields to create an appropriate arrangement then click “Next” then “Finish”

  28. Drag and resize the data on the design

     

  29. Once you finish your design click Preview & Print

  30. Review the design then click “Print it Yourself”

  31. Click Get PDF to Print

  32. Click Open PDF to get the PDF

  33. 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 https://www.croptracker.com/1-on-1-training.html.