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.
SharePoint Stack Exchange is a question and answer site for SharePoint enthusiasts. It only takes a minute to sign up.Sign up to join this community
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...
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.