When importing a CSV file, I always make sure that there are quotes around all of my values. It eliminates a lot of issues. Here is the difference.
Normal:
ID, Name
1, One
2, Two
3, Three
With Quotes:
ID, Name
"1", "One"
"2", "Two"
"3", "Three"
In order to accomplish this, we use an Excel macro.