How To Create List From Excel In SharePoint Online Modern Site

In this article, you will learn how to create a list from Excel in SharePoint Online modern site.

Introduction

 
In this article, you will see how to create a list from an Excel sheet in SharePoint Online modern site. I have created an Excel sheet named Project Details with the following details and uploaded to SharePoint document library.
 
How To Create List From Excel In SharePoint Online Modern Site
 

Create list from Excel

  • Navigate to SharePoint Online Modern Site.
  • Click the "Settings" icon and then click "Site Contents".
  • Click New >> List.

    How To Create List From Excel In SharePoint Online Modern Site

  • Select the "From Excel" option, select Project Details >> Next.

    How To Create List From Excel In SharePoint Online Modern Site

  • Follow the instructions provided in the screenshot and then click Refresh. Note - When I created the Excel sheet, I just entered the information in the sheet but I have not formatted as table.

How To Create List From Excel In SharePoint Online Modern Site
  • Click "Go to Project Details.xlsx" link which opens the Excel sheet in a new tab. Select the cells that have to be included and then click "Format as table" as shown in below screenshot. Save the file by pressing Ctrl+S.

    How To Create List From Excel In SharePoint Online Modern Site

  • Click "Refresh".

    How To Create List From Excel In SharePoint Online Modern Site
  • You can see the table selected from Excel and all the required details as shown in the below screenshot.

    How To Create List From Excel In SharePoint Online Modern Site

  • Check the column types for the columns and change it based on your need and in case if you don’t need any column, select "Do not import" from the drop-down.
  • I have changed Start Date and End Date to the date and time. Also, I have changed client location to choice.
  • Enter a name for your list and click "Create".

    How To Create List From Excel In SharePoint Online Modern Site

  • A new list has been created, as shown in below screenshot.

    How To Create List From Excel In SharePoint Online Modern Site

Summary

 
Thus, in this article, you saw how to create a list from Excel sheet in a SharePoint Online modern site.