This website uses cookies to ensure you get the best experience on our website.
Accept

How to Update SharePoint List from Excel

SharePoint Lists are important in data management and team collaboration, letting teams organize, store, and track all information in an...
Read More
How to Update SharePoint List from Excel

How to Change Classic SharePoint to Modern SharePoint

Sticking to old tools in today’s modern digital world can slow down your productivity and growth. For several companies, classic...
Read More
How to Change Classic SharePoint to Modern SharePoint

The 5 Best Organizational Chart Options in 2025

Ever tried explaining your company’s structure using only words? It’s like describing a building without showing a floor plan. In...
Read More
The 5 Best Organizational Chart Options in 2025

What is the Meaning For Auctions: A Complete Guide

New to auctions and curious about them? This guide explains what you need to know, from the basics to smarter...
Read More
What is the Meaning For Auctions: A Complete Guide

Ultimate Guide to Construction Bidding: Tips & Strategies

Ever wondered how construction projects get off the ground? It all starts with construction bidding, a process that determines who...
Read More
Ultimate Guide to Construction Bidding: Tips & Strategies

Microsoft lists – Simple, Smart, and Flexible

In Microsoft Build 2020 (a Microsoft event), the giant disclosed a new app for the M365 ecosystem e.g. Microsoft lists. Microsoft list is an M365 app that helps you organize work and track information that matters most to your business.

Microsoft described Lists as an “evolution” of the current SharePoint Lists capability. Lists make it easy to create and share with anyone on your network. Lists work on any device and keep everyone in sync with its smart rules and collaboration features. You can customize the Microsoft Lists according to your specific business needs.

You can create a list in several ways from scratch, by importing Excel data for a quick start, from an existing SharePoint list, and using the templates available on Microsoft Lists. Microsoft Lists provide the following eight default list templates.

  • Issue tracker
  • Employee onboarding
  • Events itinerary
  • Asset manager
  • Recruitment tracker
  • Travel requests
  • Work progress tracker
  • Content scheduler

Create a list in Microsoft Lists

1. To access the Microsoft List, open the app launcher in the top right corner of your Microsoft 365 Online Portal, and click Lists.

2. You will be redirected to the Lists app home page, where you can see all the list.

3. From the app home page click on the ‘+ New list’ button.

4. From the ‘Create a list’ page, select one of the following options:

a. Blank list: Choose this option to start from scratch. Give your list a Name, Description(optional), and select any other options you want. The list will save to ‘My lists’ unless you choose one of your SharePoint sites or Teams from the ‘Save to’ list. When you are finished selecting options, select ‘Create’.

b. From Excel: Choose this option to create a list based on an Excel spreadsheet.

c. From the existing list: Choose this option to save time and create a new list based on the columns in another list. Your new list will start with the same columns but will not have any data.

d. Templates: Select a template, such as an ‘Issue tracker,’ to see what columns the template has. You can then scroll through sample data to see what to include. Select the templates that fits your specific needs.
Click the ‘Use Template’ button.

5. Once you create the list, you can open it. If required, you can add new columns by selecting ‘+’ or ‘+Add column’.

6. You can share the list with your co-workers. Determine how much access they receive by choosing either the “Full Control, Edit, or View” permissions.

7. You can export the list to an excel file.

8. You can integrate the list with Power Apps and Power Automate integration as needed.

Currently, Microsoft Lists is included in the following subscriptions.

  • M365 Business basic
  • M365 Business standard
  • M365 Business premium
  • M365 Enterprise E3
  • M365 Enterprise E5
  • M365 Enterprise F3

Final Thoughts

Microsoft Lists is a great app to organize your work and track key information. The app has integration with PowerApps, Power Automate, Microsoft Teams, and SharePoint, which makes it more powerful. Microsoft lists not only has a web and Teams app, but it also has an iOS and Android app which will help users to work remotely on the list information. In our upcoming blog, we will share how to use the Microsoft lists app with Microsoft Teams. To learn more about our M365 service suite and capabilities, connect with us at [email protected].