Importing Data from Salesforce.com using SOQL (Salesforce Object Query Language)

XL-Connector 365 has a very powerful tool allowing you to pull ANY data from your Force.com database into Excel. To pull data from a Force.com database to Excel using a SOQL query, click the SOQL button in your XL-Connector ribbon: … Continue Reading

Installing XL-Connector 365

Content will be created after the add-in is published.

Placing XL-Connector Lightning component on any Lightning page

Placing the XL-Connector Templates Lightning component onto a Lightning page is as simple as a couple of clicks: Click on Edit Page on any Lightning Page: In the Lightning Page Editor, locate the XL-Connector Templates component on the left and … Continue Reading

Adding XL-Connector component to Salesforce Classic page layouts

You will need to make some adjustments after you install our managed package in order to be able to attach your XL-Connector templates to records in Salesforce Classic and dynamically populate the record Id in the template: Go to Setup … Continue Reading

Installing XL-Connector Managed Package

XL-Connector Templates managed package contains Salesforce Lightning and Classic components that you can put on any object page layout and that will make it possible to upload XL-Connector templates (XLSX files) to any record in Salesforce.com. The components look similar … Continue Reading

In version 3.2.5.4

Running all Flows in the entire workbook is now available. Click on Run All Flows button to start them. XL-Connector will go through every worksheet and if there’s a flow with active flow steps there – they will get run. … Continue Reading

Filling Gaps in your Data

Filling Gaps in your Data

One of the common requests we’ve been getting over the years is to provide an easy way to fill gaps in Excel data by pulling the missing values from the Salesforce.com database. Of course, you could run a query to … Continue Reading

In version 3.2.4.9

New Query Rows function is now available. This function will query Salesforce for each row of data filling in blank cells with values from Salesforce. You’ll need to map your columns before you can run this function: It will use … Continue Reading

In version 3.2.4.4

Autofit columns will now be applied automatically as you pull data from a Salesforce report or SOQL query. This will automatically adjust your columns width based on their contents. You can turn this off under Settings -> General: Ignore blank … Continue Reading