The best way to ensure your file will be imported properly is to use a tab-delimited format. this is because the data itself can contain commas, and when it does, it can confuse the column detection. Tab delimited format is the same as comma-separated, except that tabs are used instead of commas.
Here are some tips when using the CSV format to make sure your data will be imported without problems:
Try removing all commas from the data itself. this can be done by opening up the file in excel and doing a find-and-replace on all commas.
Make sure that all rows in your file have the same number of columns.
If you must keep the commas in your data, try saving it in tab-delimited format.
