web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Customer experience | Sales, Customer Insights,... / Import of .csv with Mu...
Customer experience | Sales, Customer Insights,...
Answered

Import of .csv with Multi-Select option set data created values in D365

(0) ShareShare
ReportReport
Posted on by William Bradley 175

I recently imported data from .csv to an environment. Two of the fields were multi-select, so I imported as is shown below in the following examples:


pastedimage1591895522207v1.png

I am noticing now that these fields have added values to the 2 Option Set in D365:

pastedimage1591895574010v2.png

pastedimage1591895613928v3.png

I do not need these values to show in the Option Set.  What is the fix for this?  I do not want to delete the values as obviously there is data that references them.  

Any assistance is helpful, thanks.  

I have the same question (0)
  • Verified answer
    Bipin D365 Profile Picture
    Bipin D365 28,985 Moderator on at

    Hi,

    The reason these values getting created in Multi select option field is when you import records and do the mapping of field, CRM will ask to you to either ignore optionset field values or create new whatever coming from source.

    Since you have not selected ignore option so by default system created this values.

    CQ8.PNG

    Now coming to your questions on how to resolve see issue. See below thread which will help you to fix your issue.

    community.dynamics.com/.../how-to-import-data-into-new-multi-select-option-set-field

    If found helpful, Please mark my answer verified.

  • William Bradley Profile Picture
    William Bradley 175 on at

    Thank you sir.  I was able to fix this data by taking the following steps:

    "Export to Excel" from All Contacts View as Dynamic Worksheet with only 2 columns (Service Line, Work Type)

    Remove " from all data in Worksheet (find and replace)

    Save Worksheet

    "Import  from Excel"

    Select File

    Ignore all other fields, Map 2 fields above

    MAKE SURE Service Lines and Work Types match from source to target

    Import

    Delete additional OS values in Prod

    Verify Data

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2026 Super Stars!

Meet the Microsoft Dynamics 365 Contact Center Champions

We are thrilled to have these Champions in our Community!

Congratulations to the April Top 10 Community Leaders

These are the community rock stars!

Leaderboard > Customer experience | Sales, Customer Insights, CRM

#1
Muhammad Shahzad Shafique Profile Picture

Muhammad Shahzad Sh... 69 Most Valuable Professional

#2
ManoVerse Profile Picture

ManoVerse 62 Super User 2026 Season 1

#3
11manish Profile Picture

11manish 43

Last 30 days Overall leaderboard

Featured topics

Hide selecting Contact for potential customer when creating quote

Product updates

Dynamics 365 release plans