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
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
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.
Made in Cloudlabels with the template “Hang Tag 50×90 · EAN-13”, 50 × 90 mm each. Not drawings. 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.
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”.
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”.
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.
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.
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.
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.


