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.

  • 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

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/


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

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

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

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