Export UTF8 rows broken

-- HikaShop version -- : 2.6.1

Hello!

I attach you a CSV that is exported from our database.
We have 2 problems, that whatever we try, we unable to solve. We need help!

1.) When CSV is exported from admin's product list, and then if I open it in Excel without using Excel's "Import data from text" function, the rows are not broken, but the chars are not friendly (see attachment: csv_excel_utf8_01.jpg). If I use Excel's import data from text function, and load the CSV to the table while setting it is UTF8, the chars seems OK, but sometimes (not always) the rows are broken (see attachment: csv_excel_utf8_02.jpg). Not always, but in some cases. What can cause it? How should I solve that?

2.) When exporting, the product quantity field can be 0 (zero). But when I open it in Excel there's no zero in that case, just blank field. And if I forgot to change back it to 0 when it's blank, than when I'm importing the CSV to products, those products show as we have them unlimited on stock.

Help would be really appreciated!

Thank you Nicolas!

I've never heard about LibreOffice before, but it's really opening the file correctly.
Also the 0 quantity problem is solved.
Thanks again!

Dear Nicolas,
Is there any option - at least modification in the code - to stop exporting the categories in the first rows when making product export?
We do not need it, it's just confusing as we have to scroll every time more then a hundred lines in the CSV.

nicolas wrote: Hi,

Instead of doing an export via the "export" button, you can use an action "export CSV file" of a mass action via the menu System>Mass actions to generate a CSV without categories. You can even select only the columns you want in the CSV.