function readOnly(count){ }
Sign Up ›
Starting November 20, the site will be set to read-only. On December 4, 2023,
forum discussions will move to the Trailblazer Community.
Learn More

Browse by Topic
ShowAll Questionssorted byDate Posted
+ Start a Discussion
B_BajajB_Bajaj 

Data Import directly from spreadsheet

Hi Everyone,

One of my client wants to import data into Salesforce directly from thier Excel template with a click of button. Is there any way to do it using Macro/Rest/Soap. Its quite a different requirement and I am not sure how to take it forward.

I believe Excel connector provides the same feature but just wanted to make sure that it works independly of other add-in/macro of excel as my client's Excel template has so many formulas and macro placed in already.

Any help is appreciated.!

Thanks,
Bhisham Bajaj
NaveenReddyNaveenReddy
We can  import data from excel/csv  files by using DataImportWizard ,DataLoader,JitterBitDataloader.
If you want to import directly from excel on a button click you need to integrate excel with Salesforce.
Salesforce provides Meatadata API this will be helpful to integarte any external application to salesforce.

Regards,
Naveen
B_BajajB_Bajaj
Thanks Naveen, I am aware of importing tools but the concern is "with a click of a single button on Excel/CSV", It will be great if you can provide some useful links or soemthing related.

Regards,
Bhisham
Gaurav NirwalGaurav Nirwal
You can prefer the link to import the data directly from spread sheet .csv file

https://support.google.com/docs/answer/40608?hl=en
Gaurav NirwalGaurav Nirwal
You can prefer the link to import .excel file 

http://pcunleashed.com/excel/how-to-import-data-into-an-excel-spreadsheet/

please select my answer as best answer