function readOnly(count){ }
Starting November 20, the site will be set to read-only. On December 4, 2023,
forum discussions will move to the Trailblazer Community.
+ Start a Discussion
babibabi 

Tool to extract Data model into excel

Hi

 

   I am new to salesforce. We owned one org and we have 5 application in it. We have also a set of custom objects and relationships.

 

Is there any proper tool exist to extract the existing data model into an excel sheet.

 

Ex:- We have Existing Account object. We have created a set of custom objects that is having a look up into account object.

 

is there any tool exist in appexchange which helps us to extract the relationship that exist with account object to a excel sheet.

 

Any tool that helps us to extract an object properties to an excel or to a file.

 

Please help me out on this. Thanks 

Ashish_SFDCAshish_SFDC

Hi Babi, 

 

Dataloader is a good tool commanly used in Salesforce to extract data which is exported in a CSV format - we can open that file in EXCEL. 

 

Try the same and let us know if you have any further questions. 

 

See the links below for more info, 

 

http://wiki.developerforce.com/page/Data_Loader

 

https://help.salesforce.com/apex/HTViewHelpDoc?id=data_loader.htm&language=en_US

 

https://help.salesforce.com/apex/HTViewHelpDoc?id=exporting_data.htm&language=en_US

 

Regards,

Ashish

 

Ashish_SFDCAshish_SFDC

You can also see this video exlpaing with a demo, 

 

http://www.youtube.com/watch?v=_7WvNwSQ0yU

 

Regards,

Ashish

babibabi

Hi Ashish

 

   Thank you very much for your quick help. Data loader is a nice tool to extract data.

 

But i would like to extract the meta data rather than data.

Example:- Extract any object (custom/standard) meta data and all its properties and all its parent and child relationships to an excel just for document purpose.

 

it would be also better if i can extract a profile and all its settings just for documenting purpose 

 

is there any tool exist for this in appexchange to extract the meta data?

 

 

 

 

 

Ashish_SFDCAshish_SFDC

Hi Babi, 

 

You can use another tool called Force.com Metadata API which is also known as ANT, this works on command line and  you can export all the metadata or only profiles as per your requirement in an XML format. 

 

http://www.salesforce.com/us/developer/docs/api_meta/Content/meta_intro.htm

 

To know more about ANT, 

http://wiki.developerforce.com/page/An_Introduction_to_Force.com_Metadata

 

You may also view the youtube video for ANT, 

 

Deploying Salesforce.com Metadata with ANT
http://www.youtube.com/watch?v=f5UlWurQzHQ

 

Regards,

Ashish

Ashish_SFDCAshish_SFDC

Hi Babi, 

 

I also found this app over the app exchange which can extract metadata, 

https://appexchange.salesforce.com/listingDetail?listingId=a0N300000018leZEAQ

  

Regards,

Ashish

Santosh Kumar 81Santosh Kumar 81
Try this app out. I have been looking for this for a while now. Glad I found it.
https://archtive-app.herokuapp.com/#services
Best thing is: Its FREE!! (Atleast for now)
Santosh Kumar 81Santosh Kumar 81
Looks like you can also download metadata in workbook format. Each object representing one worksheet in the excel.
Just select the Objects and Click Initiate Workbook
Siddhu ReddySiddhu Reddy

Hello, 

I'm not able to download "Herokuapp". Can anyone please help me with that. 

Is there any app through which we can download meta data of objects into spreadsheet. 

Thank you 

p0p Adminp0p Admin
Hi,

We have a free app - Field Dumper - in the Appexchange that might be of interest - It will extract out your objects and fields into to a single Excel file - each object is presented as a separate Excel tab.  Api name, field types, size, help text, formula text and picklist values and more is extracted.   

https://appexchange.salesforce.com/listingDetail?listingId=a0N3A00000EJg2hUAD

Let me know if it helps anyone out - interested in all feedback.
Sri0214Sri0214
Hey, Field Dump is working as expected and is allowing to extract the MetaData information as desired. Any chance to include the Description field in the extract.
Thanks,
Sri