)
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.”
When Salesforce exports show dots instead of commas for decimals, it’s because the platform forces US number formatting regardless of your regional settings.
Here’s how to get properly formatted decimal separators that match your locale without manual corrections after each export.
Import Salesforce data with correct decimal formatting using Coefficient
Coefficient bypasses Salesforce’s problematic CSV export system by connecting directly through the API. This eliminates formatting conflicts and automatically applies your Excel regional settings during import.
How to make it work
Step 1. Connect Coefficient to your Salesforce account.
Install Coefficient from Excel’s add-ins store and authenticate with Salesforce. The connection automatically detects your Excel locale settings for proper decimal formatting.
Step 2. Import your desired report or create a custom query.
Select any existing Salesforce report or build custom queries from objects like Opportunities, Accounts, or Leads. All numeric fields will display with comma decimal separators automatically.
Step 3. Schedule automatic refreshes.
Set up hourly, daily, or weekly refreshes to keep your data current. Each refresh maintains consistent comma decimal formatting without requiring post-import corrections.
Get reliable decimal formatting every time
This approach eliminates the frustration of fixing decimal separators after each Salesforce export. Start using Coefficient to get properly formatted data that respects your regional preferences from the beginning.
