Skip to main content
English (US) Español (España) Français Português do Brasil Português (Portugal)

How to Customize QR Codes with External Software (Avery Design & Print)

Updated

To create custom labels with QR codes for assets registered in Fracttal One, you can use Avery Design & Print, a free online design tool. With this platform, you can import the data exported from Fracttal One and generate labels with QR codes in a practical way. Below, we detail the complete process to export the data and customize your labels.

Customizing QR Codes in Avery Design & Print

Step 1: Export Data from Fracttal One

1. Access the "Catalogs" module in Fracttal One and select the "Assets" option. In this section, you will find the list of all the assets registered on the platform. Select the assets whose QR codes you want to print.

2. Click on the "Export" option. The system will generate an Excel file with the data of the selected assets. app.fracttal.com_inventories_equipments(Surface Pro 7) (4) PTBR.png

3. Open the exported Excel file and create a new sheet.

4. Copy the data you want to include in the label, such as the QR Code URL, Code, Name, and Brand.Captura de tela 2025-03-06 144608.png

5. Ensure that the sheet with the data is the only one in the file.

6. Open the Excel file and organize the columns as needed. Be sure to include the column with the QR Code URL (automatically generated by Fracttal One), in addition to any other data you wish to include in the labels. Then, save and close the file.

Step 2: Access Avery Design & Print Website

www.avery.com_ (2.PNG

  • Log in or create an account if you do not have one.
  • From the homepage, scroll down to find the "Start Designing" option, which will give you access to the design platform.

www.avery.com_1.PNG

Step 3: Create a New Label Design

  • Choose the type of label you want to create. You can opt for standard adhesive labels or custom-sized labels.
  • To find the correct label model, click on "Custom Printing" in the sidebar or enter the reference number of the label you are using.

APE358~1.PNG

  • Click on the desired option to continue and choose the design for the labels. You can either use pre-designed templates or start a design from scratch.

APFA6D~1.PNG

Step 4: Import Data into Avery Design & Print

  • In the design panel, go to the left sidebar and click on "QR Codes and Bar Codes"
  • Click on "Add QR/Bar Code."

AP5E69~1.PNG

  • Choose Spreadsheet: select the data import source as "Spreadsheet."

AP9B75~1.PNG

  • A tab will appear to let you select the Excel file exported from Fracttal One.

APAD2F~1.PNG

  • Choose Fields: select the fields you wish to import, checking or unchecking the options as needed, and then click "Next" to continue.

AP13FD~1.PNG

  • Create Barcodes: fill in the fields related to the data you want to customize on the labels, organizing them according to your needs.

AP2986~1.PNG

  • On the left side, you will see the order of the columns from the exported file, containing asset information.
  • In Industry Standard Format, select QR CODE.
  • In Code Type, select URL.
  • Drag the QR Code URL option from the left menu and drop it into the Website field.
  • Click on Update Preview to update the changes, and then click Finish.

APBD97~1.PNG

Once redirected to the design page, you will see the QR code inserted into the template. It is recommended to test the functionality of the code to ensure that it is correct and links to the asset information in Fracttal One.

Step 5: Insert Elements

  • With the data imported, drag and drop the desired fields onto the labels.
  • Drag the QR code image to position it strategically within the indicated field.
  • In the "Import Data" menu, add other relevant information such as the asset name, code, etc., by dragging the data columns into the label areas.

APBF33~1.PNG

  • Adjust the size of the QR code and the information to ensure they are legible.

app.print.avery.com_dpo8_app_target;name=US_en;ep=USP_product;profile=WePrint;category=dc29dcac625f93d244f8dcdd59a0a679;product=d0f67347ec701d8a79a4659ed8a2f8ba;templateCategory=Rectangle%20Label (9)02.PNG

Step 6: Customize the Label

In Avery, you can customize the label design. This includes:

  • Resizing the QR code and other elements.

  • Adding the company logo or other relevant images.

  • Adjusting colors, fonts, and the layout as needed.

APPPRI~2.PNG

Step 7: Approval and Download of the Label File

  • After completing the design, click on "Next" in the lower-right corner.

APA375~1.PNG

  • Once the label design is finished, check the preview of the final result. If everything is correct, finalize the process on the verification page. If needed, you can go back to make adjustments or approve the design to proceed with the download.

AP1418~1.PNG

  • To download the file as a PDF, click on "I Approve My Design."
  • Then, on the next screen, click "GET PDF TO PRINT." The file will automatically be saved to your computer.

Captura de tela 2025-03-25 120220.PNG

Once the process is completed, simply print the customized labels with the desired data and apply them as needed.

Notes:

  • The platform supports files in xls, xlsx, and csv formats.

  • Files should have less than 3,000 rows, 20 columns, and 600 KB. If the file is larger, split it into multiple projects.

  • Make sure the print settings are correct for the type of label chosen.

Related articles