Getting Started with SheetsToLabels — Print Labels in 5 Minutes

This guide will walk you through the process of creating and printing your first set of labels.

Step 1: Prepare Your Data

Before you start, ensure your data is organized in a spreadsheet.

• The first row should contain Connect Headers (e.g., Name, Address, City).
• Each subsequent row should represent one label.

Supported formats:

• Excel (.xlsx, .xls)
• CSV (.csv)
• Google Sheets (via direct connection)

Step 2: Upload Data

1. Go to the Label Designer.
2. Click on the Data Source tab on the left sidebar.
3. Select Upload File or Connect Google Sheets.
4. Once uploaded, you will see your columns listed as available "Merge Fields".

Step 3: Choose a Template

You can start from scratch or choose a preset.

• Standard Address: 30 labels per sheet (Avery 5160 compatible).
• Shipping 4x6: Standard thermal printer size.
• A4 General: 21 labels per sheet.

To change dimensions, go to Page Settings (gear icon) and enter your custom width, height, and margins.

Step 4: Design Your Label

1. Text: Drag a Text element onto the canvas. Click to edit.
2. Merge Fields: To display dynamic data (like a Name), type column names in brackets {{Name}} or drag the field from the sidebar.
3. Images: Upload your logo or other static images.
4. Barcodes/QR: Add a QR code element and bind it to a data column (e.g., URL or SKU).

Step 5: Preview and Print

1. Click the Preview button to see how your labels look with real data. You can flip through different rows to ensure long names fit.
2. Click Download PDF.
3. Open the PDF and print!

[!IMPORTANT] When printing, make sure your printer scaling is set to "Actual Size" or "100%" to ensure alignment with pre-cut label paper. Do not select "Fit to Page". See Print Settings.