Heading off to college can be an exciting but overwhelming experience. One of the first things on your to-do list is packing—there’s so much to remember! Clothes, dorm essentials, toiletries, study supplies, and maybe some kitchen items; it’s easy to forget something. With that, a packing list template using Google Sheets can be a really great help.
Why Use a Google Sheets Packing List Template for College?
A packing list can be a lifesaver, helping you keep track of everything you need to take. Using a Google Sheets template makes it even easier to stay organized because you can access it from anywhere, update it anytime, and even share it with others. Plus, the automatic sorting and categorizing functions of Google Sheets make it much better than a handwritten list.
Step 1: Start a New Spreadsheet
To get going, open Google Sheets. Once there, hit the “+ Blank” option to start a new sheet. This will be the foundation for your packing list. Then, give your new spreadsheet a name for easier documentation. You can use something like “College Packing List.”
Step 2: Set Up Tables
Think about the types of items you’ll be packing and group them into different categories and tables. A few common categories might include:
- Clothing
- Toiletries
- Bedding
- School Supplies
- Dorm Essentials
- Food & Drinks
List these categories, leaving a few rows between each to allow space for listing specific items. Add columns such as “✓,” “Items,” and “Qty ” for each table. These will be the headings for each table.
Step 3: Add Items to Each Category
Now that you have your categories, start listing individual items beneath each one. For example, under “Clothing,” you might list “socks,” “t-shirts,” “hoodies,” and “jeans.” Keep adding items until you feel your list is comprehensive. You can also add the quantity for each item.
Step 4: Include a Checkbox Column
Google Sheets has a handy checkbox feature that makes it easy to mark items off as you pack. To add checkboxes, click on the first empty cell next to your first item. Go to the “Insert” menu and select “Checkbox.” Drag the checkbox down for each item in that category. This will create a simple system for checking things off once they’re packed.
Step 5: Use Conditional Formatting for Checkboxes
To give a visual cue that you’re already done packing the item, use conditional formatting to strike through the item when the checkbox is checked. You must highlight the item column and go to Format > Conditional formatting.
Under Format cells if, choose Custom formula is and enter: =$A7=TRUE (replace A with the column of your checkboxes). Choose Strikethrough as the formatting style and hit Done. Repeat the process for the rest of the tables.
Sometimes, it’s useful to have a second pair of eyes on your list—whether it’s your parents, a friend, or a roommate. Google Sheets makes it easy to share your list. Click the “Share” button in the top-right corner. Enter the email addresses of the people you want to share with. Set their permissions (view-only, comment, or edit) and hit “Send.” Now, your list can be a team effort!
Get the Free College Packing List Template
Get a copy of the free College Packing List Template. I’ve already populated some cells as examples, but you can customize them as needed.
Final Thoughts
Packing for college is a big task, but don’t overthink it. Focus on the essentials, and remember that you can always pick up things you forget later. Prioritize what makes your space feel comfortable and functional. Your list is just a tool—it’s okay if everything isn’t perfect right away. Most importantly, enjoy the process and get ready for all the new experiences college brings!
Frequently Asked Questions
Can I automatically sort my packing list by items I’ve packed?
Yes! You can sort your list by whether an item has been packed or not. Highlight your item and checkbox columns, then go to “Data” > “Sort range.” Choose to sort by the “Packed” column (where your checkboxes are), and items that are checked will move to the top or bottom, depending on your preference.
Is there a formula to track how many items I’ve packed?
Yes, you can use the =COUNTIF formula. For example, if your checkboxes are in Column B (B2
), you can use =COUNTIF(B2:B20, TRUE) to count how many items are checked off. This formula will give you an ongoing total of packed items.
How do I use conditional formatting to highlight uncompleted items?
You can use conditional formatting to make unpacked items stand out. Select the range of your checkbox column, go to “Format” > “Conditional formatting,” and set a rule for cells that are not checked (FALSE) to change to a specific color, like red. This visual cue can help you quickly see what’s left to pac.
.
