Export breaks lines after <p> handle

dorfke
Tourist
11 0 0

So, I just exported all my products, but when importing them into excel, it seems that the CSV file breaks lines after a <p> handle mening I don't get clear lines per product, but get sometime multiple lines for the same product with parts of the product fields in seperate lines. Anybody has any idea how to fix this?

 

dorfke_0-1619033457733.png

 

 

0 Likes
yori
Excursionist
19 1 2

What's happening when you convert the csv data to columns?

Do you find the "<p>...</p>" seperated in different cells?

0 Likes
dorfke
Tourist
11 0 0

Correct, they go to a seperare line / cell

In the screenshot you see it at line 7 en 8 (line 8 continues where it was broken from line 7. 

0 Likes
yori
Excursionist
19 1 2

Try to convert the data to cells

yori_1-1619084385564.png

 

yori_0-1619084358501.png

 

0 Likes
dorfke
Tourist
11 0 0

That's after I converted them to cells. But it goes already wrong in the CSV file, there I can see that there are two lines in te CSV for one product as i makes a new line after the </p> handle

0 Likes
yori
Excursionist
19 1 2

I can see it's normal because it's still seperated by a comma. The rows doesn't matter. The website imports a csv file and looks at the data between the comma's. 

dorfke
Tourist
11 0 0

Thanks, didn’t know that. That being said it’s still an issue as it complicates mass changes to my products which I want to do in excel. Still looking for a way to solve this

0 Likes
yori
Excursionist
19 1 2

I'm using it all the time, it's easy to break blocks of text in seperate paragraphs or new lines

yori_0-1619093253548.png

In your case I would use the replace function in excel

yori_1-1619093334736.png


Do this for <p> and </p> 



0 Likes