Print Shipping and Inventory Labels From a Spreadsheet — Without Re-Typing a Single Row
Every small seller and shop owner already has the database. It's the spreadsheet: SKUs in column A, product names in column B, prices, bin locations, quantities. The painful part was never the data — it's that most label tools make you re-type it, one label at a time, into little boxes.
That's an afternoon of your life, plus the typo that puts the wrong barcode on the wrong product. Here's the flow that skips all of it. The full tool walkthrough lives on our barcode labels from a spreadsheet page; this is the working routine.
Step 1 — Clean the sheet (five minutes, saves fifty)
Before you import anything:
- One header row. Name columns plainly:
SKU,Name,Price,Bin. The importer maps columns — clear names map correctly the first time. - Delete true duplicates, but keep intentional quantity rows. Ten rows of the same SKU can mean ten labels — know which meaning yours has.
- Kill blank rows in the middle. A blank row mid-sheet is the #1 cause of "where did my last 40 labels go?"
- Text-format your SKU column if SKUs start with zeros. Spreadsheets love eating leading zeros; your barcodes won't forgive it.
Step 2 — Map columns to label fields
Point each label element at a column: barcode value ← SKU, top line ← Name, bottom line ← Bin or Price. You're designing one label; the sheet supplies the other 300. This is the entire trick, and it's why the spreadsheet route beats any single-label tool past about ten labels.
Step 3 — Do the sheet math before you print
How many labels per sheet, at your label size, with your margins? Guessing here is how a 300-label job becomes 340 labels and two wasted sheets. Run it through the label sheet calculator first — enter the label size, sheet size, and count, and print exactly the sheets you need. The CSV-specific details are in our guide to creating barcode labels from CSV.
Step 4 — Print a test sheet. Always.
One test sheet, scanned with a phone, checked against the spreadsheet's first and last rows. If the first and last labels are right and the barcodes scan, the middle is right — that's the beauty of printing from data instead of typing.
Shipping labels, inventory labels — same flow
The routine above works for shipping labels you'll add alongside the carrier's own label (bin IDs, internal order codes, "fragile — this side" markers) and for shelf and inventory labels. Same sheet discipline, different template.
When the free maker isn't enough
The free maker stays free — that's a promise built into Batch Label Studio, and for generator-and-print jobs it may be all you ever need. The Pro upgrade is a one-time $29.99 (pay once, keep it — not a subscription) and its headline feature is batch CSV import: drop the whole file in and generate the full run in one pass. If your spreadsheet has hundreds of rows and this is a weekly job, the math sells itself; if you print twenty labels a month, stay free with a clear conscience.
A shop that runs this exact routine: TrendTapSupply, a small gadget store whose product list lives in a spreadsheet and whose order labels come off it — proof you don't need a warehouse system to print like one.