Text to Columns Exported CSV

-- HikaShop version -- : lastest
-- Joomla version -- : 3.3.1

Trying to properly set up my csv file for import. However, when I export what is currently in the store demo and open up the csv using excel is breaks up the entries into multiple columns, because the description has commas. I then cannot use the "Text to Columns" function to see the the structure.

Any work around?

Can you take another look please? MOST of the lines are fine, but several lines get broken up, at the product description, even if I use ";" as the only delimiter. Please see lines 57, 96, 98, 105, 113, or 197 in the attached file. I have tried Excel, Google Sheets, and Libre Office.

Hi,

I checked this csv file and it seems to be correct, the line 57 don't have any problem at the product description.
I'm using Excel.

Wow. I must be doing something wrong. I double click to open in Excel, then choose Text to Columns, then choose demlimited, then ONLY choose ";"

I still get the descriptions split. See attached screenshots below...struggling and frustrated over here.

Actually, started troubleshooting. I don't think it is an Excel issue. If you look at the raw CSV file, even before opening it up in Excel or Libre. Please look at the attached export CSV in a text editor (Notepad).

There are several lines, where the export has a hard return, causing parts of the entry to start a new line. It's not a delimiter issue, there is an actual line break.

In the screenshot (LibreOffice Import Settings.jpg), you can see the CSV settings in LibreOffice and the CSV has already has a new line under the entry for 1847 (1% Spandex).

Please look at lines AFTER 1847, 2136, 2139, 2161 as examples in the attached CSV for examples.

Does that make sense?

It is still getting truncated. I believe if you scroll right in your example (take.ms/alRV7), Column S (product_keywords) will show 1% Spandex under item # 1847. If you look at the attached picture or if you open the original CSV in notepad, you can see that there is a linebreak on item # 1847 that separates the line "91% Polyester, 8% Nylon, 1% Spandex", which is not allowing the entire line to be read properly.

Does that mean in your example (take.ms/alRV7), Column S (product_keywords) does not show 1% Spandex under item # 1847, but instead shows the whole description (91% Polyester, 8% Nylon, and 1% Spandex)? If it only shows 1% Spandex like mine, then it would seem that something is not importing properly, correct?

OK. I think I understand now. the row height wasn't high enough to see the rest of the description. Thanks.