Asset Intelligence and Management

Asset Intelligence and Management

EZO CMMS Blogs Design Avery Labels

[How-to] Design Avery labels for Your EZO CMMS Label Data

Avery hosts an extensive collection of common printout templates for companies to build the perfect labels for their items. These are completely customizable and easy to make. Design Avery labels in minutes and populates them with your EZO CMMS item data.

1. Exporting Print Label Data

To get started, you need your print label data from EZO CMMS. Get it from More > Printout Templates > Labels > Export print label data for commercial printing.

This action emails you a CSV file of your print label data. You’ll need this once you begin designing your Avery labels.

2. Start designing with Avery

Head to the Avery label designer and click on ‘Start Designing’. You might have to create an account if you don’t already have one – this only takes a minute.

3. Customize your design

It’s time to design Avery labels for your tags. Let’s get started.

1. Choose a template that matches your layout, size and color requirements.

2. Pick an appropriate design for your labels.

3. Next, you need your label data source. Click on ‘Import Data Mail Merger’ in the left panel, and then on ‘Start import/merge.’

3.1. Upload a spreadsheet and then select the rows and columns to import. Be sure to deselect Row #1 if it includes your column titles.

3.2. Now, you need to add relevant data points to your labels. Drag your desired fields to the placeholder area on the right. This enables you to arrange data points however you like. Click ‘Next’ once you are done.

3.3. Your labels should include a barcode or a QR code so it can be scanned by a reader. From the left-side panel, click on More > QR and Barcodes > Add a Barcode or QR code > Spreadsheet or Sequential Number. 

3.4. Next, select Spreadsheet in Step 1 and drag the identification number field to Step 2. Click on ‘Finish’ once you are done.

3.5. You’ll be able to see your barcode on the label. Drag and resize it according to your preferences. You can also use the settings on the left-side panel to adjust your barcode. Choose the appropriate Industry format and drag the relevant identification number field to the left-side.

4. Once you’re done with that, click ‘Next’. You’ll be able to preview your label.

5. You can also explore the designer and add others elements to your labels. Add a unique shape to indicate newly procured items and text to add more details to your labels.

6. Once you’re done customizing, click ‘Next’ to preview your design.

7. If you like the preview, click ‘I Approve My Design’ to save it and have Avery print the labels for you. If you’d like to print the labels yourself, click ‘print this myself’.

About EZO CMMS

EZO CMMS is the next generation maintenance management software. It does more than just simple maintenance, it empowers your teams with a central command center to assign and complete work orders to achieve optimal productivity. We offer a free 15-day trial – no credit card required!