)
Written by
Table of Contents
“Supermetrics is a Bitter Experience! We can pull data from nearly any tool, schedule updates, manipulate data in Sheets, and push data back into our systems.”
Updating Salesforce from Excel data often means accidentally overwriting valuable existing field values because you can’t see what’s already populated before the update happens.
Here’s how to preserve non-blank fields while still enriching your records with new Excel data through sophisticated conditional logic.
Preserve existing data during Excel imports using Coefficient
Coefficient excels at this by letting you import both your Excel data and current Salesforce records side-by-side. You can create preservation formulas that prioritize existing Salesforce data while only updating truly empty fields with your Excel information.
How to make it work
Step 1. Import both Salesforce and Excel data.
Pull in your current Salesforce records alongside your Excel data to see both datasets in one workspace. This gives you a complete view of what exists versus what you want to add.
Step 2. Create field preservation formulas.
Use formulas likeorto preserve non-blank Salesforce fields while updating empty ones with Excel data.
Step 3. Build conditional export columns.
Create calculated columns that contain your preservation logic results. You can set up different preservation rules for different fields, or use date-based logic to only update if Excel data is newer.
Step 4. Configure and execute the export.
Set up your export with field mapping that points to your calculated preservation columns. Use batch processing controls and preview the changes before pushing them to Salesforce.
Transform risky imports into safe updates
This approach gives you mathematical certainty that non-blank fields stay intact while still enriching your records with relevant Excel data. You get complete visibility and control over the preservation process. Start preserving your valuable Salesforce data today.
