Updated November 2026

A packing list template in Excel lets you build one reusable checklist, then copy it for every trip. In this guide you will set up categories, add checkboxes, and create a layout you can reuse for weekend trips and longer journeys. The whole process takes about 20 minutes the first time.

Why Build a Packing List Template in Excel

A saved spreadsheet beats a fresh list every time you travel. You start with the items you already know you need, then delete or add based on the destination, weather and trip length. If you have already read our Travel Packing Check List: A Step-by-Step Guide Before Any Trip, you have the categories you need. Excel handles the layout so you can focus on what goes in the bag.

Shopping for one? See our guide: Packing List for Europe Summer Male: 4 Best Picks for Men (2026).

Set Up the Sheet Structure

Open a blank workbook and build the layout before you type any items. This keeps the template clean and easy to copy.

  1. In row 1, type the trip details: destination, dates and trip length in days.
  2. In row 3, add four column headers: Category, Item, Qty and Packed.
  3. Set column A to about 18 characters wide, column B to about 35, and columns C and D to about 10.
  4. Select column D and insert checkboxes from the Developer tab, or use a Yes/No drop-down under Data Validation.
  5. Freeze row 3 so the headers stay visible as you scroll.

Fill In Categories and Items

Group items by category, not alphabetically. Grouping mirrors how you actually pack and makes it faster to check things off. A standard set of categories looks like this:

  • Documents and money
  • Clothing (by day or by outfit type)
  • Toiletries and medication
  • Electronics and chargers
  • Carry-on essentials

For a clothing category, list the count per trip length, such as “underwear, 1 per day plus 2 spare.” Use the Qty column to enter these numbers so you can update them later with a formula. For a complete example of how these categories fit together, see Ultimate Packing List for Europe: Layers, Documents and Carry-On Essentials.

Add Formulas and Trip Tabs

Once the items are in place, a few simple formulas save time:

  • Progress count: in a cell near the top, use =COUNTIF(D4:D60,”Yes”) to count packed items, then divide by =COUNTA(B4:B60) for a completion total.
  • Quantity totals: use =SUM(C4:C60) to see how many items you are carrying.
  • Reusable trips: right-click the sheet tab, choose Move or Copy, and create a copy for each new trip. Rename it with the destination.

Keep one master tab with your core list, then duplicate it. Changes to the master do not affect old trip tabs.

Tailor the Template to Your Trip Type

For a beach trip, add rows for sun protection and water shoes. For a cold-weather trip, add rows for layers and gloves. The layout stays the same, only the items change. If you travel with a group, add a column for the traveler’s name so one workbook covers everyone. Our Packing List for a Beach Vacation: What to Bring and What to Skip shows a useful set of items to start from.

Common Mistakes to Avoid

  • Leaving the Packed column as plain text, which makes counting unreliable. Use checkboxes or a drop-down.
  • Making one giant tab with every past trip. Start a new copy for each trip instead.
  • Forgetting to save a clean master copy before you fill in a trip-specific version.
  • Skipping the trip-length field, which makes quantity planning guesswork.
  • Typing item names inconsistently, which breaks sorting and filtering later.

A few items make the printed version easier to use on the road:

  • A laminated card or dry-erase sleeve works well if you print the packing sheet and check items off by hand. View on Amazon
  • A small clipboard keeps the printed list flat while you pack a suitcase on a bed. View on Amazon
  • A set of packing cubes keeps the categories in your template physically separate in the bag. View on Amazon

FAQ

Do I need Excel to make a packing list template?

No. Google Sheets works the same way for most of these steps, and checkboxes and formulas are available in both. The steps above apply to either program.

How do I make a checkbox in Excel?

Turn on the Developer tab in Excel options, then choose Insert and select the checkbox control. If you do not want to enable Developer, a Yes/No drop-down under Data Validation works just as well.

Can I share one packing list template with my family?

Yes. Save the file to a shared drive or cloud folder, then add a traveler column so each person can track their own items. Confirm the sharing settings before you travel so everyone can edit.

Conclusion

A packing list template in Excel takes one setup session and saves time on every trip after that. Build the master tab once, duplicate it for each journey, and adjust the items for the weather and activities. Review it after each trip so the next list is even more accurate.

Colin Foster

About Colin Foster

Colin Foster is part of our editorial team and reviews and edits our travel essentials & packing lists guides, checking product details against manufacturer specifications and owner feedback.