How to Use Microsoft Forms for Excel Data Entry on an iPad

Open Safari or your preferred browser on the iPad and navigate to https://forms.office.com, then log in with your Microsoft account.

Tap 'New Form' to start designing your data entry fields. Add the necessary questions (such as text, multiple choice, or date) that correspond to the data your field crews need to collect.

Navigate to the 'Responses' tab within your newly created form and click 'Open in Excel'. This creates a connected spreadsheet where all future submissions will be automatically saved.

Click the 'Collect responses' button to generate a shareable link. Distribute this link to your field crews so they can open the form and submit data easily from their iPads.

Sign in to Microsoft 365 on a web browser and open Excel for the web. Create a new blank workbook or open an existing one where you want the collected data to be stored.

Navigate to the 'Insert' tab on the ribbon and select 'Forms', then tap 'New Form'.

Microsoft Forms will open in a new browser tab. Design your form by adding the required questions for your field data entry.

Share the form link with your iPad users. Their submitted responses will instantly populate into a newly created worksheet within your original Excel file.