Verification Field to pre-populate the form fields

I would like to upload an Excel file with list of names and ID numbers so that when users access a field on a form I create and enter the ID number, their name and other identifiable information populates. How do I accomplish this?

You can make use of our SpreadSheet to Form widget. This works exactly like the requirement you mentioned.

It allows you to upload your spreadsheet to your form and use the values you have on the spreadsheet to pre-populate your form.

By using a unique code that is present on every row of your spreadsheet, you can access that specific row that matches the unique code.

The values are automatically populated on your form fields, as long as the spreadsheet column headings match your form field labels.

GUIDE: how-to-use-the-spreadsheet-to-form-widget