If you keep your orders in Excel you can print an address label from the list without any add-in. This guide uses INDEX and MATCH to fill a label from a chosen row. The free shipping label template is already set up this way.
Updated November 2026
Step 1: Make the list
Put each package on its own row with a number, name, street, city, state, ZIP, weight, service and reference. The number is what you will pick later.
Step 2: Make a label sheet
On a second sheet, put a cell where you type the shipment number. Name it B3, for example. Add a drop-down so only valid numbers can be chosen; see the data validation guide.
Step 3: Pull in the address
Use MATCH to find the row and INDEX to read from it: =INDEX(Shipments!B10:B39,MATCH($B$3,Shipments!A10:A39,0)). Do the same for street, and join city, state and ZIP with &: =INDEX(D,m)&", "&INDEX(E,m)&" "&INDEX(F,m). For shipment 2 it returns Phoenix, AZ 85001.
Step 4: Format and print
Use a large bold font for the ship-to block and a box border around the label. Set the print area to the label only. Print a test on plain paper before you use label stock.
Step 5: Next package
Change the number and print again. The total weight of the sample list, =SUM(G10:G39), is 13.3 lb.
When to use a carrier system instead
An Excel label is an address label. If you need postage, a tracking barcode or insurance, create the label in your carrier’s tool.
Frequently asked questions
Can I print shipping labels from Excel?
Yes. Use INDEX and MATCH to fill a label sheet from your list, then print it.
Do I need mail merge?
No. INDEX and MATCH is enough for one label at a time.
Will it include a barcode?
No. Use the carrier’s system for tracked labels.
Is there a template?
Yes. The shipping label template on this site is ready to use.