Forum Discussion
lemonap618314
Sep 28, 2020Copper Contributor
Upload excel file to issues log in Teams
Hello All,
I was wondering if Teams had the ability to upload information from an Excel file to the Issues log in Teams?
Below is an image of my Excel file and Issues log. Since the Excel file and the Issues log have the same column headers, can I simply upload the Excel, and will Teams automatically add those items to the Issues Log? Let me know. Thanks!
1 Reply
- Hi lemonap618314
You can create Lists from an excel as per article
https://microsoft365pro.co.uk/2020/09/06/teams-real-simple-with-pictures-microsoft-teams-loves-microsoft-lists-pt-1/
However, creating another line on the excel spreadsheet would not create a List Item automatically - and neither can you merge an excel into an existing List. So the only recommendation here is to 1.) Take any items on the Excel which aren't on this list and add them manually to the list or 2.) Remote and Delete the List and then recreate it via Teams
Creating Lists from Excel, at this point in time is only really designed for when first creating the List. After that point you would add, remove and manage in the List and then ideally get rid of the excel used in creating it, or storing it somewhere as a snapshot at a particular time where you would periodically export new snapshots
You could always open a uservoice here if you feel it is something you would like to see in the future
https://microsoftteams.uservoice.com/forums/555103-public
Hope that answers your question
Best, Chris