For help importing data for barcodes, check out our helpful barcode FAQs, or view our 10 minute video on creating asset tags with barcodes. The mail merge/import data feature in our label design software allows you to populate labels with information from any spreadsheet.

Click “Finish” to see your populated barcodes.

Drag the data box to the “Alphanumeric and Special Characters” field.

Preview the data and select the information you want encoded in the barcode, then click “Next”.Follow the directions to select your file.Make sure “Spreadsheet” is selected, then click “Import Data”.Choose “Spreadsheet or Sequential Number,” then click “Next”.

Open the template you wish to design or modify.

But here's the basic steps to add barcodes to labels using a spreadsheet: Our video tutorial for adding barcodes to asset tags gives you step-by-step instructions for using the barcode generator tool in under 10 minutes (plus a few extra pro tips). You can manually enter barcode information or import it from a spreadsheet. The barcode generator tool can be used to add barcodes to any Avery template.

Starting with a blank Avery template in Avery Design and Print, you can choose a professional design to customize/modify, create your own design from scratch using our tools or upload a design from your computer.Īvery Design and Print allows you to create and customize with graphics/images from our gallery, fonts, shapes, a barcode generator, autofill for GHS label templates and more.Īvery Design and Print makes it easy to get started with barcodes in your facility. For example, this blank GHS label template for our 3-1/2' x 5' UltraDuty® labels which are extremely useful for labeling secondary disinfectant containers. For example, Avery templates with compliant OSHA and ANSI headers that leave space for you to add your own safety message.īlank Avery templates are the templates that correspond to specific Avery Industrial products and sizes. Avery templates that are ready-to-print make it incredibly fast and easy to print safety signage for your facility- whether you print onsite, or have us professionally print them for you.Īll Avery templates are technically customizable, but customizable templates generally refers to any of our professionally designed sign, tag and label templates that leave placeholder text or space for you to add in your own information. Stock/ready-to-print templates can usually be printed or ordered as-is because they cover common topics, but you can still modify/customize them if needed. For example, coronavirus germ-prevention signs, construction area warning signs and commonly used notice signs. Ready-to-print templates, such as our stock safety signs, are professional designs that feature general facility applications.

Online label design software