Skip to main content

Notifications

Announcements

No record found.

Microsoft Dynamics 365 | Integration, Dataverse...
Suggested answer

How to Export Dropdown Fields and Their Options from Dynamics 365 CRM to CSV?

(2) ShareShare
ReportReport
Posted on by 44
 
Hi everyone,
 
I’ve been trying to export dropdown fields (Option Sets or Choices) and their available options from Dynamics 365 CRM into a CSV, but I haven’t had any luck with the methods I’ve tried so far.
 
Here’s what I’ve tried:
  • Advanced Find: I was able to export records with selected dropdown values, but this doesn’t give me the full list of all available dropdown options.
  • XrmToolBox: I attempted to use XrmToolBox for this, but I’ve been facing login issues, and I’m not sure if I’m on the right track with this tool.
Has anyone successfully exported all dropdown options from CRM to a CSV file? If so, could you share the steps or any tools you’ve used that worked for this?
I’d really appreciate any guidance or alternative approaches to solve this!
Thanks in advance!
 
  • Suggested answer
    Sachin Jadhav Profile Picture
    Sachin Jadhav 131 on at
    How to Export Dropdown Fields and Their Options from Dynamics 365 CRM to CSV?
    Use the tool named MetadataBrowser in XRMToolBox. This will extract the metadata for all attributes from all entities and the optionset type fields will show the list of possible values.
     
     
    Or you can use WebAPI query like following example for Account entity
     

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

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Top 10 leaders for November!

Congratulations to our November super stars!

Tips for Writing Effective Verified Answers

Best practices for providing successful forum answers ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,431 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,503 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Product updates

Dynamics 365 release plans