SharePoint Stack Exchange is a question and answer site for SharePoint enthusiasts. It's 100% free, no registration required.

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

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
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...

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


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.