Customer experience | Sales, Customer Insights,...

How to show unhidden system fields in excel

(1) Share

Report

Posted on by CU21100958-1

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

I have the same question (0)

All responses (3)

Answers (0)

Suggested answer

Muhammad.Affan Moderator on at

Like (6)

Report
Copy link

Link copied!

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:

https://learn.microsoft.com/en-us/dynamics365/customerengagement/on-premises/customize/choose-and-configure-columns?view=op-9-1

Thanks

Affan

If my suggested answer has helped, please mark it as verified.

Was this reply helpful? Yes No
Suggested answer

Amit Katariya007 10,409 Moderator on at

Like (2)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No
Collins Limo 6 on at

Like (1)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No

Join the conversation

Community site session details

How to show unhidden system fields in excel

Helpful resources

Quick Links

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2025 Community Spotlights

Congratulations to the February Top 10 Community Leaders

Leaderboard > Customer experience | Sales, Customer Insights, CRM

Featured topics

Product updates

Community site session details

How to show unhidden system fields in excel

Helpful resources

Quick Links

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2025 Community Spotlights

Congratulations to the February Top 10 Community Leaders

Subscribe to this forum!

Select categories

Leaderboard > Customer experience | Sales, Customer Insights, CRM

Featured topics

Product updates