Efficient Way of Entering Expiry Dates for Multiple Items

Hi, I need to update the expiry dates for over a 100 items. However, I can't seem to export and import the file when updating using the lot number inquiry function. Is there a more efficient way of updating the expiry dates please?