Salesforce Smart Importer – 1-Drag to import Excel / CSV in Salesforce, supports both Classic and Lightning!

This is my third Chrome Extension named Salesforce Smart Importer (Other two popular extensions are Salesforce Mass Editor and Salesforce DevTools), it is designed for Salesforce not only admin but also normal user, supports :

・1-Drag to import any Excel / CSV data on anywhere in Salesforce, both Classic and Lightning.
・Automatize reference field value to lookup Id convertion.
・Mapping fields between sObject and Excel / CSV header only needs to be set once.

Notice : In Classic, don not check on “Require HttpOnly attribute” option in “Session Settings”.
If you login with a Non-Admin user, make sure “API Enabled” in profile has been checked.

Install From Chrome Web Store

Sample CSV is HERE

Tips for using

In Classic

In Claasic, you can active it by clicking Extension icon, no needs any setting additional.
Once mapping was set, it will automatize fileds mapping next time. You can also use reference record Name instance of Id, it will do the convertion for you, as below :

In Lightning or Community Cloud

If you are using Lightning Experience or Salesforce Community Cloud, it needs login once before using, as below :


If you have any question, requirement and issue, report it HERE (Github) , that will be fixed ASAP!
Please feel free to comment at below with Facebook, if you have any questions or advices.

Install From Chrome Web Store

Release Note


・ Add Excel import feature.


・ Add feature of Upsert by External Id. ・ Add feature of automatize reference External Id field value to lookup Id convertion. ・ Fix bugs in Lightning.


・ Beta released.

Enjoy it. : )

Related Post

Pipeline for Salesforce – Be less busy, less... Overview Pipeline is a metadata deploy app for Salesforce, supports: ・Making Changeset with Excel file in seconds. ・Exporting Pipeline target metadata list to Excel file. ・No dependencies on Salesforce Org, deploying metadata between different organizations. ・Deploying metadata base on gi...
Salesforce DevTools – A powerful Chrome exte... Salesforce DevTools is a Chrome extension helping developers do the below things: ・Generate Salesforce data model (ERDs) as svg. ・Export definition of objects to Excel file. ・Show / Hide object API name on object detail page by 1 Click. ・Quick generate test data Apex Code and SOQL. ...
Salesforce Mass Editor (Chrome Extension) – ... This's my second Chrome Extension (First one is HERE) this year, named "Salesforce Mass Editor" and it supports for doing the below things : ・Makes any Salesforce list view to be a powerful mass editor. ・Mass insert, mass clone, mass update, mass delete, ALL-IN-ONE. Support for both Classic and ...
Setup an awesome Salesforce developer environment ... Why Sublime Text 3 ? I've been working with for about 2 years, and always using IDE(See here, Eclipse IDE Installation)as my development environment. I don't think it is really difficult to use, but it could be more friendly. For example: 1. It doesn't suppo...