The problem
Salesforce report exports come out with Excel-style column headers ("Account Name", "Opportunity Name"), mixed-case picklist values, currency symbols on Amount, and dates in DD/MM/YYYY. Pasting that into a weekly Google Sheets dashboard breaks every formula that references uppercase Stage values or an ISO date.
What Mappd does
Mappd renames the headers to short, formula-friendly column names, uppercases the Stage picklist for consistent lookup, converts Close Date to ISO 8601 so Sheets date functions work, and strips currency symbols from Amount so SUM() returns a number. The result is a CSV that drops into your weekly Sheet without breaking anything.
Column transformations
How to use this recipe
1. Click "Load this recipe free" above — or watch the live demo first.
2. Export your Salesforce report as CSV from the report's Export action.
3. Drop it into Mappd. The mapping loads automatically — adjust if your report has extra columns.
4. Review the change summary, then paste the cleaned CSV into your weekly Sheet.