SharePoint offers the basic feature of importing a spreadsheet which will then become a brand new list. If any updates are made to the spreadsheet, you will either have to:

• manually key in the updates to the list -or-
• copy and paste the updates to the list using the DataSheet View or QuickEdit (depending on your version of SharePoint), -or-
• delete the list and re-import the spreadsheet, thereby creating a new list every time

Alternatively, there is an add-in for SharePoint Online that allows you to import an Excel or CSV file into an existing SharePoint list.

Click here to go to the product page on the Microsoft App Store and add this cool add-in to your arsenal.

This entry was posted on January 29, 2019 at 8:57 am. You can follow any responses to this entry through the RSS 2.0 feed. Both comments and pings are currently closed.

Posted in Office 365 SharePoint 2013 by Doug Comments Off on Import Excel file into an Existing List