Importing CSV shows the error "data contains Y columns, expected Z"Issue When importing a CSV file (with delimiter or with tab as a delimiter), the import processor stopped with an error "data contains 1 columns, expected 4"CauseThe issue is with the Headers in the CSV file and the character encoding.The Character Encoding of the file is UTF-16 with BOM (byte order marking).If you add the properties in the data source as charset=utf-16 it will be successfully loaded but it will load with some extra columns with the special characters.When I open the file in the MAC viewer, I can see that the CSV first line starts with "ÿþ". The ÿþ character is known as the byte order marking (BOM) character and is commonly found as the first line of a CSV file. ÿþ can not be seen when the CSV is opened with Notepad or Excel for that an Editor is required that can display the BOM (Byte Order Mark).If you would like to continue, this will create a column name with a special character like below when you load with the property charset=utf-16. Resolution- Review how the CSV file is getting created and why it started prepending the BOM character ÿþ to the beginning of the file. - Save the file with the encoding utf-8 or utf-16 and import the file for the expected results - Once the data source CSV file no longer includes a BOM character then you will see the expected results.