Keep Excel string formatting when loading into ServiceNow

[Maria20]

Hello SN Community,

I've been tasked to load in an Excel spreadsheet into the Demand ticket in ServiceNow.  All is working as expected except that the Business Case field (which has line breaks and such in the Excel file) is being loaded as a single line of text into the ticket.  This makes it difficult to read.  How can I keep the Excel string formatting when I load and transform the data?

See screenshot for example.

Any advice is greatly appreciated.

[Kieran Anson · Accepted solution]

An assumption would be that the excel file is raw data whilst the field you're wanting to put the information into is of type HTML. So you'd need to do a string replace in the transform map to replace line breaks and carriage returns with the appropriate html element

[Maria20]

Hello Kieran! 

This worked perfectly.  Thank you.

For those encountering the same problem, here's the Field Map script I used: