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

Looking up Salesforce Ids based on an arbitrary field

Updating Existing Records in Salesforce

Creating New Records in Salesforce

In version 3.2.3.6

You can now change your data starting cell directly from the Update, Insert, and Upsert dialog box:

Converting Leads

To mass-convert leads in your Salesforce.com instance, you’ll first need to pull them using a SOQL query. To do this, click on Get Data button, and run a query similar to the following (you’ll probably need to add some of … Continue Reading

In version 3.2.2.9

Another XL-Connector release with more exiting features! We’ve streamlined the data push operations reducing the number of clicks you need to make to get the job done. Now, if you click on the Update, Insert, or Upsert button in the … Continue Reading