Support of numerical data format in Google Sheets destination
Table of contents
1. General information
2. Our recommendations
1. General information
The notation of numerical data may vary for every separate locale (different country), where ',' and '.' could define both a decimal separator or grouping.
- For instance, `pt-BR` locale number notation looks like:
- 2.345.123,00 - 10.350 - 12,5
- `en-US` locale number notation looks like:
- 2,345,123.00 - 10,350 - 12.5
- notation that JavaScript (common for programming languages) understands is the following:
- 2345123.00 - 10350 - 12.5
2. Our recommendations
If you want to import numerical data, we recommend you provide it in a notation that is common for programming languages (e.g. 2345123.00, 10350, 12.5, etc.). When importing your data to Google Sheets, Coupler.io will convert it into the format corresponding to the locale, set for your Google spreadsheet. To check what locale is configured for your spreadsheet, please read this
guide.
Note: Coupler.io doesn't have access to the information about the locale in your data source (an app you import data from). Therefore, it expects you to use the common programming languages format consisting of pure digits or digits combined with a dot (float). If numerical data in your data source has different from the common programming languages format, then Coupler.io might not be able to import your data properly to Google Sheets.