HandyWorkLab

Create address labels from a CSV file

A small, fictional example

{'The downloadable file has three columns': 'Name, Address, and ID. Its first row has Name “Fictional Ada”, Address “Fictional Ada; 1 Test Rd; ZZ000”, and ID “DEMO-001”. These are invented examples, not real people or deliverable addresses. Keep one record per row and use a comma-separated header row.'}

Import and map the fields

  1. Open Labelbench and use Choose CSV to import the downloaded file from your device.
  2. Under Choose what each label shows, set Label text (Column for label text) to Address. The sample Address cells already include the recipient name. The control takes one column; combine name and address in your spreadsheet before importing if you need both. For name-only labels, choose Name instead.
  3. Set QR value (Column for QR value) to ID and Code 128 value (Column for Code 128 value) to ID. Set both explicitly, even if the import suggests columns. The first label will show the Address text and encode DEMO-001 in both symbols. Choose Do not use for a code you do not need.
  4. In Sheet template, choose the stock that matches your physical sheet. For example, choose A4 · 3 × 8 · 70 × 37 mm only for stock with that layout. Check paper size, label dimensions and gaps against the package.
  5. Review the preview, row issues, First row and Last row. Check that the full address fits; shorten it or adjust Text size before printing if it clips. The sample uses deliberately short text and IDs. Scan both symbols on a test print and check that each returns DEMO-001.

Calibrate before printing labels

Use Labelbench’s Print calibration page and measure its 100 mm reference line with a ruler. If it is not 100 mm, adjust the printer dialog or printer settings and print the calibration page again.

For the label sheet, choose Actual size or 100% and turn Fit to page off. Confirm the paper size matches the selected template. Print one test sheet and check alignment before printing more.

Optional further reading

Avery’s instructions describe importing spreadsheet data into its own label software. They are optional background reading; this guide is not an endorsement and Labelbench has its own controls.

Open Labelbench

Download the fictional CSV sample

Tools