Yes, you can create a printable packing checklist in Excel, and it takes less than five minutes. This article explains how to build one, what to include, and how to avoid common mistakes.
Why Use Excel for a Packing Checklist
Many people reach for a notes app or a paper list when packing, but Excel offers distinct advantages. You can add columns for quantity, category, and status (packed, in suitcase, in carry-on). You can sort items by room or activity, and you can reuse the same template for every trip. Unlike a paper list, you can easily update it on your phone or print a fresh copy if you spill coffee on the original.
Excel also lets you create a checklist with checkboxes (using the Developer tab) or simply use a column with “Y” or “N”. For a printable version, you do not need any formulas—just a clean layout with borders and a clear font.
How to Build a Basic Packing Checklist in Excel
Open a new workbook and follow these steps:
- In row 1, create headers: Item, Category, Quantity, Packed.
- In the Packed column, use “Y” or leave blank. Or insert a checkbox: go to Developer > Insert > Checkbox (if you do not see Developer, right-click the ribbon and enable it).
- List items row by row, grouping by category (clothing, toiletries, electronics, documents).
- Select all cells with data, go to Home > Borders, and choose “All Borders” to make it print-friendly.
- Set print area: Page Layout > Print Area > Set Print Area.
- Adjust margins and orientation (portrait for short lists, landscape for long ones).
If you want checkboxes that print as empty squares, you can also type a square symbol (□) in the cell—that prints reliably without any special settings.
What to Include in a Packing Checklist
The content depends on your trip, but a general list covers these categories:
- Documents: passport, ID, boarding pass, travel insurance, hotel confirmation.
- Clothing: shirts, pants, underwear, socks, jacket, sleepwear, shoes.
- Toiletries: toothbrush, toothpaste, deodorant, shampoo, razor, medication.
- Electronics: phone charger, power bank, headphones, adapter.
- Miscellaneous: sunglasses, umbrella, reusable water bottle, snacks.
For a business trip, add a laptop, notepad, and business cards. For a beach vacation, add swimwear, sunscreen, and a hat. For a camping trip, add a flashlight, first-aid kit, and insect repellent. Always include any prescription medications in your carry-on, not in checked luggage.
How to Print It So It Looks Good
Printing from Excel can be frustrating if you do not set it up correctly. Common issues include columns spilling onto a second page, tiny fonts, and missing gridlines. To avoid these:
- Use Page Layout > Scale to Fit and set width to 1 page.
- Choose a simple font like Arial or Calibri, size 11 or 12.
- Turn on gridlines for printing: Page Layout > Sheet Options > Print > check Gridlines.
- Preview with Ctrl+P and adjust margins if needed.
If you want a more polished look, add a title row with a larger font and merge cells across the top. You can also use conditional formatting to highlight the “Packed” column when it says “Y”, but that is optional.
Common Problems and How to Fix Them
One frequent issue is that checkboxes from the Developer tab do not print as empty boxes—they print as checked or unchecked depending on their state. If you want a blank square on paper, use the □ symbol instead. Another problem is that the list is too long for one page. In that case, split it into two columns using the “Text to Columns” feature or simply print on two pages and tape them together.
Some users accidentally include hidden rows or columns that cause blank spaces in the printout. To fix, select all cells, clear formatting, and set the print area again. Also, if the list is too wide, reduce the column width for “Quantity” to 5 characters and “Packed” to 3 characters.
Excel vs. Other Methods
Excel is not the only option. A paper list is simple but cannot be edited easily. A notes app is convenient but not as structured. A dedicated packing app may offer pre-made lists but often requires an account or shows ads. Excel gives you full control and works offline, and you can save it as a PDF to print from any device.
One advantage of Excel is that you can create a template once and reuse it indefinitely. You can also color-code categories—for example, blue for clothing, green for toiletries—which makes it easier to scan.
Costs and Availability
Excel is part of Microsoft 365, which requires a subscription (typically around $10 per month for personal use). However, you can also use free alternatives like Google Sheets or LibreOffice Calc, which have similar printing options. If you only need a basic checklist, you can even print a free template from a website and skip Excel entirely.
If you do not want to pay for Excel, Google Sheets is a good substitute. It has the same printing capabilities and you can access it from any device. The steps for creating a checklist are nearly identical.
Safety and Accuracy Notes
When packing, always double-check that you have essential medications and documents. For international travel, make sure your passport is valid for at least six months beyond your return date—many countries require this. Keep a photocopy or digital scan of your passport in a separate bag in case the original is lost or stolen.
If you are packing perishable items like food, be aware of customs restrictions. Some countries prohibit fresh fruit, meat, or dairy products. Check with the destination’s embassy or consulate before packing such items.
Frequently Asked Questions
Can I make a packing checklist in Excel without a subscription?
Yes, you can use the free web version of Excel (requires a Microsoft account) or use Google Sheets, which is completely free. Both allow you to create a printable checklist with the same features.
How do I add checkboxes in Excel?
Go to the Developer tab and click “Insert”, then choose the checkbox icon. If you do not see the Developer tab, right-click the ribbon and select “Customize Ribbon”, then check “Developer”. Alternatively, type the square symbol □ for a simple printable checkbox.
Why does my Excel printout cut off columns?
This usually happens because the print area is not set or the scale is not adjusted. Go to Page Layout > Scale to Fit and set Width to “1 page”. Then preview with Ctrl+P to see the result.
Can I share my packing checklist with someone else?
Yes, you can save the Excel file and send it via email or cloud storage. You can also export it as a PDF (File > Save As > PDF) so they can print it without needing Excel.
Is there a pre-made packing checklist template in Excel?
Yes, Microsoft offers a “Travel packing list” template in the Excel template gallery (File > New, search “packing list”). It is a good starting point, but you can also create your own as described above.
Packing Checklist Template
| Item | Category | Quantity | Packed (Y/N) |
|---|---|---|---|
Sample (fictional):
| Item | Category | Quantity | Packed (Y/N) |
|---|---|---|---|
| Passport | Documents | 1 | Y |
| T-shirts | Clothing | 5 | N |
| Toothbrush | Toiletries | 1 | N |