Sample file
Download example data
Use these files to test the generator. The basic Excel file includes barcode, product name, price, and SKU columns. The Shopify CSV follows a common product export shape with SKU and barcode fields.
Variant BarcodeUse as the barcode column when Shopify already has barcode values.Variant SKUUse as the barcode column for internal stock and packing labels.TitleUse as the product name column.Variant PriceUse as the optional price column.Worked example: five rows, three usable labels
A barcode is an identifier, not a calculation. This deliberately small fixture shows how to check that importing a CSV has not changed your codes. These are demonstration values for internal labels, not registered retail product numbers.
Download the five-row data check CSV| CSV value | Expected result |
|---|---|
| 0012345 | One label; both leading zeros remain. |
| 1E10 | One label with the literal code 1E10, not 10000000000. |
| 12345678901234567890 | One label; all 20 digits remain in order. Long codes need enough printed width. |
| (empty) | No label: a barcode value is required. |
| 한글 | No label: this generator accepts printable ASCII barcode values. Korean product names are allowed in a separate column. |
Run the check yourself
- Download the CSV and open the generator. Upload the file without first re-saving it in a spreadsheet app.
- Map barcode to the barcode field and product_name to the name field. Compare the preview against the table above.
- Expect three usable labels and two skipped rows. With the default 3 × 8 layout, the three labels fit on one A4 page. Skipped rows are not repaired automatically.
- Download the PDF. Before labeling real stock, print at 100% on plain paper and scan each label into a text field. The scanned text must match the CSV exactly.
The downloadable fixture is covered by automated import and row-validation tests. That does not certify physical printing or scanner performance. If Excel has already rounded a long numeric identifier or removed its leading zeros, this tool cannot reconstruct it: obtain the original source and store the column as text. The generic 24-label layout is not an Avery L7160 template; L7160 has 21 labels.
Open the generator →