If you want to find where a field value equals a list of many items, typing in each criterion would be very time-consuming.
For example, you might want to query your database where zip code is one of 100s of different zip codes.
You can paste from your list into the query criteria values. Select the operator contains one of the following in queries. (Or is in list for classic queries.) You can paste from Excel.
After you click Done you see the values listed within the criteria.