Create a list from Microsoft Excel
Published May 28 2020 08:00 AM 102K Views
Microsoft

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.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.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.

Further refine your list with conditional formatting on rows and columns.Further refine your list with conditional formatting on rows and columns.

Note: You can analyze SharePoint list items from a view of the list to Excel – to work with the data in a spreadsheet; simply click Export to Excel. Note: Excel creates an Excel table with a one-way data connection based on a web query file. To bring a fresh copy of the SharePoint list to Excel, select Refresh All on the Data tab from within Excel. Changes made to the Excel table will not be sent to the SharePoint list. Learn more how to export to Excel from SharePoint.

 

In Summary

It is easier than ever to get started with SharePoint lists – using Excel as shown above or based on existing lists. No matter how you start, it’s then easy to further configure lists by using views, filters, rules and reminders to increase the usefulness of your data – especially as data changes or is missing.

 

You can further customize lists, too. It is possible to further extend with native integrations leveraging Power Apps and Power Automate. And when your forms and workflows get more complex or pull from multiple sources lean on the Power Platform tools directly available from your list.

 

Note | We recently announced Microsoft Lists and how it is an evolution of SharePoint lists. For the list from Excel announcement above, we want to emphasize that you will be able to create a list from Microsoft Excel today and in the future when Microsoft Lists begins to roll out and broaden the lists story.

 

Learn more about how to create a list from Microsoft Excel and see it in action, via demo video:

 

 

... or in this SharePoint list: "Create list from Excel" click-thru demo.

 

Additional resources:

 

Thanks, Mark Kashman, senior product manager - Microsoft 

 

*Frequently Asked Question

Q: When will I see the new list creation user interface from a team site home page (New > List) drop-down menu?

A: We are planning to include the New > List entry point from a site home page early Summer 2020. Until then, you can accomplish the above actions from the site’s Site Contents page, accessed from the upper-right gear icon menu.

22 Comments
Version history
Last update:
‎Jun 13 2020 06:14 PM
Updated by: