Tutorials

Design Your First Label — Step-by-Step Tutorial with Barcode, Logo & Live Data

Complete beginner tutorial for SheetsToLabels. Create a professional product label with a company logo, barcode linked to your SKU column, and dynamic text that changes per row — from scratch.

This comprehensive tutorial will guide you through creating your first professional label from scratch. By the end, you'll have a complete understanding of the label design workflow.

What You'll Create

In this tutorial, you'll create a simple product label with:

  • Product name and description
  • Price
  • Barcode (linked to SKU)
  • Company logo

Step 1: Prepare Your Data

First, create a simple spreadsheet with the following columns:

Product NameDescriptionPriceSKU
Coffee MugCeramic 12oz$9.99CM001
Water BottleStainless Steel 20oz$14.99WB002

Save this as an Excel file (.xlsx) or CSV file.

Step 2: Open the Label Designer

  1. Go to Label Designer
  2. Choose a template from the gallery, or start with a blank/custom label
  3. Click Customize to load the layout into the editor

Step 3: Import Your Data

  1. Click Edit Data in the workflow toolbar
  2. Import your spreadsheet from Excel, CSV, XML, or Google Sheets
  3. Your columns will appear as available fields in the Data Manager and sidebar

Step 4: Set Up Your Page

  1. Open the Print Settings sidebar tab
  2. Choose a preset or label size:
    • For standard labels: Select "Avery 5160" (30 labels per sheet)
    • For custom size: Enter your dimensions
  3. Switch to Print Layout to confirm the full sheet

Step 5: Add Elements

Add Product Name

  1. Switch to Design Tag mode
  2. In the Design tab, click Text
  3. Select the text element and connect it to the Product Name column, or type {{Product Name}}
  4. Format it: Make it bold and increase the font size to 18pt

Add Description

  1. Add another text box below the product name
  2. Connect it to the Description column, or type {{Description}}
  3. Keep it at a smaller size (12pt)

Add Price

  1. Add a text box in the top-right corner
  2. Connect it to the Price column, or type ${{Price}}
  3. Make it bold and use a bright color (e.g., red)

Add Barcode

  1. In the Design tab, click Barcode
  2. Place it at the bottom of the label
  3. Select Code 128 as the barcode type
  4. Connect it to the SKU column

Add Logo (Optional)

  1. Click Image in the Design tab
  2. Upload your company logo
  3. Resize and position it in the corner

Step 6: Preview Your Labels

  1. Click Print Layout in the toolbar
  2. You'll see the full sheet with real data
  3. Use the page controls for multi-page jobs
  4. Check that everything fits properly before export

Step 7: Export and Print

  1. Click Export PDF
  2. Open the PDF file
  3. Print using these settings:
    • Scale: 100% (Actual Size)
    • Fit to Page: OFF
    • Paper Size: Letter (or A4, depending on your template)

Tips for Success

  • Test Print: Always print one sheet on regular paper first to check alignment
  • Data Quality: Clean your data before importing - remove empty rows
  • Font Sizes: Use at least 10pt for readability
  • Margins: Leave some margin around text elements to avoid cutting off

Next Steps

Now that you've created your first label, explore:

Congratulations on creating your first label!