Print auto parts barcodes from Excel

The catalog export is part, name, and bin. Design one sticker, barcode the part, print the wall before the rush.

← Back to Blog

Print auto parts barcodes from Excel

Published: · 3 min read · How-to
Open the free label maker: https://app.mylabelmaker.com. No signup. Design the label, then print to a Zebra or download PNG, PDF, or ZPL.

Open product sticker template

You can print auto parts barcodes from Excel. Open the free label maker, barcode {{part}}, add {{name}}, upload the catalog, and print the wall before Saturday. No signup. Use the part number the counter actually scans.

Good to know: Use the part number the catalog and the counter scan. Do not invent a second shop code unless you will scan that code.

How to print auto parts barcodes from Excel

  1. Open https://app.mylabelmaker.com. No signup.
  2. Headers: part, name, bin. Set 2x1.
  3. CODE128 with {{part}}. {{name}} under it. {{bin}} in the corner.
  4. Upload the Excel file. Scan a filter you stock. Print.

Sample spreadsheet

A Friday restock for fast movers.

partnamebin
PH8AOil filterW-12
24-60Cabin filterW-14
96-08Air filterW-08

First row is the header. Those header words go inside the curly braces on the label, like {{part}}.

Receiving the shipment first: receiving from a PO. Generic auto labels: automotive parts labels.

Print or save

Got a Zebra? Print with Browser Print at the printer's DPI. Everyone else: print from this computer, or download PNG, JPG, SVG, PDF, or ZPL. Save JSON if you want the editable master back later.

Print this restock wall

The catalog numbers. Stickers on the hooks.

Open free label maker