Thank you all for the good pointers. I ended up taking the data to my laptop and re exporting the account to CSV and then importing that file. This time it worked! Not sure what the issue was but seems good now.