Barcodes for Serial Numbers and Asset Tags

Serial number vs asset ID: decide what the barcode identifies

A serial number normally distinguishes one physical unit from other units of the same model. An internal asset ID can instead be the organization’s own tracking key for a laptop, machine, tool or other equipment.

Do not overload one value with multiple meanings. If the manufacturer serial and your internal asset number are both operationally useful, store both in the database and decide which one workers need to scan most often.

Choose Code 128, Code 39 or QR based on the workflow

GS1 has separate identification keys for assets

GS1 defines identifiers beyond GTIN. Its identification-key portfolio includes the Global Individual Asset Identifier (GIAI) for individual assets and the Global Returnable Asset Identifier (GRAI) for returnable assets such as pallets, crates or totes. These are different from a GTIN, which identifies trade items.

If a trading partner or regulated workflow requires a GS1 asset key, implement that standard specifically. BarcoBatch’s generic Code 128 and QR tools can create internal symbols, but they do not allocate or certify GS1 asset identifiers.

Design the asset tag for years of real use

• Keep the encoded identifier stable for the life of the asset record.
• Print human-readable text so the ID can be entered manually when a scanner is unavailable.
• Choose label stock and adhesive for heat, abrasion, cleaning and surface type.
• Do not place the code where handles, hinges or curved surfaces routinely damage it.
• Test worn-label scenarios before committing to thousands of tags.

Generate a list of serial or asset barcodes from Excel

If asset IDs or serials already exist in a spreadsheet, bulk generation reduces copying errors. BarcoBatch Excel Bulk can create Code 128 images for many rows while keeping each source value intact.

Create a controlled counter rather than guessing supplier serials

If your organization is assigning new internal asset IDs, it can choose a documented prefix and counter. An illustrative sequence might runASSET-000001 throughASSET-001000. This does not authorize replacing a manufacturer’s serial number or producing GS1 retail identifiers. Reserve a non-overlapping range in your own register before generating labels. Decide how retired numbers are treated and who can allocate the next range; a spreadsheet formula by itself does not prevent another person from generating the same sequence.

Use spreadsheet formulas only for a deliberate new sequence

In supported Excel versions, =SEQUENCE(1000,1,1,1) creates a thousand integers. A text expression such as="ASSET-"&TEXT(A2,"000000") can turn a counter cell into an agreed fixed-width internal string. Function names and separators vary with spreadsheet language and version; use the installed application’s documented equivalent. This is intentional creation from a naming rule, not repair of a damaged imported identifier. Inspect the beginning, end and boundary transitions, then copy approved results as values for a stable export.

Check uniqueness across files, not only within one column

A duplicate check inside the current workbook can miss an ID used in last month’s asset batch. Compare the reserved range with the authoritative register, confirm the expected thousand distinct values and preserve meaningful text. Do not allow a recalculating formula or a row insertion to alter identifiers after labels have been applied. Use the current public Excel workflow for images or the official Bulk Labels template for label pages, within its limits; neither tool reserves the sequence in your organization’s system.

Test the resulting asset lookup as well as the symbol

Print samples covering the shortest and longest values, scan them into a safe asset record and compare exact strings. For durable tags, check the chosen stock, adhesive and placement under actual handling conditions. An asset identity can remain stable while department, user or location changes; keep mutable properties in the record instead of rewriting the key on every move. Record rejected prints and regenerate the same intended identity when replacing a damaged tag, rather than allocating a fresh number without reviewing the asset relationship.