Error 'Empty Column is found' in Data Loader

To resolve this error you will need to ensure that any empty columns are removed from your .csv file.

Note: This error does not mean that you can't leverage blank columns to clear out existing field values on record. It only occurs when an entire column, including its header, is blank. It is still possible to upload blank values into records fields via the "Insert null values" setting in Data Loader, but the column must contain a header. See Configure Data Loader for more details on Data Loader settings.

1. Scroll through you file's columns in Excel and ensure that each one has a header. It is also best practice to remove any extraneous columns that may not have any data or are irrelevant for the import you're performing.
2. Check for hidden columns in Excel and unhide all the columns to delete any empty columns. See Show or hide columns and rows for more details.
3. Check to ensure that no data is unexpectedly contained in any column/cells to the right of your actual data. You can do so by clicking the spreadsheet header of the first blank column to the right of your data. For example if your data fills the first 5 columns, click the letter F at the top of the 6th column. Scroll all the way to the last column in your file. Hold Shift and click the spreadsheet header of the right most column in your sheet to highlight all of them. Right click anywhere in the highlighted space and select Delete to remove any unexpected data that may be contained to the right of your actual data in the file.

Once you've confirmed that no entirely empty columns exist and all unnecessary and extraneous columns/data have been removed re-save the file and try loading the CSV again via the Data Loader.

If there are no empty columns this error should not occur again.