Microsoft Dynamics CRM (Archived)

Exporting all fields of an entity to excel sheet

(0) Share

Report

Posted on by Prem27

370

Hi all,

I have a query, I wanted to know if i could export all fields of an entity to an excel sheet.

If there is a way out kindly suggest!!

Regards

Prem

*This post is locked for comments

I have the same question (0)

All responses (8)

Answers (2)

Verified answer

Community Member on at

Like (5)

Report

Use XrmToolbox's Metadata Document Generator.

xrmtoolbox.codeplex.com

Was this reply helpful? Yes No
Suggested answer

Ryan Maclean 3,070 on at

Like (1)

Report

Hi Prem,

I'm not sure what you need this for, but you could use a solution like the CRM Data Detective (crmdatadetective.codeplex.com) to list them all, then copy them across to an Excel sheet.

Ryan

Was this reply helpful? Yes No
Suggested answer

Nithya Gopinath 17,078 on at

Like (0)

Report

Hi Prem,

What is the need of having such an excel sheet? Already the Dynamics CRM SDK has an excel sheet called Entity Metadata.

Was this reply helpful? Yes No
Verified answer

Community Member on at

Like (2)

Report

Install the XRMToolbox kit on your machine. That tool is providing option to export the entity fields to excel .

Regards,

Dhandapani

Please mark the answer as verified, if it helps you

Was this reply helpful? Yes No
Prem27 370 on at

Like (0)

Report

Hi Nithya,

thanks for your response. while mapping my business requirements in CRM, i wanted to have a list of all the fields in the entity and then mark/color them as per their feasibility according to my requirements , which would give me a clear idea which one of them are useful and further i could present it as well.

Was this reply helpful? Yes No
Tim Dailey 440 on at

Like (0)

Report

Excellent, exactly what I needed and it put it all in one Excel, great tip!

Thank you!

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

Hi all,

I would be grateful if you could tell me which pluggin you used for exporting your entity datas with XrmToolBox ?

Regards.

FLorent.

Was this reply helpful? Yes No
John CRM Dev 5 on at

Like (0)

Report

Does anyone know if I can export opportunities from advanced find and include the account id they are linked to? I want to import accounts and opportunities into another system, but don't see how identify an account on an opportunity using the advance find export to excel.

Was this reply helpful? Yes No