Excel Sforce Connector
Mar 21, 2005Update: We have created a new discussion board to discuss this product:The Excel Connector Discussion. The AppExchange Data Loader is another tool that is helpful when doing similar tasks.
For those of you who haven’t discovered the Sforce Excel Connector built by Ron Hess, it’s a fantastic open source tool.
The connector allows you to import records from Excel directly into Salesforce.com. It also allows you to perform mass updates which can be very handy for data cleansing projects.
The Sforce Connector uses the API and is therefore only available to Enterprise Edition Customers. While this tool is easy to install and easy to use, you need to be careful anytime you’re manipulating large amounts of live data. Click on the links below to learn more.
Excel Sforce Connector | Best Practice Presentation by Ron Hess | The Excel Connector Discussion
Bookmark
It would be nice to have this be available for all versions of Salesforce.com (paying, that is) because I have the same data cleansing needs as an enterprise would, but it's just little ole me, the consultant. In fact, if anyone would need this it would be me, as I'm having to do it all in my business. I need every tool I can get!
Posted by: Hans | May 24, 2005 at 12:07 PM
I Agree. This is a tool that should really be available to all editions.
Posted by: Tim | January 06, 2006 at 10:41 AM
I am trying to use the update feature in the Excel Connector. There are three fields that need to be updated. I first ran the update on two fields and it worked, but then I added another field and the connetor does not want to update that new field, and I am getting an error. Does any one know what is causing that?
Posted by: Peter Draper | January 24, 2006 at 09:55 AM
So, this will not work with the professional version at all????
Posted by: Jacob Minett | April 18, 2006 at 08:18 AM
Jacob, you need the Enterprise Edition to make API calls, so sorry, this will not work with the Professional Edition.
Posted by: Kingsley Joseph | April 18, 2006 at 10:13 AM
Actually, I was wrong. Go to http://www.crmsuccess.com/browse/feature_detail.jsp?id=00630000002mUplAAE
and download the SForce connector (PE).
Posted by: Kingsley Joseph | April 18, 2006 at 02:48 PM
Can somebody please develop the same tool for Professional Edition?... There seems to be an obvious need.
Posted by: Luis Navarro | June 08, 2006 at 09:23 AM
Luis, it's already available here: http://blog.crmsuccess.com/crmsuccess/2005/07/sforce_connecto.html
Posted by: Kingsley Joseph | June 08, 2006 at 10:12 AM