In Microsoft Dynamics (and in other application) there is a feature to edit data in Excel, check the following link:
https://docs.microsoft.com/en-us/dynamics365/unified-operations/dev-itpro/office-integration/office-integration-edit-excel
After editing the data in Excel, changes will be sent to the application and data validations will be performed. How cool would that be if we could edit data in Excel for bulk changes and do not need to build imports/exports?