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 !

http://www.libreoffice.org/

http://www.openoffice.org

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.