Unable to import data in MS List App

Occasional Visitor

Hi there,


I am trying to create a project tracker using the Lists app in teams (I know planner and project exist but the management needs a POC for lists as well) and I noticed that if I start a list from scratch, it is very easy to format the columns and make them look aesthetic, also it is easy to add a Person/Group Type column where I can add people that link back to their profile and other Org data. However, when I try to import an existing tracker that existed in an Excel until now, I am either unable to import it or if it imports, there is no formatting and the people names don't seem to be linking to their respective people/employee profiles. Has anyone been able to successfully import excel data into the Lists project tracking app?


This is how it looks currently:


This is how I want it to look:



1 Reply
I can't see any way to make it look exactly like a new list from scratch. but there are some formatting changes you can make to jazz things up a bit. Take a look at this - https://www.youtube.com/watch?v=uKtN8Mq6Wdw