An Excel packing list template is a reusable worksheet for recording what is packed, how many packages or cartons are involved, and the shipment details needed to identify and check the goods. Create columns for item description, SKU, carton count, units per carton, and weights, then add formulas to calculate shipment totals; tailor the remaining fields to whether the list is for a move, warehouse transfer, or commercial shipment.
What a packing list does
A packing list describes the physical contents of a shipment so that the sender, recipient, warehouse staff, carrier, or customs broker can compare the document with the packages. It is a practical inventory and checking record: it can show which goods are in which carton, how many units are included, and the shipment’s package count and weight.
The term covers more than one kind of document. A household moving list might track box numbers, rooms, and fragile items. A warehouse list may identify SKUs, locations, and quantities. A list accompanying an international commercial shipment often includes shipper and consignee details, package marks, descriptions, quantities, and weights. One template can be adapted to these uses, but there is no single field set that suits every shipment.
A packing list is not automatically a commercial invoice, bill of lading, or customs declaration. Those documents serve different purposes and may be required separately. Requirements depend on the shipment, destination, carrier, and applicable rules, so confirm the requested paperwork with the carrier or customs professional rather than treating a spreadsheet template as a compliance guarantee.
Fields to include in an Excel template
Start with identification fields above the item table. Useful choices include the shipper and recipient names and addresses, shipment or purchase-order number, invoice reference if relevant, ship date, destination, and contact details. For a business shipment, include a reference that lets the receiver match the list to the order or delivery record. Avoid adding sensitive personal information that the recipient does not need.
A practical item table can use these columns:
- Carton or package number: A unique identifier, such as 1 of 8, that makes physical checking easier.
- Item description and SKU: A clear description plus an internal product code where one exists.
- Cartons and units per carton: Separate fields prevent a receiver from confusing the number of boxes with the number of products.
- Total units: A calculated quantity for each line.
- Net and gross weight: Record units and define the basis; net weight generally excludes packaging, while gross weight includes it.
- Dimensions and package marks: Add these when the carrier, warehouse, or recipient needs them.
- Notes: Use for practical details such as “keep upright” or a room name, not as a substitute for required shipping labels.
For example, a line might describe “ceramic mugs, SKU MUG-04,” with 12 cartons and 24 mugs per carton. A line-level total of 288 units is more useful than simply writing “12 boxes,” because the receiver can check both the carton count and the item quantity.
Build the worksheet in Excel
In Excel for Microsoft 365 on Windows, open a blank workbook and put the document title and shipment information near the top. Put the item-table headings in one row, with one product or packing line per row underneath. Keep the headings specific: “Cartons” is clearer than “Qty” when a separate units-per-carton field is present. Put measurement units in the heading or a nearby note, for example “Net weight (kg),” and use one consistent unit throughout the sheet.
For a basic version, place the following headings in cells A1:I1: Item, SKU, Cartons, Units per carton, Total units, Net kg per carton, Total net kg, Gross kg per carton, and Total gross kg. Enter shipment lines beginning in row 2. Add shipper, recipient, and reference information in a separate area above the table so it does not interrupt sorting or filtering.
Select the header row and the rows intended for the list, then choose Insert > Table and confirm that the table has headers. A table can make it easier to filter and extend the item list. If you prefer a plain range, use bold headings, borders, and a contrasting fill for the header row. Do not merge cells inside the item table: merged cells can interfere with sorting, filtering, and copying records.
Use formulas for quantities and weights
Formulas reduce arithmetic errors, but they are only as reliable as the entered figures and units. With cartons in column C and units per carton in column D, enter the line calculation in E2. For 12 cartons containing 24 units each, the result is 288 units.
With cartons in C2 and units per carton in D2, enter this in E2 to calculate total units: =C2*D2.
With cartons in C2 and net kilograms per carton in F2, enter this in G2. For 12 cartons at 8.5 kg net each, the result is 102 kg net.
With cartons in C2 and net kilograms per carton in F2, enter this in G2 to calculate line net weight: =C2*F2.
With cartons in C2 and gross kilograms per carton in H2, enter this in I2. For 12 cartons at 9.2 kg gross each, the result is 110.4 kg gross.
With cartons in C2 and gross kilograms per carton in H2, enter this in I2 to calculate line gross weight: =C2*H2.
Copy the formulas down for the other item rows. To show totals below a list that uses rows 2 through 100, use a total row and sum the appropriate columns. For example, with carton counts in C2:C100, this returns the total carton count: =SUM(C2:C100). With total units in E2:E100, this returns total units: =SUM(E2:E100). With total net weights in G2:G100, this returns total net kilograms: =SUM(G2:G100). With total gross weights in I2:I100, this returns total gross kilograms: =SUM(I2:I100).
Check that the example arithmetic agrees with the source records: 12 × 24 = 288 units, 12 × 8.5 = 102 kg net, and 12 × 9.2 = 110.4 kg gross. If some cartons have different contents or weights, do not use one carton figure for the whole line; split the goods into separate rows or record actual package-level values.
Adapt the list to the shipment
For a home move, replace SKU and commercial references with fields such as box number, room, contents, and priority. A box labeled “Kitchen, 3 of 6” is easier to locate than one labeled only “Kitchen.” Keep a separate note for valuable or fragile contents if that helps with handling, but remember that a spreadsheet list does not replace any insurance inventory or carrier form that may be requested.
For business shipping, retain product identifiers and order references, and use package numbers that match the physical labels. If a package contains multiple products, a separate line for each product can make quantities easier to reconcile. If the receiver needs to know exactly which carton contains each SKU, include carton number on every item line or maintain a package-by-package breakdown. A single shipment total cannot answer that question by itself.
For international shipments, include clear goods descriptions and weights where requested, and make sure the list agrees with the invoice and other shipping documents. A packing list typically helps describe how goods are packed, while invoice details and declarations may be needed for other purposes. Do not guess at official commodity classifications, origin statements, or regulatory declarations based only on a spreadsheet example.
Make the sheet readable and printable
Use a consistent date format and number format, and put units in headings so a value such as “8.5” cannot be mistaken for pounds when it means kilograms. Avoid typing totals manually when a formula can calculate them. A useful review is to compare the Excel totals with the actual package count and the figures on related paperwork before sending the file.
For a long list, freeze the heading row using View > Freeze Panes > Freeze Top Row in Excel for Windows. To prepare a printout, set the relevant range with Page Layout > Print Area > Set Print Area, and use Page Layout > Print Titles if column headings should repeat on printed pages. Check the print preview: wide tables may need landscape orientation or scaling, and excessive shrinking can make the text unreadable. Menu names and locations can vary slightly across Excel for Mac and Excel for the web; check their Page Layout or print settings rather than assuming every Windows control is identical.
When sharing, an Excel workbook is useful if the recipient needs to filter or reuse the data. A PDF is often more suitable when the recipient only needs a fixed, printable copy. Keep the workbook as the working record if formulas matter, and inspect the PDF after export to ensure that columns, totals, and page breaks are visible. A CSV file is not a substitute for the formatted workbook: it does not preserve features such as cell formatting and multiple worksheets.
Common mistakes to avoid
- Mixing package count and item count: State cartons and units separately, then calculate the total units.
- Leaving out units: Label weights and dimensions with units, and avoid mixing kilograms with pounds in the same total.
- Using vague descriptions: “Parts” may be hard to reconcile; include a product name or SKU that the receiver can recognize.
- Duplicating or skipping carton numbers: Check that the identifiers on the worksheet match the physical package labels.
- Assuming a template is an official form: A generic Excel list may not satisfy a carrier, destination, or regulator’s separate documentation requirements.
- Overwriting calculated cells: Protect formulas from accidental edits or review them before printing and sharing.
One frequent misconception is that a packing list must show the value of every item. A value field may be useful for an internal inventory or may appear in a document required for a particular process, but a packing list is primarily a contents-and-packaging record. Include value information only when it is needed for the intended record or requested paperwork, and keep it consistent with the relevant documents.
Choosing a template and keeping it reliable
Choose a simple template if the shipment is small and the recipient needs only a contents list. Choose a more detailed one when individual cartons need tracking, when products have SKUs, or when package-level weights and dimensions matter. A template with many fields is not automatically better: unused columns invite incomplete data, while too few columns can make verification difficult.
Before using a template repeatedly, make a clean master copy and save a separate workbook for each shipment. Give the file a useful name that includes a reference or date, and use version control sensibly if several people edit it. Decide who enters the original quantities and who checks the totals. For recurring work, test the template with a small sample shipment first and confirm that the printed or exported result matches the information people actually need.
Frequently Asked Questions
Is an Excel packing list the same as a shipping label?
A packing list describes the shipment’s contents and packaging; a shipping label identifies the parcel for delivery and routing. A list does not replace the label or any other documents the carrier requires.
What should a packing list include?
Common fields include sender and recipient details, a shipment reference, package numbers, item descriptions, quantities, and weights. Add dimensions, marks, or other information when the recipient or carrier needs it, and check requirements for the specific shipment.
How do I calculate total units in Excel?
Multiply cartons by units per carton. If cartons are in C2 and units per carton are in D2, enter =C2*D2 in E2. For 12 cartons of 24 units, the result is 288.
Can I use the same template for international shipping?
You can adapt it as a contents record, but do not assume a general template meets every international shipping or customs requirement. Confirm the required documents and details with the carrier, broker, or relevant professional.
Should I send the packing list as Excel or PDF?
Send Excel when the recipient needs to filter, edit, or reuse the data. Send a PDF when a fixed printable record is enough. Check with the recipient first, and review the exported file to make sure all columns and totals are legible.
Related
- Excel Keyboard Shortcuts Mouse Pad: Guide to Choosing
- Excel Keyboard Shortcut for Next Sheet: Ctrl+Page Down
- Excel Keyboard Shortcuts to Find the End of Your Data
Try it: the Date Difference Calculator: days, months, years and weekdays between two dates, with the DATEDIF formulas.
More in How-to basics
- Google Sheets: How to Ignore Errors SafelyTo make Google Sheets show a chosen value instead of a formula error, wrap the calculation in IFERROR;…
- How to Schedule an Email Invite in Outlook for LaterTo schedule a meeting invitation in Outlook, create a calendar event, set its date and time, add attendees,…
- Mail Merge in Word, Excel & Outlook: A Step-by-Step GuideTo mail merge in Word with an Excel list and Outlook, prepare a spreadsheet with one recipient per…
- Excel Next Sheet Shortcut for Windows, Mac and WebIn Excel for Microsoft 365 on Windows, press Ctrl+Page Down to move to the next worksheet in the…
- Excel Data Bars: What Percent Means and How to Set ItIn Excel for Microsoft 365 on Windows, a data bar’s Percent setting defines a minimum or maximum boundary…
- Excel Online: How to Insert, Format, and Manage TablesTo insert a table in Excel Online, select the range of cells containing your data, then choose Insert…
Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources
Spotted an error in this guide? Let us know.