Create Custom Employee Badges With Avery Design & Print

 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:

    Open

    

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)

    Open

    

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