How to Import Custom Objects Data from Salesforce into Excel

using Coefficient excel Add-in (500k+ users)

Learn how to seamlessly import Salesforce Custom Objects data into Excel using Coefficient. This step-by-step guide shows you how to create live, auto-updating reports without manual exports.

salesforce to google sheets connector

“Supermetrics is a Bitter Experience! We can pull data from nearly any tool, schedule updates, manipulate data in Sheets, and push data back into our systems.”

5 star rating coeff g2 badge

Salesforce Custom Objects contain vital business data unique to your organization. Getting this data into Excel enables deeper analysis, custom reporting, and integration with other business metrics.

This guide shows you how to import Custom Objects data from Salesforce to Excel using Coefficient, eliminating manual exports and ensuring your data stays current.

TLDR

  • Step 1:

    Install Coefficient from the Office Add-ins store

  • Step 2:

    Connect your Salesforce account to Coefficient

  • Step 3:

    Select Import from Objects and choose your Custom Object

  • Step 4:

    Configure fields, filters, and import your data

  • Step 5:

    Set up auto-refresh to keep data updated automatically

Step-by-Step Guide to Importing Salesforce Custom Objects into Excel

Step 1: Install Coefficient and Connect to Salesforce

  1. Open Excel and navigate to the Insert tab
  2. Click on “Get Add-ins” in the ribbon
  3. Search for “Coefficient” in the Office Add-ins store
  4. Click “Add” to install Coefficient
  5. Once installed, click on the Coefficient icon in your Excel ribbon
  6. In the Coefficient sidebar, select “Import Data”
  7. Choose “Salesforce” from the list of available connectors
  8. Log in with your Salesforce credentials when prompted
Coefficient sidebar menu with import, export, automations, and AI
    Sheet Assistant options.

Step 2: Import Custom Objects Data

  1. In the Coefficient sidebar, select “Import from Objects”
  2. Browse through the list of available objects or use the search bar to find your Custom Object
  3. Select the Custom Object you want to import
  4. Choose the specific fields you want to include in your import
  5. Apply any filters to narrow down the data (optional)
  6. Click “Import” to bring the data into your Excel spreadsheet
Salesforce import options including existing reports, object &
    fields, custom SOQL query, and pre-built dashboards.

Step 3: Set Up Auto-Refresh (Optional)

  1. With your data imported, click on the “Schedule Refresh” button in the Coefficient sidebar
  2. Choose your preferred refresh frequency (hourly, daily, weekly)
  3. Set specific times for the refresh to occur
  4. Click “Save” to activate the auto-refresh schedule
Auto-refresh options for imported data with daily, hourly,
    and weekly scheduling.

Now your Salesforce Custom Objects data will automatically update in Excel according to your schedule, ensuring you always have the most current information for analysis and reporting.

Available Salesforce Reports and Objects

Salesforce offers a wide range of standard reports and objects, in addition to your custom objects. Here’s what you can import using Coefficient:

Reports

  • Opportunity Pipeline
  • Leads by Source
  • Leads by Owner
  • Converted Leads
  • Open Leads
  • Leads with No Activities
  • Recently Created Leads
  • Recently Modified Leads
  • Account History
  • Contact History
  • Opportunities by Owner
  • Opportunities by Stage
+8 more

Objects

  • Account
  • Campaign
  • Campaign Member
  • Contact
  • Event
  • Lead
  • Opportunity
  • Opportunity Snapshot
  • Task
  • User
  • Custom Objects

Conclusion

By following this guide, you can easily import your Salesforce Custom Objects data into Excel using Coefficient. This integration eliminates manual exports, ensures data accuracy, and saves valuable time through automated refreshes. Start analyzing your custom Salesforce data in Excel today!

Frequently Asked Questions

  • How to get Custom Objects from Salesforce?

    down-chevron

    To get Custom Objects from Salesforce, you can use the Salesforce Data Export service, which allows weekly or monthly exports. You can also use the Data Loader tool for more frequent exports, or the Salesforce API for programmatic access.For a simpler solution, Coefficient connects directly to Salesforce and lets you import Custom Objects data into Excel with just a few clicks, plus it keeps your data automatically updated.

  • How do I get a list of Custom Objects in Salesforce?

    down-chevron

    In Salesforce, navigate to Setup > Object Manager to view all objects. Custom Objects are marked with a custom icon and typically end with “__c” in their API names.With Coefficient, you can see all available Custom Objects directly in the import interface when connecting to Salesforce, making it easy to find and select the objects you need without switching between platforms.

  • How do I import Custom Objects from Excel to Salesforce?

    down-chevron

    To import Custom Objects from Excel to Salesforce, you typically need to save your Excel file as a CSV, then use Salesforce Data Import Wizard or Data Loader to upload it. This requires mapping fields and following specific formatting requirements.Coefficient simplifies this process with its two-way sync feature, allowing you to push Excel data back to Salesforce Custom Objects with proper field mapping and validation built-in.

  • How do I update Custom Objects from Excel to Salesforce?

    down-chevron

    Updating Custom Objects from Excel to Salesforce traditionally requires exporting data as CSV, using Data Loader with the “update” function, and ensuring your file includes record IDs for matching.Coefficient streamlines this process with its “Export to Salesforce” feature, which lets you update Custom Objects directly from Excel. Simply select the object, map your columns, and Coefficient handles the rest.

  • How do I download Custom Objects data from Salesforce?

    down-chevron

    To download Custom Objects data from Salesforce, you can run a report filtered for that object and export to Excel/CSV, use Data Loader for larger datasets, or create a custom report type.Coefficient provides a more efficient solution by directly importing Custom Objects data into Excel with all fields and relationships intact, plus it maintains a live connection that can refresh automatically.

500,000+ happy users
Get Started Now
Connect any system to Google Sheets in just seconds.
Get Started

Trusted By Over 50,000 Companies