Printing Shipping Labels From a Spreadsheet Without Word Mail Merge

If you sell online, you probably have the same weekly ritual: export orders, get addresses onto labels, pack, ship. The middle step is the one that's needlessly annoying. And the traditional answer, Word's mail merge, is a awkward tool for a task this simple.

Why mail merge is painful for this

Mail merge was built for a world of one-off, large mailings set up by someone with time. It expects you to link a data source, insert merge fields, run a preview, then finish and merge. A multi-step wizard you re-navigate every single time. If your column headers change between exports (and marketplace exports do change), the links break and you redo the setup.

For a task you repeat weekly with twenty rows, the setup overhead badly outweighs the actual work.

What the workflow should be

Realistically it should be four steps:

1. Copy the relevant columns from your order export.
2. Paste them somewhere.
3. Say which fields go on which line of the label.
4. Print.

Nothing about the task requires more than that. The pasted data already has column headers; the tool can read them and offer them as fields.

Practical tips for order exports

Handle the "Address Line 2" problem

Most order exports have an optional second address line that's empty for the majority of orders. If your label template puts it on its own line unconditionally, you get an awkward blank gap on most labels. A template system worth using collapses empty fields automatically so the remaining lines close up.

Don't forget the part-used sheet

You almost never use exactly a full sheet. Last week's batch ended mid-sheet and you kept the remainder. Being able to say "start at label 14" is the difference between using that sheet and wasting the top half of a new one. A small feature that quietly saves real money over a year of weekly shipping.

Consider a barcode if you pick from a warehouse or spare room

If your labels include an order number or SKU, adding a scannable barcode makes verification at pack time much faster and near-eliminates the "shipped the wrong item to the wrong person" error, which is expensive in refunds and reviews alike.

Match the sheet to the job

A 30-per-sheet address layout is right for return addresses and small parcels. For anything going through a courier that needs a readable address at arm's length, a 10-per-sheet or 6-per-sheet shipping layout is a better fit. Using the small layout for everything is a common false economy. An address that has to be squinted at gets misdelivered.

The one thing that causes wasted sheets

Print scaling. Set it to 100% or "Actual size", never "Fit to page". This single setting causes more ruined label sheets than every other factor combined. It's covered in more detail in our piece on label alignment.

For forms rather than labels, batch fill does the same thing: one template, one row per document.