Home » Forums » Open Source Learning Center » Question and Answer

CSV Import Issue.

Submitted by saddy on 30 August, 2013 - 01:38

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
‹ Track changes from external data from web Macro to copy a value and not the summation formula ›
»
Almir's picture

It could be due to manual line break within a cell

Submitted by Almir on 6 September, 2013 - 15:13.

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.

»