How to print inventory labels from Excel or CSV

An inventory spreadsheet already contains much of what you need for a useful label: an item number, a description and a storage location. The main job is turning those columns into a consistent layout without losing the meaning of the data.

Our free inventory label maker does that in your browser. You can use an Excel workbook or CSV file, choose a label format and download a PDF. Your file does not need to be uploaded to a server.

Prepare a simple worksheet

Use one header row followed by one inventory item per row. Start with these columns:

Item Number	Description	Bin Location	Quantity
000123	Steel washer	A1	2
000124	Copper bolt	B2	1

Keep item numbers as text in Excel if leading zeros matter. If Excel has already changed 000123 to 123, an export cannot reliably reconstruct the missing zeros. Check your source before generating labels.

Remove report totals and unrelated notes from the data area. The tool can detect a header row and lets you choose another worksheet or header row when needed. You can also download a sample CSV to try the workflow.

Choose the label stock

Select the template that matches the physical labels you intend to use. Avery 5160/8160 sheets contain 30 labels on US Letter paper; Avery 5163/8163 sheets contain 10 larger labels. Thermal sizes create individual label pages. A custom thermal option is available when your stock is a different size.

The PDF page dimensions matter. Choosing a 4 × 6 inch template and then printing it on another paper size with automatic scaling will change the printed symbol size.

Map the fields and choose the code

Match the item number, description and bin location to your worksheet columns. Use Code 128 when you want a linear barcode for an existing inventory ID. Use the QR builder when you need several fields or a structured string in one symbol.

A Code 128 symbol is not a newly assigned UPC or EAN retail identifier. Confirm that your scanner and the software receiving scans support the format and expect the value you encoded.

Use one label per row, fixed copies, or a quantity column. Blank, zero, negative and non-numeric values in a quantity column produce no labels. Review the calculated total before downloading; this release allows up to 10,000 labels per batch.

Preview representative rows

Check the first item and the longest description, then inspect a few different rows. Confirm that item numbers retain leading zeros and that the description and location fit the selected stock. Local images can be matched by filename to an item number on image-capable templates.

The on-screen preview helps you spot mapping and layout issues. The downloaded PDF and an actual print test are the final checks for your printer and label stock.

Print at actual size and scan a sample

Download the PDF and print a single test page at 100% or actual size. Turn off fit-to-page, shrink-to-fit and similar options. For label sheets, compare a plain-paper print against a sheet held up to the light before using adhesive stock.

Scan a printed sample with the device and software your team will actually use. Check the complete value, including leading zeros and separators. Small symbols, long values, low-resolution printers and poor contrast can affect scanning.

When the spreadsheet becomes the bottleneck

A free tool is useful for occasional batches. If staff repeatedly export the same report, rename columns and reprint labels after changes, the better next step may be connecting label generation to your stock or ERP records.

That work starts with identifying the authoritative item data, quantity rules and the event that should trigger a label. Explore our workflow automation and systems integration services if that is the recurring problem you need to solve.