Create / Import csv files
To Import/Export CSV from a spreadsheet, I recommend libreoffice or openoffice which are much more efficient than Excel to create or import csv files. Indeed, libreoffice or openoffice let the user choose the columns separator while opening a csv file, whereas Excel use the comma separator without any other choice.
1- Download libreoffice or openoffice, it's free !
2- Open your table in libreoffice calc or openoffice calc.
3- Select “save as” and Text CSV
To import a CSV file, open it with libreoffice or openoffice and select the columns separator in the dialog box.