Importing formatted data into HTML field from Excel import

[Meghashree1]

Hi Team,

 I am trying to import data from excel to policy table. We have data for policy text as formatted data , example there are multiple bullet points and paragraphs. When this is imported to servicenow everything is clubbed. Can anyone let me know how can i import it in same format as Excel.

Any help is much appreciated!!

Thanks,

Megha

@Ashutosh Munot @Ankur Bawiskar 

[Ankur Bawiskar]

Hi,

What is the target field type and how is the field mapped?

Regards
ankur

[Meghashree1]

Hello @Ankur Bawiskar 

Thanks for repsponding..

Target field type is HTML  which is policy text on grc policies table and in import set also i tried having field type as string and HTML both, no luck.

Thanks,

Megha

[ANKITA_CHARAYA]

@Ankur Bawiskar  @Meghashree1 : 

Hi Megha and Ankur ,

i wanted to check how did you do it , and import policy text as well from excel tempalate, and performed this activity of uploading policy documents in the system

[Meghashree1]

Hi @ANKITA_CHARAYA ,

 I have achieved it with  GlideStringUtil.newLinesToBreaks(sourcevalue)  for formatting.

Thank you.

Meghashree