)
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.”
Decimal separator mismatches occur when Salesforce exports ignore your Excel regional settings and default to US formatting, creating persistent formatting issues that require manual correction.
Here’s how to resolve these formatting conflicts at the source and get data that automatically aligns with your regional preferences.
Eliminate formatting conflicts with direct Salesforce connections using Coefficient
Coefficient resolves decimal separator mismatches by establishing direct API connections that respect your Excel regional preferences, unlike CSV exports that apply source system formatting.
How to make it work
Step 1. Set up a direct Salesforce connection.
Install Coefficient in Excel and authenticate with your Salesforce account. The connection automatically detects your regional settings and applies the correct decimal separators during data retrieval.
Step 2. Import your desired reports or create custom queries.
Select any Salesforce report or build custom queries from objects and fields. The import process automatically handles decimal separator formatting according to your Excel locale settings.
Step 3. Configure scheduled refreshes.
Set up automatic updates on your preferred schedule – hourly, daily, or weekly. Each refresh maintains proper formatting without requiring manual adjustments or export/import formatting corrections.
Get properly aligned formatting from the start
Direct connections eliminate the root cause of decimal separator mismatches and provide consistent formatting across all refresh cycles. Start using Coefficient to get Salesforce data that automatically matches your regional preferences.
