Unable to Import CSV file error: Mandatory Field Missing for field "XXXX"

Use Notepad or any Notepad application.
Drag the csv file to Notepad and look for excess comma's
 
Example:
 
Notice:
After the fourth line it is all blank.
But if we check it using NotePad.

Notice:
I have series of comma's after the 3rd entry which is visible using notepad.