When you create a list from Microsoft Excel, you map table data to a new list – adjusting column types before you click Create. 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. This is a new way to create a list, saving you time while putting the data in a location that opens new scenarios.
Today, we’re pleased to announce lists from Excel is now rolled out worldwide to customers in Microsoft 365. They are easy to use, secure, with high capacity up to 30 million items in a single list.
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. Every month, tens of millions of people turn to SharePoint lists to track and manage critical business and team data.
