You can create a Microsoft Lists by bringing in table data from excel. However, you need to ensure that your excel file is formatted as a table.



1. Select the cells in your excel file

     


2. Select Home -> Format as Table, select layout.

     



3. The following will be prompted, ensure "My table has headers" is selected and close and save file

   


NOTE: Ensure the column name format does not have carriage return

            

             Valid column name format


            Invalid column name format

            




4. Open your browser and login to office.com, select App Launcher

   



5. Select All Apps and then select Lists

   

    

   


6. The following dashboard will be displayed, select New list

     


7. Select "From Excel" 

   



8. Select the formatted file to import

   


9. Verify that the each column type is correct, update with the correct column type, click "Next" once done. If there are no issues, this will create the Microsoft Lists.

   







https://competenz.freshservice.com/support/solutions/articles/5000082913