Enter messes up CSV/XLSX file

Hello!

We are trying to import a very large file. We exported it but when looking at it in CSV and XLSX it looks weird.

The exported file has double enters. Which makes the


ID,Description,Price,Quantity:

xx,Description 1,100,50
xx,Description 2,100,50
xx,Description 3,100,50
xx,Description 4
with enters,100,50


The Description 4 that had enter in it. Breaks the rows. And from then on the "with" are the new ID.

The file are all good when opening it with Numbers (Mac).

The file has 15000 rows so we would need an automatic solution. Anyone here know why this happens?

Hello! Thank you for your reply!

Sadly I can not since it is a clients file. I hope the below example and answer helps!


"Are you saying/implying that the first three just have a line feed character at the end but the fourth item has both a line feed and a carriage return. i.e. is the fourth item different to the other three?"

Some cells has a description without carriage return. But the ones that do - casuses problem.

The problem that happens is that the rows are skipped. And on the new row that are created continues from after the carriage return. Meaning: If we in a description add a carriage return. That will end that row, and continue a new row.

Row1: xx,Description 1,100,50
Row2: xx,Description 2,100,50
Row3: xx,Description 3,100,50
Row4: xx,Description 4 (here carrige return are happening)
Row5: with enters,100,50

But we want it to be like this:
Row1: xx,Description 1,100,50
Row2: xx,Description 2,100,50
Row3: xx,Description 3,100,50
Row4: xx,Description 4 with enters,100,50

I did my best, but it is not a real representation due to client info and that vast amount of data:

ExcelForum.xlsx

I hope this helps!