These are three best practices that should be used when importing partner data in Excel format into existing Salesforce Date, Number, and Text fields. Standardizing all rows to match Salesforce data types will ensure that the data is compatible and consistent with the Salesforce fields. Deduplicating the data before importing into Salesforce will prevent creating duplicate records and violating unique constraints. Installing the Data Quality Analysis Dashboards from the AppExchange will help monitor and improve the quality of the imported data. Verified References: : https://help.salesforce.com/s/articleView?id=sf.importing.htm&type=5 :
https://help.salesforce.com/s/articleView?id=sf.data_quality_dashboard.htm&type=5