SharePoint allows us to create a List using an excel file. In this article, we will see what configuration we need to make in excel before we use it to create a list and then how to create a SharePoint list using excel.

Create an Excel file with Table

• Open an excel
• Add columns and some data (if you want) to it.

• Select all the cells that you want to include in your table and click on Format as Table from Home tab

• Save the file.

Create a SharePoint List using table formatted Excel.

• Go to your SharePoint Site.
• Go to Site Content.
• Click on New > List

• Click on From Excel.

• If you have already uploaded the excel file on the SharePoint site, then select it else click on the Upload file.

• Upload the file that we had created.
• It will come up with the columns and rows. It will also allow you to change the data type of each column.

• Enter the list name and change the column types if you want and click on Create.
• That’s it. Done!!! Your List is created.