Dynamics 365 Sales

This request is related to Dataverse Excel import behavior and is not specific to Dynamics 365 Sales.

When importing Excel data into Dataverse, values entered as numbers in Excel may be interpreted as numeric values during the import process, even when the destination column type is set to Single Line of Text.

As a result, thousand separators (commas) may be automatically applied (for example, "40561041" becomes "40,561,041"), which alters the original value.

This behavior creates operational challenges, especially in the following scenarios:

- Preparing large datasets manually in Excel

- Using the data for search or indexing purposes (e.g., Copilot Studio), where preserving the exact input value is required

Currently, the available workarounds include:

- Setting the Excel cells to Text format before entering data

or

- Manually adding an apostrophe (') before each value

However, these approaches require additional manual effort and are not practical when handling large volumes of data.

■ Request

We request the ability to preserve the original values exactly as entered in Excel when importing into Dataverse, without applying numeric formatting such as thousand separators (commas). 

Ideally, this should be provided as an option or configurable setting during the import process.