SN System Properties Reference
Property reference

glide.import_excel.use_only_user_session_date_format

Converts Excel date and date/time values to the importing user's session date format in the import staging table. Enabled by default, it applies that format to all such values; when disabled, only explicitly typed Excel date/time cells use the session format, while other date values use the system format.

Default
true
Type
boolean
Application
Not stated

Key questions about this property

The answers below summarize the purpose, scope, default effect, and review scenarios for this property.

What does it do? When enabled, converts every Excel date or date/time value to the user's session date format in the import staging table; when disabled, non-explicit date cells use the system date format.
What area does it affect? Excel imports and staging tables
What does the default mean? The default value is "true", which means this behavior is enabled by default.
When should you review it? When Excel imports need consistent date formatting across user sessions or alignment with the system date format.

Property record

Facts stated in the ServiceNow documentation. No out of the box record has been read from an instance yet.

Property name glide.import_excel.use_only_user_session_date_format
Type boolean
Application Not stated
Default value true
Description If true, any Date or Date/Time value in an Excel spreadsheet is converted to a user session date format in the staging table upon Excel file import.If false, any Date/Time explicit cell type in Excel is imported into a staging table with the user session date format, and any date value that is not explicitly in a Date/Time cell type in Excel is imported into a staging table using the system date format.

Sources

Official references and nearby text excerpts where this property appears.

Brazil docs Available system properties ↗
Context preview Snippet 1
... message. This property should be enabled. • Type: true | false • Default value: ◦New/zbooted instances: true for starting with Istanbul ◦Upgraded instances: false • Location: System Property [sys_properties] table glide.import_excel.use_only_user_session_date_format © 2026 ServiceNow, Inc. All rights reserved. ServiceNow, the ServiceNow logo, Now, and other ServiceNow marks are trademarks and/or registered trademarks of ServiceNow, Inc., in the United States and/or other ...
Additional source link Another external reference for this property
Open reference

More in glide (other)

Other properties in the same namespace.

glide.imap.secure_port Specifies the communications port used when connecting to an IMAP server securely. glide.imap.tls Enables or disables starting the IMAP server in Transport Layer Security (TLS) mode. glide.impact.central_instance This property defines the endpoint for the Impact service, impacting how the system interacts with external su glide.impex.transformer.empty_value_nil This property controls the handling of empty string values during data transformations, allowing for either pr glide.import_set.preserve.leading.spaces This property controls whether leading spaces in Excel data cells are preserved or removed during the import p glide.import_set.target.stop_transform This property, when enabled, prevents the transformation process from processing source rows that match multip glide.import_set_insert_serialized_when_no_coalesce This property controls whether transformations of web service import sets without coalesce fields are executed glide.import_set_load_batch_size It determines the batch size for committing records during import set processing, impacting how data is loaded

All 489 properties in glide (other) →