Brown cardboard boxes on a white metal rack - shipping label template

Shipping Label Template (Excel)

A free Excel shipping label maker: list your shipments, choose one by number and print an address label.

Download the free Excel file

What is in this template

The workbook has a Shipments sheet, a Label sheet and a How to use tab. It makes address labels for your own use from a list of orders.

Shipments

Enter your return address once at the top. List up to 30 packages with a number, who it is going to, street, city, state, ZIP, weight, service (Ground, Priority, Express or Freight) and your own reference such as an order number. Under the list are the count of shipments and the total weight.

Label

Choose a shipment number in the yellow cell. The label fills in from that row with the return address, the ship-to address in large type, the service and weight, and your reference. Only the label box prints. Change the number and print again for the next package.

How to use

Steps with links to both sheets.

The sample data

Four made-up shipments are listed with a total weight of 13.3 lb. Shipment 2 is selected on the Label sheet: Priya Nair, 9 Lake View Dr, Phoenix, AZ 85001, Priority, 1.4 lb, reference ORD-1002.

How to use it

  1. Enter your return address on the Shipments sheet.
  2. Add each package with the address, weight, service and reference.
  3. Go to the Label sheet and pick a shipment number.
  4. Print the label on paper or on label sheets.
  5. Repeat for the next number.

Tips

  • Check addresses against the order before you print.
  • Keep a reference on every label so you can find the order later.
  • Print a test on plain paper to check the size before you use label stock.
  • Use your carrier’s system if you need postage or a tracking barcode.

This makes an address label for your own use. It does not buy postage or create a carrier barcode.

Free pricing tips for your business

Get short, practical tips on pricing jobs and using our free calculators. No spam, unsubscribe any time.

    Built with Kit

    Frequently asked questions

    Does it buy postage?

    No. It prints an address label. Use your carrier’s system for postage and tracking labels.

    How do I print the next label?

    Change the shipment number on the Label sheet and print again.

    What size is the label?

    It prints as a box on a portrait page. Cut it out, or use it with label sheets after a test print.

    Are the addresses real?

    No. They are invented.

    Need a custom calculator or spreadsheet built for your business?

    Talk to us

    More free tools: All free calculators · Bill of lading template · Receipt template · How to print shipping labels from Excel