M365 Import List from Excel File
Hi All,
Did you know, that you can create a Microsoft List in M365 from an Excel?
I have created this Example Excel
![](https://icewolffile.blob.core.windows.net/$web/202201/ListsFromExcel_01.jpg)
From the Office 365 Portal in the Browser i open Lists
![](https://icewolffile.blob.core.windows.net/$web/202201/ListsFromExcel_02.jpg)
Here i create a "New List"
![](https://icewolffile.blob.core.windows.net/$web/202201/ListsFromExcel_03.jpg)
I select "From Excel"
![](https://icewolffile.blob.core.windows.net/$web/202201/ListsFromExcel_04.jpg)
The Excel File has to be on your OneDrive
![](https://icewolffile.blob.core.windows.net/$web/202201/ListsFromExcel_05.jpg)
If the Table is not yet properly formated you need to fix that
![](https://icewolffile.blob.core.windows.net/$web/202201/ListsFromExcel_06.jpg)
With the klick on the above "Open" the Excel File will loaded in Excel Online. You then Select the Data and "Format as Table". Then close Excel Online
![](https://icewolffile.blob.core.windows.net/$web/202201/ListsFromExcel_07.jpg)
![](https://icewolffile.blob.core.windows.net/$web/202201/ListsFromExcel_08.jpg)
Now your are able to fix some collumn Namens an check the Type
![](https://icewolffile.blob.core.windows.net/$web/202201/ListsFromExcel_09.jpg)
Give the List a Name and Save it
![](https://icewolffile.blob.core.windows.net/$web/202201/ListsFromExcel_10.jpg)
And here you go: A List imported from Excel
![](https://icewolffile.blob.core.windows.net/$web/202201/ListsFromExcel_11.jpg)
With "New" you can add new Entrys
![](https://icewolffile.blob.core.windows.net/$web/202201/ListsFromExcel_12.jpg)
You will find your Lists under "My Lists"
![](https://icewolffile.blob.core.windows.net/$web/202201/ListsFromExcel_13.jpg)
Regards
Andres Bohren
![](https://icewolffile.blob.core.windows.net/$web/logos/O365_logo.png)