Csv file import for products

[Genie]

My question is that whenever i am downloading the sample file for product import aa the values are in same column of the csv file. But i dont want that format. So is there any way that i can customise the format of the uploading csv file where there will be only one value in one column?

[Genie]

Need to do that. Please help.

[Iryna]

What spreadsheet program do you use to open the file? If data are messed and displayed incorrectly, you should pay attention to delimiters and choose the correct ones when opening the file. 

[Genie]

What spreadsheet program do you use to open the file? If data are messed and displayed incorrectly, you should pay attention to delimiters and choose the correct ones when opening the file. 

Hello Iryana

The file type is Microsoft Excell Coma Separeted value files amd i am using microsoft office to open this file.

But my question is that i want to import product with a csv file of format

 

 

but not in a format like

Edited February 27, 2015 by Genie (see edit history)

[Iryna]

Microsoft Excell has its peculiarities. You can change delimiters in several ways:

1. Open the file, select the column with data, click on DATA tab of the main menu, select "TEXT TO COLUMN" option and select separator, as it is shown in the screenshots

 

 

2. You can change regional settings (Start -> Control Panel -> Regional and Language Options ->Additional Settings)

3. Add an extra line to tell Excell what the separator is. 

[musicmaster]

Excel has the irritating habit often not to ask what separator it should use (OpenOffice Calc does this much better). You can force Excel to ask by renaming your .csv file into a .txt file. If you import that it will always ask.