Microsoft Lists | Three Tips for Creating Lists

hello it's matt and welcome to collaboration coach this time we're going to have a look at microsoft lists and i've got three tips that will help you when you create them creating a list with microsoft lists is very easy you just go to the app launcher and you choose the lists app then you choose the new list button at the top of the home page the first thing you'll ask is how you'd like to create the list and you can see that you can start from blank or you can base it on an existing list and if i choose from blank here the next step is to give it a name description icon and color but my first tip is for those of you who want to import excel spreadsheets and turn them into lists this is a great feature if you want to get your data out of excel and into sharepoint when you create a list from excel microsoft list will read the tables in the spreadsheet and allow you to choose one of them to import this means that you must make sure that your spreadsheet has tables defined before you create the list defining tables is done in excel and it's as easy as selecting the data and then pressing the insert table button on the ribbon here you can also name your table in the table design tab and this will make it easier to find when you're doing the import into lists note that excel doesn't take spaces in the table name so i'll use underscores here when you create the list you choose from excel and then you're asked to either browse for a spreadsheet that's already in your onedrive or you can upload one from your computer i'm going to upload this one from mine when i do that it loads the tables it finds in the spreadsheet and then it presents them to you to choose from in the drop down at the top here i can choose a table i just created called lists import you can see below here that it's found these columns in the table and then it also shows me what types of column lists is going to create to store that data you can change the selection if you think you need to by dropping down the menu and choosing something else for example you could turn a single line of text column into a multiple line of text you can also choose not to import the column at all by choosing this option also notice here that i have a message saying title is a required field and can't be empty i included this as another tip because it was something that i had to figure out and it happens because sharepoint can't have a title column where the item doesn't have data the reason i'm seeing this warning is because one of the rows in my spreadsheet is empty so all i need to do is cancel the import go back to the spreadsheet delete any empty rows from the table save it and then start the import again now i've done that you can see that when i start the import process the message is gone and i can press next on the wizard to complete the list creation so once that's done the next step is to name the list and give it a color and an icon and my next tip is to do with where to keep your lists when you get to this stage you can choose to save it to my list which is the default or to an existing sharepoint site so what's the difference adding a list to my list means that the list is actually added to your onedrive and only you can see it adding it to a sharepoint site means that everyone who has access to the site has access to your list so if you want your list to be private save it to my lists and if you want to share it with your team save it to a site you can always share the list after you've created it so if you're not sure what to do then create it in my lists one of the great new features of lists is the templates these are pre-built lists that you can use as they are or customize so they are how you want them to be when you choose one of the templates it creates a set of columns for you formats them nicely and creates a list of views for you to use as well for example if i choose this one here the issue tracker it takes me to a list of all the templates and i can see how the list will look on the right hand side here i can also skip through all the different templates and get a preview for what they'll look like as well when you find one that you want to use you choose the template and that will take you to a page where you can name the list choose the details and choose where to save it once you've done that the list is ready to go you can change any of the existing columns and add new ones if you want to you can hide a column or format what it will look like the template list also has views for me that i can use to filter sort or group the list this view groups the list by priority and it also gives you ideas on how to format the list and shows you how to do it for example in this list i have a choice column formatted using the new pill icons and i can see how the style has been created and which icons it uses so using a template is a way to speed up the process of getting your list up and running and give you some great ideas on how to make your list look awesome so there your three tips on creating new lists with microsoft lists thanks for watching and i'll see you next time [Music] you

Channel: Collaboration Coach

Views: 34,343

Rating: 4.9601989 out of 5

Keywords: microsoft, ms, office, 365, collaboration, coach, tutorial, tips, microsoft lists, collaboration coach, create a list from excel, save to my lists or sharepoint site, where to save lists, create a new list, using templates, formatting lists

Id: _s_lofU3iZU

Length: 5min 57sec (357 seconds)

Published: Thu Aug 27 2020