If you've ever experience this type of error on a Provider file, we understand how frustrating it can be. The failure message is declaring that there's a different number of lines than your file says it has and you look at your file in Excel and only see the right number of rows.
This type of error ultimately comes down to line breaks in your data that aren't easily visible. Passport requires any file is in the comma separated value (.csv ) format and it cannot process any time there is an "enter" or "line break" in your file. Viewing your file in a Text Editor shows a line break between 10-11 and now the file is no longer in the proper format that it can be read and uploaded into Passport.
This often originates from enters or line breaks in your data source which then translates onto the file. If you can identify the specific rows causing the issue, we recommend fixing directly in your data source so avoid this issue on your next upload.
If you are unable to do that, this article will outline a quick excel function that can help clean up your data.
Disclaimer - always reference Excel support articles for the most up-to-date information on their formulas. This is a method that the support team uncovered which can be helpful in these instances.
To identify the rows with multiple line breaks, begin by selecting all the data in the excel and clicking the bar between the rows to identify which rows have multiple lines of data in it. You should be able to visually see which rows have multiple lines of data when the rows expand.
You can either clean up the data right in the file, save and reupload.
You can also use the "Clean" function in excel (=CLEAN) which will remove any breaks in a cell. To use the "clean" function. Begin by creating a new column next to the column you wish to clean of line breaks.
In the first cell, type =Clean(cellnumber) and press enter. Cell number must be the cell you wish to clean. You can also click directly on the cell.By pressing enter, you'll see the line breaks have been removed.
Simply copy and drag that formula down your file to clean all rows.
Finally, you'll want to copy the data out of the new column into the existing column. When copying, right click to select "Paste Special" > "Values" to copy all the newly cleaned data and delete the new column to ensure the file remains in the provider file format.