Skip to main content

Inflated monetary values in Google Sheets

Correct monetary values that Funnel imports at 10 or 100 times the expected amount.

Problem summary

Monetary values that you import from Google Sheets can be 10 or 100 times larger than expected.

Error message or symptoms

A value such as 123,00 in Google Sheets appears as 12300.00 in Funnel.

When does this occur

  • A monetary column uses a comma as its decimal separator.

  • Funnel imports the column as a monetary field.

Root cause

Funnel does not read the comma in the cell value as a decimal separator. As a result, Funnel imports a larger number.

Solution

  1. Change each monetary value to use a dot as the decimal separator.

  2. Use 123.00, not 123,00.

  3. Retry the import.

  4. Confirm that the monetary values are correct in Funnel.

Did this answer your question?