Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Dynamics 365 Community / Forums / Customer experience | Sales, Customer Insights,... / How to show unhidden s...
Customer experience | Sales, Customer Insights,...
Suggested answer

How to show unhidden system fields in excel

(1) ShareShare
ReportReport
Posted on by CU21100958-1 4
Hi 
 
My requirement is when export to excel from mscrm then those three system fields(Do not modify) I need to show in excel from mscrmndata
  • Collins Limo Profile Picture
    Collins Limo 6 on at
    How to show unhidden system fields in excel
    Hello, 
    After exporting the file from CRM and opening it, I would simply go to format then select hide & unhide dropdown under visibility then choose unhide columns. 
    This would show cell A then you can drag the rest of the columns to the right to show both C and D. 
    Check the screenshot below. 
     
    I hope this helps.
     
    BR,
    Collins
  • Suggested answer
    Amit Katariya007 Profile Picture
    Amit Katariya007 8,525 Super User 2024 Season 1 on at
    How to show unhidden system fields in excel
    Are you talking about Column A, B , C in the excel which is hidden by default? Or some Entity fields ?
     
    If it is first one then it is standard CRM format which will make this fields as the hidden because it will be used by CRM during import. As it have information about the Each row.
     
    You can download and manually unhide, if you want to see.
     
    If it is entity fields then you will have to add those fields in the view and export. You can user Fetch XML XRMTool if you need more custom query...
     
    Thank you,
    Amit Katariya 
  • Suggested answer
    Muhammad.Affan Profile Picture
    Muhammad.Affan 4,449 on at
    How to show unhidden system fields in excel
    Hi There,
     
    You need to ensure that those fields are part of the view that you're using for the export.
     
    Refer this link to add columns (system fields) to your view:
     
    Thanks
    Affan
    If my suggested answer has helped, please mark it as verified.

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 Suggested Answers

Best practices for providing successful forum answers ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

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

#2
Martin Dráb Profile Picture

Martin Dráb 230,214 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans