Packing List Template Excel – 3 Free Versions

Home › Operations, Inventory & Logistics › Packing List Template Excel

packing-list-template-excel.xlsxSample data
Packing list template Excel with an export packing list showing shipper or exporter, consignee, notify party, shipment references, terms and equipment, a calculated shipment summary and a package detail with HS code, origin, weights and dimensions

Previewing: Version 1 · Export Packing List. Pick another version on the right.

Instant download · No sign-up · No email

Your numbers stay in your file. Nothing is uploaded and nothing is tracked.
3 free Excel templatesUpdated Nov 2026

Download these free packing list templates for Excel to document what is in a shipment. One version is an export packing list with shipper, consignee, HS codes, weights, volume and container details. One is a fulfillment board that tracks orders, packs them and prints a packing slip. One is a pallet packing list that records what went into each carton and each pallet and checks the weights.

Choose your version

File
.xlsx · 26 KB · 3 sheets
Works with
Microsoft Excel (.xlsx)
Macros
None · formulas only
Price
Free

Make a packing list in an Excel spreadsheet

A packing list is a document that describes the contents of a shipment: how many packages there are, what is in each one, how much each weighs and how big it is. Freight forwarders, carriers, customs and the buyer use it to check that what arrives is what was sent, and for export shipments it goes with the commercial invoice. A spreadsheet is a good tool for it, because the weights, the volumes and the totals are calculated from the lines that you enter, and you can reuse your product list for every new shipment.

These Excel templates cover three ways of working with packing lists. The first is an export packing list in the usual layout: shipper or exporter, consignee and notify party, the references, the ports, the Incoterms, the container and the seal, and a package detail with the SKU, the HS code, the country of origin, the net and gross weights and the dimensions, with a summary of the total packages, the weights and the volume. The second is a fulfillment board for a business that packs many orders: it follows the order pipeline from not started to shipped, shows the fill rate, the on-time shipping and the carrier performance, and prints a packing slip for any order. The third is a pallet packing list for truck shipments: you record what went into each carton and each pallet, and the workbook checks the weights, the volume and the pallet height, compares what was packed with what was ordered and builds the packing list.

Best for

  • Exporters, importers and freight forwarders that prepare shipping documents
  • Warehouse and fulfillment teams that pack, check and ship orders
  • Manufacturers and distributors that ship pallets and cartons by truck or by container

Maybe not for

A freight forwarding or warehouse management system. These templates are Excel files that you fill in and print or save as a PDF. They do not replace the requirements of your carrier or of customs. If you need a personal list for a trip or a move, you will find that these templates are made for goods and shipments.

Which version is right for you?

All three are free, formula-driven Excel files with sample data you can replace. They are independent, so you can download more than one.

Version 1

Export Packing List

Packing list template Excel with an export packing list showing shipper or exporter, consignee, notify party, shipment references, terms and equipment, a calculated shipment summary and a package detail with HS code, origin, weights and dimensions

An export packing list with party boxes, references, terms and equipment, a calculated shipment summary and a package detail with HS codes, origin, net and gross weight, dimensions and volume.

Packing ListProduct CatalogSettings

.xlsx · 26 KB

Version 2

Fulfillment Board

Excel packing list template with a fulfillment board showing orders, units shipped, fill rate, on-time shipping, due or overdue orders and value shipped, an order pipeline by status, ship next orders, carrier performance and backordered units by SKU

A fulfillment board with an order pipeline from not started to shipped, a ship-next list, carrier performance, backordered units by SKU and a packing slip that prints for any order.

Fulfillment BoardPacking SlipOrdersOrder LinesSetup

.xlsx · 220 KB

Version 3

Pallet Packing List

Packing list Excel template with a pallet packing list showing shipper, consignee, shipment details, a pallet summary with cartons, units, net and gross weight, volume and a contents check, and the contents listed by pallet and carton

A pallet packing list built from a carton detail sheet, with a pallet summary, weight and height checks, an order match against what was ordered and a list of the contents by pallet and carton.

Packing ListPacking DetailOrder CheckSpecs

.xlsx · 98 KB

What is inside the packing list Excel templates

Version 1: Export Packing List

The Packing List sheet has your company and the document status, boxes for the shipper or exporter, the consignee and the notify party, the shipment references (packing list number, commercial invoice number, customer PO, document date, ship date, freight mode, carrier or forwarder, vessel or flight) and the terms and equipment (port of loading, port of discharge, Incoterms, payment terms, equipment planned, container and seal). A shipment summary adds up the total packages, the net and gross weight, the packaging tare, the volume, the chargeable weight and how full the equipment is. The package detail has one row for each group of identical packages with the package numbers from and to, the type, the SKU, the description, the HS code, the country of origin, the quantity per package, the total quantity, the net and gross weight, the dimensions, the volume, the dimensional weight and the marks and numbers. The Product Catalog sheet holds your products with HS code, origin, net weight, value and units per carton, and the Settings sheet holds the calculation settings, the equipment capacities and the lists.

Version 2: Fulfillment Board

The Fulfillment Board has a period and a channel filter and shows the orders, the units shipped, the fill rate, the on-time shipping rate, the orders that are due or overdue and the value shipped. The order pipeline counts the orders, the units and the value in each status (not started, packing, awaiting check, ready to ship, shipped partial and shipped) with a list of the orders to ship next, a table of carrier performance (shipped orders, on time, average days, cartons and weight), the backordered units by SKU and a summary of the orders by channel and payment plan. The Orders sheet holds about 400 orders with the shipping and verification details and calculated lines, units, fill rate, weight, value, status and days to ship, and the Order Lines sheet holds about 1,200 lines to pick and pack. The Packing Slip sheet prints the slip of the order that you select, and the Setup sheet holds your company, the product master and the lists.

