How to Prepare & Print Asset Tags from an Excel List
Turn a spreadsheet of asset numbers into sequential, scannable tags — how to structure the data and hand it off for production.
Steps
- Structure your spreadsheet. Put one asset per row, with a column for the asset number and any variable text (department, owner, 'Property of…'). Keep the numbering format consistent — e.g. AB-00001 to AB-00500 — so the sequence is unambiguous.
- Decide the code type. Choose a 1D barcode (Code 128 is the common default), a QR code, or a plain human-readable serial. QR suits linking to a record URL; 1D barcodes suit fast handheld scanning.
- Generate or specify the codes. You can generate barcodes in your asset software, or simply supply the number column and let the manufacturer render the codes. Confirm the symbology and quiet-zone so scanners read reliably.
- Export as CSV. Save the sheet as CSV (UTF-8). This is the clean, unambiguous format for variable-data production and avoids formatting surprises from native spreadsheet files.
- Send for a proof. Attach the CSV with your material, size and mounting spec. Review the digital proof — check a sample tag and a scan test — then approve for production.
If you already track assets in a spreadsheet, that list is your print file. The job is to hand off clean, consistent data so every tag comes out with the right number, in the right sequence, and scans first time. Here’s the reliable path.
What “print” really means for durable tags
For paper labels you’d print in-house, but durable metal and sealed film asset tags are produced on industrial lines — laser-etched, engraved or printed and sealed. So “printing from Excel” here means preparing variable data that a manufacturer marks onto the tags. The upside: permanence and scannability you can’t get from an office printer.
Common mistakes to avoid
- Inconsistent number formats — mixing
1,01andAB-001breaks the sequence. Pick one pattern. - No quiet zone — barcodes need clear margin around them to scan; don’t crowd the tag.
- Skipping the scan test — always verify the proof’s code reads with your actual scanner before approving a full run.
Once your CSV is ready, send it with your serialized or barcode tag spec and we’ll return a free proof — including a scan check — before anything is produced.