How to Export Multiple Salesforce Objects into Excel?

Export Multiple Objects in Salesforce

IDEA: For any Salesforce Admin or developer, there is a requirement to mass export salesforce objects (Custom or Standard) in XLS. It would be tedious job to copy and click each object one by one using Salesforce Standard process.

These type of work requests would take more effort and time, so one of the best option to overcome this situation is by using the this appexchange tool called Bulk Object Field Creator (BOFC).

Benefits of using BOFC to Export Salesforce Objects into Excel (XLS)

  • Multiple Objects can be extracted in single click in single xls sheet
  • Supports both Standard and Custom Objects
  • Object Details, Standard and Custom Field details are extracted for multiple objects
  • Easy, Simple, Clickable process to export objects.

Note:

To avail this feature, kindly make sure you have installed the latest version of the application. You can upgrade your package using either of two ways:

  1. In Salesforce, go to “BOFC Home > Settings > App Version > Click to Upgrade” — or —
  2. Refer the below button to quickly upgrade your package to the latest version and explore its complete benefits:

Stay up to date with the latest in BOFC - Latest features, offers, news, tips and more

Few Simple Steps to Export Multiple Salesforce Objects to Excel

1. Open the BOFC Home > Click “Bulk Export Fields” or “Export Object & Fields for Multiple Objects”

export-multiple-objects

2. It will open below screen for BOFC “Export Objects” screen

Export Objects screen

 

3. User can choose different actions on below image has many features (each number has its description as below):

  1. Select single or multiple objects from the drop down. For ex: Selected Objects: Asset, Case, Campaign, Case Test
  2. Select what needs to exported (for eg: standard fields, custom fields, etc)
  3. Select “Field Permissions” option to export field permission for all the standard or custom fields
  4. If Field Permission is selected, then it is mandatory to choose Profiles using “Select Profile(s) option
  5. System Fields are the salesforce controlled fields which cannot be exported using normal way. This is a unique feature available in this tool.
  6. Click “Click to Initiate Export” button to export xls file for all the selected objects with all the selected details. It will exports single xls (with multiple tabs, one tab for each object) for all the selected objects in Salesforce

Export Multiple Objects

4. On clicking the export buttons, it will display a small section on the page. This section show the status of your export for multiple objects. Wait for couple of seconds, until status is changed to “Completed

export for multiple objects

  • Status: Shows if process got completed or not
  • Total Object Selected: Shows no of object selected to export
  • Objects Processed: Shows no of object which are processed
  • Failure: Shows no of objects which got error out

5. Once status is “Completed“, your file is ready for export. This below image has some number highlighted in [].

  1. Download Complete Object Details: On clicking this link, it will download a xls file for all the selected objects. Each object is represented as a separate tab in xls. Each Tab will have complete detail of Object, Standard Fields, Custom Fields.
  2. Download only Custom Fields: On clicking this link, it will download a xls file for all the selected objects. Each object is represented as a separate tab in xls. Each Tab will have only Custom Fields. This is used when user needs to take export and insert same fields in some other orgs.

BOFC Application for Export Objects

Have a look at step by step detailed video to “Bulk Export Salesforce Objects in a Single xls Sheet

******************************************************************************

Have you started using BOFC yet? Thousands of BOFC users have been able to save time & boost productivity using our Salesforce Metadata app. Click here to install the latest version of BOFC application in your Salesforce instance & explore its complete benefits for you.

For any queries or suggestions, you can write your comment in the comment box or for further assistance contact us at https://www.bofc.io/#contact or mail us: support@bofcapp.io. Our BOFC Expert will help you get the best out of it.


Experience it for yourself

Bulk Object Field Creator (BOFC) is a must-have tool, designed specifically for Salesforce.com Administrators, that simplifies many of the tedious tasks of managing a complex Salesforce environment.

This tool is available on Appexchange and Click on below button to install the
latest version of BOFC

or learn more
Subscribe
Notify of
guest
0 Comments
Oldest
Newest Most Voted
Inline Feedbacks
View all comments

Announcement: Introducing our new product "KAiZEN - a digital signature solution to secure your digital e-signing experience". Discover Now

X