SharePoint Stack Exchange is a question and answer site for SharePoint enthusiasts. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

I need to import an excel file to Sharepoint list without using manual import (Import to Excel). Instead, I want to import automatically by specifying the path of the Excel sheet or by using any Scheduler. Suggest me...

share|improve this question
Do you mean automatically like all Excel files in Path X should be imported as lists. So when users uploads excel files to that location it should automatically be imported as lists? – Anders Aune Nov 30 '12 at 11:02

I dont know what do you mean by "manual import" but SharePoint provides you OOB functionality for this, go to view all Site Contents, there you will find the option "Import Spreadsheet", it imports automatically by specifying the path of the Excel, but if you must perform some custom action while importing the data you should consider developing a webpart

share|improve this answer

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.