This thing worked for me.
For all the values which have more than 2 decimals, shorten them to 2 decimals in the csv file with round up wherever applicable. It then got imported fine.
