)
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.”
Changing decimal separators from dots to commas in Excel exports can be tricky, especially when working with Salesforce data that defaults to US formatting regardless of your regional preferences.
While you can adjust Windows regional settings for general Excel use, there’s a more reliable approach for Salesforce data that eliminates formatting headaches entirely.
Import Salesforce data with automatic decimal formatting using Coefficient
Instead of wrestling with export settings that often ignore your preferences, Coefficient connects directly to Salesforce and automatically applies your regional decimal separator settings during import. This means your data arrives with commas as decimal separators without any manual adjustments.
How to make it work
Step 1. Install Coefficient and connect to Salesforce.
Add Coefficient to Excel from the Microsoft AppSource. Once installed, authenticate your Salesforce account through the Coefficient sidebar. The connection respects your Excel regional settings automatically.
Step 2. Import your Salesforce report or data.
Choose “Import from Salesforce” and select either an existing report or build a custom query from Salesforce objects. All numeric fields will automatically use comma decimal separators based on your Excel locale.
Step 3. Set up automatic refreshes.
Schedule your import to refresh hourly, daily, or weekly. Each refresh maintains the proper decimal formatting without requiring manual corrections or export setting adjustments.
Skip the export formatting hassle
This approach eliminates the need to modify system settings or fix formatting after each export. Try Coefficient to get properly formatted Salesforce data that matches your regional preferences from the start.
