Take the 2-minute tour ×
SharePoint Stack Exchange is a question and answer site for SharePoint enthusiasts. It's 100% free, no registration required.

Is it possible to import data from an Office Excel or Word file into a list in SharePoint (specifically SharePoint Online)?

I have imported data from SharePoint lists to Word files.

share|improve this question
    
I have edited your question and changed the wording a little. Please change it if I have missed the point of what you are asking. –  SPDoctor Nov 14 '11 at 8:01

3 Answers 3

up vote 1 down vote accepted

Yes it is possible to import Excel data into SharePoint List. It can be done by creating Import Spreadsheet. Refer this link... http://www.bloggix.com/archive/2010/06/15/import-and-export-data-between-excel-2010-and-sharepoint-2010/

share|improve this answer

Sure... In list click the Datasheet View from the ribbon... and paste your contents from the excel...

share|improve this answer
    
Create the list with the same columns as in the excel sheet... –  Strider Jun 15 '12 at 3:08

You can also use PowerShell script to import excel saved as csv file.

Here is a link to an example.

With PowerShell you can do some logic too, to make sure it matches your list. E.g. if A equals B then input value C.

share|improve this answer

Your Answer

 
discard

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.