In this article you will learn how to Import Excel Data into a SharePoint 2013 List.
One of my requirements was to import data from Excel into a SharePoint List and I didn't want to use C# for it.So, I used this approach.Here is the sample data I used (this is for a sample to show). Do as shown in the following screenshot.Now as shown in the screenshot your Excel data is ready to import. Now go to your SharePoint site and open Site Contents and click on add an app link. Then search for Import.If you click on it you get this page.Select Excel spreadsheet and click on the Import button. It will open an Excel Spreadsheet in Excel Office as shown in the following screenshot.Select a range for your Excel Sheet name and Table name.For example. Sheet1! Table3.Now click on Import then move to your site. Your list is created with the Excel data. Here it is.So that is how you can create a list from an Excel sheet or import data from an Excel list and create a list.
Getting Started with SharePoint Framework Development using TypeScript, PnP JS, and React JS