Version 3: Pallet Packing List

The Packing List sheet shows the shipper, the consignee and the shipment (packing list number, invoice number, customer PO, ship date, freight mode, Incoterms, payment terms, carrier, planned equipment and seal or trailer number). A pallet summary lists each pallet with its type, its built height, its shipping mark, the number of cartons, the units, the net and gross weight in pounds and kilograms, the footprint, the volume, a height and weight check and a contents check. Totals show the packages, the gross weight, the volume, how full the equipment is and the order match. Below that, the contents are listed by pallet and carton, with the SKU, description, HS code, origin, quantity, net weight, lot or batch, carton gross weight, a scale check, the value and the carton mark. On the Packing Detail sheet you enter what went into each carton, up to about 300 lines, with the scale weight, and the sheet calculates the tare, the gross weight, the volume and the flags. The Order Check sheet compares the quantity ordered with the quantity packed and shows the variance and status, and the Specs sheet holds the product master, the carton types, the equipment and rules, the pallet types and the lists.

How to use a packing list template in Excel

  1. Download
    Pick the version you want and open it in Excel. The files have sample shipments for a made-up company, so you can see how each sheet works.
  2. Set up your lists
    On the catalog, setup or specs sheet, enter your products with their weights, HS codes and values, your package types and your equipment.
  3. Enter the shipment details
    Fill in the shipper, the consignee, the references, the ports or the destination, the Incoterms, the payment terms and the carrier.
  4. List the packages
    Add each line with its SKU, its quantity per package, the number of packages and the dimensions. The sheet calculates the weights, the volume and the totals.
  5. Check, print and send
    Look at the status and the flags, print the packing list or save it as a PDF, and send it with the commercial invoice or give it to the carrier.

Replace the sample content with your own. The totals, the weights, the volumes and the checks update on their own.

Which packing list template do you need?

Export Packing ListFulfillment BoardPallet Packing List
ForAn export or freight shipment with HS codesPacking many orders and printing slipsPallets and cartons on a truck
Best forExporters and forwardersWarehouse and fulfillment teamsManufacturers and distributors
Data you enterPackage lines from a product catalogAbout 400 orders and 1,200 order linesAbout 300 carton lines and an order check
Main outputsTotal packages, net and gross weight, volume, chargeable weight, equipment fillOrder pipeline, fill rate, on-time shipping, carrier performance, backordered unitsPallet summary, volume, gross weight, order match, weight and height checks
Sheets354
ChartsNoNoNo

They are separate files, so you can use more than one.

Tips for an accurate packing list

  • Give the packing list a number and a date, and match it to the commercial invoice and the purchase order.
  • Describe the goods in the same way on the packing list, the invoice and the order, so that customs and the buyer see the same thing.
  • Weigh the packages when you can. Use the scale weight rather than a calculated weight for the gross weight.
  • Measure the packages, and keep the dimensions with the packing list. Freight is often charged on volume.
  • Add the HS code and the country of origin for each product on export shipments.
  • Number the packages and the pallets, and write the same marks on the goods.
  • Compare what you packed with what the customer ordered before the truck leaves.

Frequently asked questions

Are these packing list templates for Excel free?

Yes. All three versions are free to download as .xlsx files. You do not need an account or an email address.

Which version should I choose?

Choose the Export Packing List (Version 1) for an export or freight shipment with HS codes, weights and a container. Choose the Fulfillment Board (Version 2) if you pack many orders and want to see the pipeline, the fill rate and the carrier performance. Choose the Pallet Packing List (Version 3) to record the contents of each carton and each pallet and check the weights.

What is a packing list?

A packing list is a document that lists the contents of a shipment: the packages, what is in them, and their weights and dimensions. It is used by the carrier, by customs and by the receiver to check the goods.

What is the difference between a packing list and a packing slip?

The terms are often used for the same thing. In general, a packing slip is a simple document that goes with a parcel to a customer, and a packing list is more detailed, with weights, dimensions and package marks, and is used for freight and export shipments. This site has packing slip templates as well.

What is the difference between a packing list and a commercial invoice?

A packing list describes the physical shipment and has no prices that matter for payment. A commercial invoice states the value of the goods and the terms of sale. For an export shipment you normally need both, and they must agree.

Can I use these templates for a travel or moving packing list?

No. These templates are for business shipments with products, packages, weights and carriers. They are not a checklist of clothes for a trip or of boxes for a move.

Do the templates calculate weights and volume?

Yes. They calculate the net and the gross weight, the volume and, in Version 1, the chargeable weight and how full the equipment is. Version 3 also checks the weight of each carton against the weight on the scale.

Does the template work in Google Sheets?

The files are made for Microsoft Excel and use standard formulas with no macros. You can upload them to Google Drive and open them with Google Sheets, but some formatting or charts may look different.

Is my information stored online?

No. The templates are plain Excel files, so the names, addresses, dates and amounts you type stay in your own file on your own computer.

These templates are document and tracking tools with made-up sample data. They are not legal documents or legal advice. Check the requirements of your carrier, your buyer and customs for each shipment, because the documents that are needed depend on the goods and the countries involved. Excel is a trademark of Microsoft Corporation; Excel Corner is not affiliated with Microsoft.