Create a list from Microsoft Excel

Every month, tens of millions of people turn to SharePoint lists to track and manage critical business and team data. Lists enable organizations and teams to store and visualize rows of data to share and collaborate on scenarios like inventory management, status reporting, deal milestones and more. They are easy to use, secure, with high capacity up to 30 million items in a single list.

Today, we’re pleased to announce lists from Excel is now rolled out worldwide to customers in Microsoft 365. This is a new way to create a list, saving you time while putting the data in a location that opens new scenarios.

Let’s dive into the details…

Lists from Excel

To create a list from Excel, you can select a table from the Excel files in the SharePoint site, or from your device. You can change the field type of the column if needed, and all your table data will be copied to the new list.

When you create a list from Microsoft Excel, you map table data to a new list – adjusting column types before you click Create.

A quick step-by-step ‘how to’

  1. From within your SharePoint site, click the upper-right gear icon and select Site contents*

  2. At the top of the Site contents page, Click New > List

  3. Click the From Excel tab

  4. Enter a name for your new list

  5. Click Upload file to select from your local device or pick from files already in Microsoft 365

  6. Update the column type headers; for example, change "Number" to Date and time; choice fields work, too, automatically aggregating unique values.

  7. Click Create to import the Excel table data and create a new SharePoint list

Adjust the SharePoint column types before you import the Excel table data into Microsoft 365.

Your Excel data is now intact; your SharePoint list ready to extend in numerous ways:

  • Further assign and adjust data types to columns in your list

  • Enhance visuals by designing list row and column formatting

  • Use conditional formatting rules to make the list data intuitive and helpful

  • Set reminders on list items

  • Build productivity apps with Power Automate (custom flows) and Power Apps (custom forms); your list becomes the foundational data source.