Using a form to populate a spreadsheet

Question

How can I create a form for employees to use to populate an inventory spreadsheet? I used to use access in Microsoft, but I’m not familiar with how to create a form in numbers.

Answer 1

Here’s an excellent example of how to use a Form to populate a Microsoft EXCEL Worksheet:-

https://www.excel-easy.com/vba/userform.html

Answer 2

Dear @Russell Terpenning,

I hope you’re having a good day.

Thank you for your question, I understand that you’re looking to create a simple way for employees to enter inventory data using a form, similar to how you used forms in Microsoft Access. I’m happy to guide you through a modern approach that works well in Microsoft 365.

Instead of trying to recreate an Access-style form inside a spreadsheet tool, the easiest and most effective approach today is Use Microsoft Forms as the data entry interface, and connect it to Excel automatically

This allows your employees to fill out a simple form, while all data is collected in a structured spreadsheet behind the scenes.

1. Create a form

Go to Microsoft Forms (forms.cloud.microsoft) then Click New Form

Add fields that match your inventory data, for example:

• Item name
• Quantity
• Location
• Date
• Notes
• ......

These will act like the fields you used in Access forms.

2. Connect the form to Excel

In Microsoft Forms, go to the Responses tab

Click Open in Excel

This will create an Excel file where:

each submission = one row

each question = one column

3. Share the form with employees

Click Collect responses > copy link (you also can send a QR code or send to your employee via outlook or teams) > Send the link to your employees

They only need to open the form and fill in data then click Submit

4. Use the Excel file as your inventory list

Your inventory spreadsheet is now automatically updated as people submit the form.

You can also:

• filter data
• create reports
• track stock changes

I hope this helps you get started easily. Please feel free to reply below if you have any update or further concern.   

Warm regards, 

---

If the answer is helpful, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".    

Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.   

Answer 3

Numbers is not covered in the context, but a similar workflow can be created with Microsoft tools by using either Excel or Microsoft Forms to populate a spreadsheet.

Two main options are available:

1. Use Microsoft Forms with Excel for the web (recommended for employees filling in inventory):
   1. Store the inventory workbook in OneDrive for work or school.
   2. Open the workbook in Excel for the web.
   3. Select Insert > Forms > New Form.
   4. A Microsoft Forms tab opens in the browser. Enter a title and (optionally) a description for the inventory form.
   5. Select Add new and add questions for each inventory field (for example, Item ID, Description, Quantity, Location). Choose appropriate types such as Text, Choice, Date, etc.
   6. Each response submitted through the form is automatically written into the linked Excel table, which becomes the inventory log employees are populating.
2. Use Excel itself as the data-entry form (for local or desktop scenarios):
   1. Design a worksheet as an inventory table (columns for Item, Quantity, Location, etc.).
   2. Show the Developer tab (on Mac: Excel > Preferences > View > In Ribbon, Show > Developer tab).
   3. On the Developer tab, insert controls such as buttons, check boxes, list boxes, or combo boxes into a dedicated “form” sheet.
   4. Use Format Control on each control to configure properties (for example, linked cells, fonts, alignment, colors).
   5. Protect the sheet (Tools > Protection > Protect Sheet) so employees can only use the form controls and not change the layout.
   6. Optionally test the form by filling it out as a user and confirming that values flow into the inventory table.

Both approaches let employees use a simple form interface while the underlying Excel table serves as the inventory spreadsheet.

---

References:

• Create a form with Microsoft Forms
• Create forms that users complete or print in Excel
• Top 10 reasons to use Access with Excel