Create a SharePoint list from Excel in Microsoft Teams

Create a SharePoint list from Excel in Microsoft Teams

SharePoint Team sites bring documents, data & apps together. Adding a SharePoint list in Microsoft Teams is not always done via files. Via files, documents remain static, at least as far as the content is concerned. This means you can't automate much. A SharePoint list can contain up to 3,000,000, that is 3 million items and you can work on it in Excel, PowerApps, and on your mobile devices and PC. This blog explains in 15 steps how you can create a list in Microsoft Teams. Also publishing and sharing it so it will be visible to everyone in your organisation or team is included.

1. Start from your Microsoft Teams Application - In your Microsoft Teams click on 'Open in SharePoint

1

2. Navigate to site content

1

3. Select New -> List

1

4. Select one of the 3 ways

  • Create new list
  • Create existing list
  • In this case, from Excel. If the file is on your computer.

5. Select your Excel file, press upload

1

6. Press create

1

7. Welcome to the new experience for lists!

8. Your list has been created

1

9. Make your tables more attractive

  • You can adjust settings via column settings.
  • You can assign colours to this column according to your own needs, etc.
1

10. Go back to Microsoft Teams

1

12. Select -> SharePoint

1

13. Select your list and press save

1

14. Your data is now easily accessible in Microsoft Teams

1

15. Most importantly! Your whole Team💬 will see that the new list is integrated and they will get a new notification.

1

Reasons to work with a SharePoint list?

Data retrieval
No static files, versions, etc.
one fixed place
Automations with PowerAutomate
Data feeding, automatic processing
3,000,000 records. What you can work with from anywhere.

Also readAll about Microsoft Lists.

Jasper

Jasper

Welcome to 365tips.be. On this website you can read articles and experiences about Office 365 with focus on Microsoft Teams. Feel free to ask me a question and I will answer it in a blog post. Help others by giving feedback at the bottom of the articles. This blog is made in Dutch. The multilingual website is offered with best-effort machine translation.
0 0 votes
Product review
Subscribe
Please let us know if there are
guest
0 Reactions
Inline feedbacks
See all comments
0
Would love to know your thoughts, please leave a comment.x