Cloudlabels home

Guides

How to make hang tags from a spreadsheet

Keep one row per style, size and colour in a spreadsheet, design one hang tag, and let each row fill in its own tag. This guide goes through it step by step in Cloudlabels, from the Excel file to a PDF you can print.

Written by Michael, who builds Cloudlabels · Last updated

Text version of the video

The Design Center in Cloudlabels with a 50 × 90 mm hang tag. The sheet is Tidewick and the preview item is 1. The size field on the tag is selected, and the panel on the right shows Content set to From product and Data field set to Size.

The tag shows TIDEWICK, Keelson Hoodie, colour Black, size S, the price 149 and an EAN-13 barcode, 2011886946663.

The pointer clicks Next item five times. Each click loads another row of the sheet into the same design: Keelson Hoodie Care Sample in Navy, size L, 149. Dockside Tote in Natural, One Size, 29. Stormline Beanie in Signal Red, One Size, 35. Harbor Merino Tee in Black, size L, 69. Keelson Shell Jacket in Signal Orange, size M, 219.

The name, colour, size, price and barcode change on every click. The layout stays the same.

What you need

  • A spreadsheet with one row for each variant: one row per style, size and colour.
  • Columns for what goes on the tag, for example product name, colour, size, price, SKU and barcode number.
  • Your logo as a PNG or JPG file, if you want it on the tag.
  • A Cloudlabels account. The Free plan is enough to follow along with up to 20 items.

Step by step

  1. Set up the spreadsheet: one row per tag

    A hang tag belongs to one variant, not one style. A hoodie in three sizes needs three rows, even though only the size and the barcode differ. Put each thing you want printed in its own column.

    • Use a header row with plain column names, such as Product, Colour, Size, Price, SKU and Barcode.
    • Keep the price as a number in its own column, so you can change it in one place later.
    • Give every variant its own barcode number. Two rows must never share one.
    • Tidewick hang tag, 50 × 90 mm: Keelson Hoodie, colour Navy, size S, price 149 and an EAN-13 barcode.
    • Tidewick hang tag, 50 × 90 mm: Harbor Merino Tee, colour Oat, size M, price 69 and an EAN-13 barcode.
    • Tidewick hang tag, 50 × 90 mm: Keelson Shell Jacket, colour Slate, size L, price 249 and an EAN-13 barcode.
    Made in Cloudlabels with the template “Hang Tag 50×90 · EAN-13”, 50 × 90 mm each. Not drawings.
  2. Import the file into Items Table

    In Cloudlabels, open “Items Table” and choose “Import / Export”, then “Import Excel” or “Import CSV”. With an Excel file you get two checks before anything is saved.

    • “Review column mapping” shows each column in your file next to the column it will land in. Columns are matched by name, and the rest can be added as new columns.
    • “Review import” shows how many rows will be added and flags barcode and SKU conflicts. Nothing is written until you choose “Approve”.
    • No file yet? You can type the rows straight into the table instead.
  3. Start from a hang tag template

    Open “Labels”, go to “My labels” and choose “Browse templates”. Under “Product labels”, the section “Clothing and footwear” has hang tags in 50 × 90 mm and 2 × 3.5 inch, with an EAN-13, UPC-A or Code 128 barcode already placed. Pick one and choose “Use template”.

    • Prefer your own size? Choose “Design new label” and set “Width (mm)” and “Height (mm)” under “Size”.
  4. Connect each field to a column

    The template arrives with fields for brand, name, colour, size, price and barcode. Select a text field, set “Content” to “Dynamic” and pick the matching column under “Data field”. A field that shows “[Pick a field]” has no column yet.

    • Do the same for the barcode: set it to “Dynamic”, choose the “Type” and pick your barcode column under “Data field”.
    • Text that is the same on every tag, such as your brand name, stays “Static”.
    • On a catalog sheet the two choices are called “Fixed text” and “From product”.
  5. Add your logo

    Add an “Image” element and upload your logo, then place and size it on the tag. The logo is saved in your “Image library”, so it is there for the next label you design.

  6. Check the tag against real rows

    Before you print, step through your products with “Previous item” and “Next item” at the top of the Design Center. Look at the longest product name and the widest size, such as XXL, and make sure nothing is cut off. Then choose “Save” and give the label a name.

  7. Choose how the tags are printed

    For label sheets, open the “Sheets” tab in the Design Center and turn on “Enable Custom Label Sheet”. “Create New Template” opens the “Sheet library” with Avery and HERMA sheets, or you set up your own with paper size, columns, rows and gaps. For a roll printer or a label press, the label can hold one tag per page instead of a full sheet.

  8. Export the PDF and print

    Go back to “Items Table” and tick the rows you want tags for. Choose your saved label, then “PDF”. In “Generate PDF” you set the print quality and, for label sheets, where on the sheet to start and how many copies of each tag you want. Choose “Export PDF”, then print the file or send it to your printer.

    • “Start from position” lets you use a partly used sheet.
    • “Copies per label” is one number for all the rows you ticked: 1, 2, 3, 5 or 10, or a full sheet. If you need 10 of size M and 2 of size XL, export them in two rounds.
    • Pro and Business export at 600 DPI. The Free plan exports at 300 DPI with a small watermark.

Mistakes that cost a reprint

  • One row per style instead of one per variant.If the sheet has one row for the hoodie and all the sizes in a single cell, every tag gets the same text. Split it into one row per size and colour before you import.
  • The same barcode on two variants.The till cannot tell size M from size L if both carry the same number. Look at the barcode conflicts in “Review import” before you approve.
  • Designing around a short name.A tag that looks right with “Tee” can overflow with “Organic Cotton Long Sleeve Tee”. Step through the rows and check the longest one.
  • Leaving without saving.Choose “Save” before you leave the Design Center, so the label is there when you come back to print.
  • Printing the whole run before a test.Print one page on plain paper first and hold it against your tags or label sheet. Scan one barcode with the till or a phone before you print the rest.

Questions

Still unsure? Contact us

Do I need a barcode on a hang tag?

Not to make the tag. A hang tag can carry only text, such as name, size and price. If your shop or your retailers scan at the till, add an EAN-13 or UPC-A from your barcode column.

Which barcode types can I use on hang tags?

EAN-13, UPC-A, UPC-E, EAN-8, Code 128, GS1-128, ITF-14 and Code 39 for linear barcodes, and DataMatrix, GS1 DataMatrix and PDF417 for 2D codes. QR codes are a separate element, so one hang tag can carry an EAN-13 for the till and a QR code that links to care or product information. Each sheet has its own barcode standard, and EAN and UPC numbers are checked when you enter them.

Can I reprint a single size later?

Yes. Tick only that row in the table and export again. There is no minimum order.

What happens when a price changes?

Change the price in the table and export the tags again. The design stays the same, because the price field reads from the column.

What size should a hang tag be?

There is no single standard. The ready-made hang tag templates are 50 × 90 mm and 2 × 3.5 inch, and you can set any width and height in millimetres.

My product list is in Google Sheets. Can I use it?

Yes. Download the sheet as an Excel (.xlsx) or CSV file and import that file.

Is the Free plan enough to try this?

Yes, for a small test. The Free plan includes 20 items and 200 labels per month, at 300 DPI with a small watermark. Pro and Business start with a 7-day trial, no credit card.

Try it with your own product list