Error: Too Many Entries: Expected at Most 1

Issue

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

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

Environment

Connector: Email

Resolution

Check for any additional headers in the CSV file. If there are any additional headers, skip the number of additional headers by following the steps below:

1. On the Fivetran dashboard, go to the connector's Setup tab.
2. Click Edit Connection Details.
3. Set the Enable Advanced Options toggle to ON.
4. Define the Skip Header Lines option.

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.