+ Start a Discussion

Data loader: Text Area problem

Good day,


Is there a way to handle a text area field having a new line when using a data loader?


i did try other alternatives such as replacing the new line using the tab. but when loaded into the salesforce,

the value displayed in one line (which is not good to looked at)  instead of having a new line.


Any idea is appreciated.


Thanks in advance,





      As i think you have to manipulate manually for new line in a file before loading the data in Org for a text area field type.

      i do not think no other way for this.


     Did this answer your question? If not, let me know what didn't work, or if so, please mark it solved.  




I already did that. by using tab. and it successfully uploaded into the sf. but problem is value it the displays in the screen

instead of :

"street 1

 city 1



it returns "Street 1 city 1 aaaaa". which is not the original position it has.(im doing the export then update btw).





Rahul SharmaRahul Sharma

Hi Mj12,

Tab is also treated as white space, so use "Enter" key + "Alt" key to insert a new line in excelsheet.


Hi Rahul,


but if i still use that new line. it will just create another row that should be not.


i will have this graph in the data loader if i insist the new line:.



ID               |  Name                | Address 


ID123        | Name1                | #1234

aaaa st

bbbb city   |ID456                   |  Name2




so i cant insert the content bec. data is not placed correctly

Rahul SharmaRahul Sharma

I have completely lost with your problem.

Sorry, but can you explain what problem you are facing?