Issue

An email connector fails with the task type, poorly_formatted_file. The following error appears:

Too many entries: expected at most 1. A line in your CSV has more columns than expected.

Environment

Connector: Email

Resolution

Please check for any additional headers in the CSV file. If there is an additional header, skip the number of additional headers by following the steps below:

1. Visit the connector Setup tab.
2. Click Edit Connection details.
3. Click Show advanced options.
4. Define the Lines to Skip.

Cause

Some CSV-generating programs include additional header lines at the top of the file. They consist of a few lines that do not match the format of the rest of the rows in the file. These header rows cause undesired behavior in Fivetran because we attempt to parse them as if they were records in your CSV.