How to import excel data with leading zeros into a string field.

[djohnson1]

The excel cell values were converted to text and the cell type is set to text. On import ServiceNow truncates the leading zeros. Can someone please help me understand how to overcome this issue? The field is mapped to the Asset Tag field on alm_asset table.

Thanks, 

Derrick Johnson

[rlatorre · Accepted solution]

Change the field type on the import set table to a String. On initial import it would have been created as an Integer based on your statement.