In this Microsoft Lists tutorial, we will discuss how to create a list from excel in Microsoft lists. Step by step we will discuss how to create an excel file and then we will see how we can use the excel file to create a list in Microsoft lists.
You may also like How to create a list from excel in SharePoint Online.
Create a List from Excel in Microsoft Lists
Let us check step by step how to create a list from an excel file in Microsoft lists Office 365 App.
First let us create an excel and format that as a table.
Once you create an excel, we need to format as a table.
For this select everything and then click on Format as Table, then select a table layout. Then click on OK.
Then it will open the Format As Table dialog box. Here check the checkbox “My table has headers” like below.
You can also rename the Table name like below:
Now, our excel file is formatted and is ready. Let us see how we can use this excel to create a list in Microsoft lists.
Open the Microsoft Lists App from Microsoft 365 or Office 365 app launcher. Then click on the + New list.
Once you click on the button, the Create a list dialog box will open. Here select From Excel like below:
Here you will get two options to select the excel files.
1- Either you can click on the Upload file button to upload the excel from the local desktop.
2- The other option is you can select the files from your OneDrive for Business.
Once you upload the file, you can see it will populate like below.
If your excel contains multiple files, then you can select it from “Select a table from this file“.
Based on the table selected, it will display the columns and you can also change the datatype. Here for the Holiday Date, I have selected the Date and time. And the Title data type is Title.
Then click on Next.
Once you click on Next, it will you to provide a list name, description, choose a color and to choose an icon. Then click on the Create button.
Once you click on the Create button, the list will be created with the data we have in the excel file and you can see below:
This is how we can create a list in Microsoft Lists from an excel file.
You may like the following SharePoint tutorials:
- SharePoint alerts – Create and Manager Alerts in List or Library
- Disable attachments in SharePoint list
- Create SharePoint Online List Programmatically using PnP CSOM
- Open SharePoint list in excel + Update excel from SharePoint list automatically
- SharePoint Create Folder in List or Document Library
- PowerApps: Submit data to two SharePoint Lists
- How to check if a list exists in SharePoint Online site using PNP PowerShell
- How to add Comments to SharePoint Online List Items and Microsoft 365 Lists Items
In this tutorial, we learned how to create a list from an excel file in Microsoft Lists. In Microsoft 365 Lists App, we can easily create a list from an excel spreadsheet.
I am Bijay a Microsoft MVP (10 times – My MVP Profile) in SharePoint and have more than 17 years of expertise in SharePoint Online Office 365, SharePoint subscription edition, and SharePoint 2019/2016/2013. Currently working in my own venture TSInfo Technologies a SharePoint development, consulting, and training company. I also run the popular SharePoint website EnjoySharePoint.com