Practical label workflow
Print Labels from Excel Without a Dedicated Label-Design Package
You can prepare a practical label batch without installing a specialist label-design application, provided the browser tools match your job. This guide distinguishes barcode images in a workbook, variable-content label pages and repeated copies of one design. It is for small stock operations that already have approved identifiers and want a controlled first print.
Updated 18 October 2026
Use Excel Barcode for barcode images embedded in XLSX plus PNG ZIP files; use Excel Bulk Labels with its official template for variable label content and PDF or PNG ZIP output. Print Studio is a separate manual workflow for repeating one design. None of these actions connects automatically to your inventory database or configures the printer driver.
Choose the deliverable before preparing the workbook
If the next person needs a spreadsheet containing barcode images, the Excel Barcode tool is the direct route. If they need individual physical labels with product text, use Excel Bulk Labels. If the job is many identical copies of one label on an A4 sheet, Print Studio is more appropriate. These outputs are related but not interchangeable: a workbook with images is not automatically a correctly imposed adhesive sheet, and a PNG archive does not know your printer’s stock dimensions.
Start from the official label template
Download the template offered by Excel Bulk Labels and keep its Labels worksheet structure. The expected columns are Product Name, Code, Expiry Date and Amount; Code is required. The other columns are display information rather than instructions for assigning a product identity. Fill a small sample first. Include an ordinary item, the longest intended name and the longest code. Follow the template’s example-row instructions instead of renaming headers or importing an arbitrary workbook that happens to look similar.
Preserve identifiers as approved text
A code such as STOCK-0042 is an internal example, not a newly assigned retail GTIN. Keep approved values intact, including meaningful leading zeros. Spreadsheet number formats can make a numeric value look padded without preserving the original text. Before uploading, inspect the formula bar and source export. Do not rebuild a supplier code from a shortened number, and do not treat successful image generation as confirmation that an EAN or GTIN was allocated to your product.
| Need | Public workflow | Result |
|---|---|---|
| Images alongside spreadsheet data | Excel Barcode | XLSX and PNG ZIP |
| Variable product labels | Excel Bulk Labels | PDF or PNG ZIP |
| Repeated manual design | Print Studio | A4 or thermal PDF |
| Custom four-across variable roll | Separate layout step | Not an automatic preset here |
Keep displayed quantity separate from repeated output
The Amount column is label content; it is not a per-row command to create that many physical copies. If the design calls for a visible pack amount, confirm how that text appears on a candidate. Plan repetitions in the actual print process, using the intended PDF pages or an explicitly prepared source list. Mixing displayed quantities with printer copies can produce either too few labels or duplicate identifiers. Test this distinction with two rows before preparing a thousand-row file.
Generate a sample design and examine the extremes
Choose the available label shape, physical size and supported code type. Generate candidates, inspect a real sample and deliberately select a design. The existing workflow checks all rows before enabling final output; an unsafe row should be corrected, not silently omitted. A short first record can look fine while a later long description overflows. Review the longest values and any accented product names rather than approving a design from the first row alone.
Respect the workbook and geometry boundaries
The public label import accepts XLSX within its current 10 MiB and 1,000-data-row limits. It is not a database merge, a background print queue or an unrestricted spreadsheet interpreter. Workbooks are processed in the browser. For arbitrary multi-column roll stock or a specific pre-cut sheet preset, confirm that the output workflow actually supplies the required geometry; do not infer support from a custom label-width field. Unsupported layout arrangements require a separate suitable imposition process.
Print the downloaded PDF at its intended size
Open the generated file in a PDF application, select the actual stock size and choose an unscaled print setting such as Actual size or 100 percent. Inspect both the PDF application and driver for additional fit-to-page settings. Print a few labels, measure the physical edges and scan the encoded content into the receiving application. Adjust printer setup separately from source identifiers: changing a product code will not correct an offset or a paper-size mismatch.
Keep a repeatable handoff instead of a one-off success
Save the approved source workbook, selected settings and a sample output together in your own local records. Note which printer and stock were tested. If a colleague repeats the job, they should know which file is authoritative and which draft must not be printed again. A common mistake is saving only the PDF while leaving two conflicting spreadsheet versions in circulation. Confirm row count, first and last record, exception handling and disposal of superseded labels before expanding the batch.
Common questions
Frequently asked questions
Is a barcode font required?
No font installation is needed for the browser-generated images and PDFs described here. Your separate spreadsheet or print application can still have its own requirements.
Will the tool create missing product numbers?
No. Supply the identifier your operation has approved. A generator renders data; it does not allocate a GS1 company prefix or invent a valid product register.
Can the file contain any column names?
Use the official Labels template for Excel Bulk Labels. The general Excel Barcode tool is a different workflow with worksheet and value-column selection.
Does a successful export prove the labels will work?
No. Check the downloaded file, physical scale and decoded value in the receiving system. Paper, printer setup and application field rules remain part of acceptance.
Sources & standards
Technical claims in this guide are checked against primary or official documentation where available.