

Option 2: When you already have a SharePoint list and want to add more data/ records below the existing list. It will default to Datasheet view, just click Stop to view it as a normal list. You will be getting a success message/pop-up and your list would be published at the SharePoint site you provided.Ħ. You will find all the columns with corresponding recognized column types (Currency, Date, etc.). A pop-up appears as below where you will have to specify the URL of the site you are importing to, then provide your list name. While still selecting the data table, choose an Export option from the ribbon and select the ‘ Export table to SharePoint List’ option.ģ. Then click on the Format as a Table option.Ģ. Open your excel sheet and select the data to be copied. You can export this whole data from within excel by following these simple steps.ġ. We assume that you have an excel sheet with all your master data in the format or corresponding columns as you would like to see in the new SharePoint list. Option 1- When you have to create a completely new SharePoint list. Let’s see the step-by-step process for making this happen.

We have a solution that can be extremely helpful. Our SharePoint add-in users who are using our Employee Onboarding solution want to quickly bring their already prepared excel sheet with master data on departments, employee details, and standard tasks into the add-in without much hassle. Many of our SharePoint add-in customers keep asking us that is it possible to easily export an already prepared excel sheet into a SharePoint list?Īnd we say- yes, it is possible and extremely simple! Office 365 Custom Development Portfolio.
