spreadsheets Hub

How Text Fields Help You Make Lists Of Things

If you've ever struggled to remember what you've stored in a closet, garage, or attic, a simple list can save you from searching through boxes just to find out what you own.

The Real Question

Maybe you've caught yourself wondering: How can I make an inventory list? How do I keep track of things I own? How can I update my list as things change?

But the real question is: Can I use a text field to make a list I can easily update?

Answer Sheets

Absolutely! Google Sheets Text Fields let you enter names, descriptions, or other words into individual cells. You can create a useful inventory with just one column, adding or changing items whenever you need to.

And here's what that looks like for me. In my Storage tab, I keep a simple list of things I have stored, including in my shed:

Shed
extension ladder
hose
gardening supplies
power saw
toolbox
1. Open a Google Sheets spreadsheet.

2. Enter a heading in cell A1.

3. Enter one stored item per cell, starting in A2.

4. To update an entry, select its cell and replace the text.

Now I have a list I can check before searching the shed, and I can add or change entries as my stored belongings change.

Put Your Lists To The Text

  • Artists, Makers, and Crafters. Keep a running list of tools and supplies.
  • Collectors. Record the individual pieces in a collection.
  • Freelancers. Maintain a list of current assignments.
  • Household Managers. List belongings stored in closets, garages, and sheds.
  • Online Sellers and Resellers. Maintain a list of products awaiting sale.
  • Teachers and Tutors. Keep an inventory of teaching materials.
  • Travelers. Create reusable packing lists.

← Back to the spreadsheets Hub