Import Currency fields from Excel loads the wrong numbers

shimongabai
ServiceNow Employee
ServiceNow Employee

When importing an excel file with a column of type "Currency", some of the records get the wrong value for the field.

For example, if the value "14295374.53" in the excel file becomes 1.43 in the table.

1 ACCEPTED SOLUTION

shimongabai
ServiceNow Employee
ServiceNow Employee

Currency fields are imported as decimal which can cause large Currency values to get corrupted as you can see in your example.


To resolve this issue you can simply perform one of these two actions:


  1. Change the column type in Excel spread sheet from Currency to Number
  2. Go to the loaded table and set the field from Decimal to String 40


#2 is the better way, as you will only need to do this once and not worry about changing future files


View solution in original post

1 REPLY 1

shimongabai
ServiceNow Employee
ServiceNow Employee

Currency fields are imported as decimal which can cause large Currency values to get corrupted as you can see in your example.


To resolve this issue you can simply perform one of these two actions:


  1. Change the column type in Excel spread sheet from Currency to Number
  2. Go to the loaded table and set the field from Decimal to String 40


#2 is the better way, as you will only need to do this once and not worry about changing future files