How to add data to SharePoint list
Posted on June 27, 2018 | Lists Show Custom List Excel A while back, I published a post where I explained how to export SharePoint lists from SharePoint to Excel. Today, I am going to cover the opposite of this how to import Excel to SharePoint. Say, you have an Excel list/table and want to bring it to SharePoint (because SharePoint custom list kicks ass!). How do you achieve this? Well, let me explain. You have a few options to choose from! July 2020 Update READ THIS FIRST!Below techniques describe the old way of importing Excel to SharePoint. If you are in SharePoint on-premises, below tips are the only options you have. However, if you are in SharePoint Online (Office 365), we now have a new and easier way to import Excel data, which would be the easiest and preferred option to use. Please reference this most recent post for instructions. Option 1: Import using Quick EditThe first option assumes that you already have a SharePoint list with all the corresponding columns, and just need to copy/paste the content from Excel to SharePoint. Here is what you need to do to achieve this:
Pros
Cons
Option 2: Import Spreadsheet Web partAnother option that is available to import Excel to SharePoint is to use a Web Part called Import Spreadsheet. These are the steps to follow:
Pros
Cons
Option 3: Import directly from ExcelAnother great option is to import data right from within Excel. This is what you have to do:
ProsSame as Option 2 Cons
|