Problem summary

Funnel cannot import one or more Google Sheets cells. The cell values do not match the field types in the data source configuration.

Error message or symptoms

You may see one of these errors:

Failed to parse cells
Type conversion error. Could not convert cell value to a number.
Cell error, followed by a Google Sheets formula error such as #DIV/0 or #N/A
An error says that Funnel failed to parse a Google Sheets datetime as a date

The error summary identifies the affected columns. It also shows examples of cells that Funnel could not import.

When does this occur

A field is configured as a number but its column contains text such as - or N/A.
A cell contains a Google Sheets formula error.
A field is configured as a date but Google Sheets does not recognize the cell as a date and the value is not in YYYY-MM-DD format.
A cell value does not match the field type selected in Funnel.

Root cause

Funnel must convert each cell value to the field type configured for its column. This conversion is called parsing. Funnel shows a parsing error when it cannot convert a value.

Solution

Use the error details to find the affected column. Then follow the instructions for the error that you see.

Failed to parse cells or type conversion errors

Review the example cells in the error summary.
Correct values that do not match the configured field type. For example, remove - or N/A from a number column. You can also replace the text with a numeric value.
Retry the import.

Cell formula errors

Find cells containing errors such as #DIV/0 or #N/A.
Correct the formulas. You can also use the Google Sheets IFERROR function to return a valid value.
Retry the import.

Date parsing errors

Format the affected cells as dates in Google Sheets. You can also use plain-text values in YYYY-MM-DD format.
Confirm that the field is configured with the Date unit in Funnel.
Retry the import.

Cell parsing errors in Google Sheets