Error: Line 1: Number of Fields in This Data Row (XX) Does Not Match Number of Fields in the Profile (YY)

Solution ID: 291432
Product: ImportOmatic
Published: 12/01/13
Description: This solution describes how to resolve the Error: Line 1: Number of fields in this data row (XX) does not match number of fields in the profile (YY). 
Environment: All
Versions: All

Answer: 

This error occurs when the number of fields in the data file and the profile do not line up. Open both the data file and profile and examine each one and make adjustments as needed.

If both the data file and the profile line up, this may be an error from excel.

If the error indicates that the profile has more fields than the data file

Excel will sometimes not see the last column in the data file if there isn't data in each row. To resolve this error, please see this solution.

If the error indicates that the data file has more fields than the profile

There may be ghost columns in the spreadsheet. To resolve the error, lasso the data in the data file. Don't copy the entire row or column, just the cells that have data.

Paste into a new worksheet and import this new data file.

Feedback and Knowledge Base