Hi all,
I’m importing data from Excel into ServiceNow (Excel Data Source → Import Set / Transform Map), and I’m losing decimal precision during the import.
Example:
- In Excel, the actual value is 1.11
- But the cell is formatted to display 1 decimal place (so it shows 1.1)
- When I import into ServiceNow, the value I can access in the import set / transform (source.<field>) is 1.1 only — I can’t get 1.11
I’m not trying to get sys_id or reference values; this is purely about numeric precision.
Question
How can I make ServiceNow import the underlying numeric value from Excel (1.11) rather than the displayed/rounded value (1.1)?
Is there any best practice or setting (Excel formatting, data source options, field type, transform scripts, etc.) to preserve full decimal precision?
Thanks!
