CSV Import Issue.

HI All,

I am encountering some issue, which I am sure some of you can help with.

I created the csv file from excel sheet. Now I have created a copy of that excel sheet in a new sheet, and I am trying to load that saved csv in the new sheet. But when I do that I see some cells formatting mismatch (can be seen in attached picture) though I clicked on preserve cell formatting at the time of import. How can that be fixed?

Will appreciate any help.

Sal

ask.png
Almir's picture

It could be due to manual line break within a cell

I am not sure, but that could have been caused by manual line break within a cell. Such manual line break could be interpreted as a new record (new row) by Excel.
Try removing manual page breaks and replace them by a space. Then, re-create .csv file and import it again.