How to Create a SharePoint List from Excel in 6 Steps (Microsoft 365)

To create a SharePoint list from Excel, go to your SharePoint Online site, click + New > List > From Excel, upload your .xlsx file, review the auto-detected column names and data types, then click Create. SharePoint imports your spreadsheet data as a structured list with each Excel column becoming a SharePoint list column. The process takes under 10 minutes and requires no coding. Your Excel file must have column headers in row 1 and be saved in .xlsx format. Merged cells and blank header rows will cause import errors. This feature is available in SharePoint Online (Microsoft 365) and SharePoint Server 2019 and later.  

Microsoft Lists is a fantastic option for processing large amounts of data. You may be familiar with Excel Spreadsheets for storing and monitoring data lists. Excel spreadsheets continue to assist companies in managing data lists. Microsoft Lists is capable of efficiently processing and tracking data, so transitioning your spreadsheets to a SharePoint List is one of the best decisions you could make. In this blog, we'll explain how to create a list in SharePoint Online from an Excel Spreadsheet.

Advantages of Importing Your Excel Spreadsheets to SharePoint Lists

Importing your Excel Spreadsheets to SharePoint Lists offers several advantages. Creating new lists in SharePoint saves much more time than creating them in an Excel file. By importing an existing Excel Spreadsheet to create a new list, you can continue tracking the list data from where you left off in the Excel sheet.

When you import an Excel file into a SharePoint List, the table headings are converted to headings of columns in the list, where other data is then added as list items. In Microsoft Lists, you can use features like edit history, task management, and the ability to add attachments.

What Are the Requirements Before Creating a SharePoint List from Excel?

Before importing, your Excel file must meet these requirements.

Excel file requirements:

• File format: .xlsx (Excel 2007 or later). The older .xls format is not supported.
• Column headers: Row 1 must contain column headers. Empty or merged header cells cause import errors.
• No merged cells anywhere in the data range
• No blank rows within the data range
• Column names must not contain special characters that are invalid in SharePoint column names
• Maximum recommended rows: SharePoint lists support up to 30 million items, but large imports may be slow

SharePoint requirements:

• You need Edit or higher permissions on the SharePoint site
• You must be using SharePoint Online (Microsoft 365) or SharePoint Server 2019+

The classic SharePoint experience has different steps from the modern experience (this guide covers the modern experience) 

How to Create a SharePoint List from Excel: Step-by-Step

Complete the following steps to create a Microsoft List from an existing Excel Spreadsheet:

Step 1: Prepare Your Excel File

Open your Excel workbook and verify:

• Row 1 contains column headers (e.g., "Contract Name," "Vendor," "Start Date," "Value")
• No merged cells exist anywhere in the table
• There are no blank rows between data rows
• The file is saved as .xlsx

Pro tip: Format your Excel data as a Table (Ctrl+T) before importing. This helps SharePoint accurately detect the data range and column types.

Step 2: Navigate to Your SharePoint Site

• Go to your SharePoint Online site (e.g., https://yourcompany.sharepoint.com/sites/yoursite)
• In the left navigation, click Site contents
• Navigate to the location or subsite where you want the new list to appear

Step 3: Click + New and Select List

• In the top command bar of your SharePoint site, click + New
• From the dropdown menu, select List

The "Create a list" panel will open on the right side of the screen.

Step 4: Select "From Excel"

In the "Create a list" panel, you will see several starting options:

• Blank list
• From Excel
• From existing list
• Templates

Click From Excel.

Step 5: Upload Your Excel File

• Click Upload file in the file upload area
• Browse to and select your prepared .xlsx file
• Alternatively, drag and drop the file into the upload zone

SharePoint will parse the file and automatically detect:

• Column names (from your row 1 headers)
• Data types (text, number, date/time, yes/no)

Step 6: Review Column Types and Create the List

After upload, SharePoint displays a preview of detected columns. Review each column:

• Column name: Matches your Excel header row 1 - edit if needed
• Data type: SharePoint auto-detects the type. Common types:
  • Single line of text - for names, IDs, short descriptions
  • Number - for amounts, quantities
  • Date and time - for dates
  • Yes/No - for boolean columns
• To change a column type, click the type dropdown next to the column name
• Enter a List name (required)
• Optionally add a description and choose whether to show it in the site navigation
• Click Create

SharePoint creates the list and imports all rows from your Excel file.

• Find the Excel Spreadsheet in your desktop or SharePoint site’s default document library, then format the desired content into a table using Format as Table.
  
• Go to the SharePoint Site that you'd like to create a new list for using the Excel Spreadsheet.
• Click New and choose List.
  
• From the Create a list page, choose From Excel.
  
• Click Upload file and select the file from your desktop or default site document library. Click Open.
  
• From the Customize window, change the column type if required, then click Next.
  
• Make any necessary changes to the Name of the list, add a description, and enable or disable the Show in site navigation.
  
• Click Create when complete.
  
• The list is now created.
  
• Go to the Settings pane by clicking the Settings icon. Choose List settings to configure versioning settings if desired.
  
• Choose Versioning settings from the Settings page.
  
• Configure Content Approval and Item Version History options as needed.
  
• Click OK when complete.
  

How to Edit or Update SharePoint List Data After Import

Once imported, your SharePoint list is independent of the original Excel file — changes to Excel do not automatically sync to SharePoint. To update list data:

Option 1: Edit directly in SharePoint

• Click on any item in the list to edit it in the panel
• Or click the row's (...) menu and select Edit

Option 2: Edit in grid view

• Click Edit in grid view in the command bar for Excel-like inline editing of multiple rows at once

Option 3: Re-import from Excel

• There is no built-in "sync from Excel" feature for standard lists
• For ongoing sync between Excel and SharePoint, consider using Power Automate to automate data transfer

How to Create a SharePoint List from Excel Using Power Automate (Advanced)

For recurring imports or ongoing data sync between Excel and SharePoint, Power Automate provides automation without manual uploads:

• In Power Automate, create a new Automated or Scheduled cloud flow
• Use the Excel Online (Business) connector with the List rows present in a table action to read Excel data
• Use the SharePoint connector with Create item action to write each row to your SharePoint list
• Add error handling to skip duplicate rows

This approach is ideal for contract registers, vendor databases, or any list that is regularly updated from an Excel source.

Common Errors When Creating a SharePoint List from Excel

Considerations When Importing An Excel File into A SharePoint List

When importing Excel Spreadsheets, if they do not contain a table, then you will receive instant instructions to assist you in editing the document so it can process the import.

SharePoint Lists is capable of processing tables containing up to 20,000 rows to create a list. This is possible in all SharePoint versions. Column types are automatically configured during the import. However, after this first stage of the import, it's key to review the list and adjust column types as needed.

With these options, you can import Excel Spreadsheets into SharePoint Lists for increased user-friendliness and efficiency in data processing. Now that we've covered the easiest way to import data from Excel Spreadsheets to SharePoint Lists, let us know your thoughts and queries in the comments section below.