How to create a list from excel in SharePoint Online

hello and welcome to the channel my name is BJ and I'm a Microsoft MVP specialized in SharePoint in this video we are going to discuss how we can create a list from Excel in SharePoint Online this is a requirement that comes from most of the business users of the site owners that can be clear a list from a excellent SharePoint Online previously there is a concept of I mean it is still there where you can use import spreadsheet option to create a list from an excel but that requires your ActiveX control in the browser and most importantly that is not a very user-friendly way to do that in the SharePoint Online modern experience Microsoft come up with a feature where you can create a list from and from an excel and that's this very convenient to create it and another important thing is that this will work on the SharePoint Online modern explains as of now this node is not possible on the on the SharePoint Online classic sites so now let us see we will see how we can create a create a list so we will prepare the Excel and then I will show you the steps so we will take all these things so now let me open my serpent online site okay if you are interested for serpent trainings then I have a serpent development training course where you can learn sharepoint online sharepoint 20:19 from beginner to advanced level so you can check out this I will put the put the link in the video description you can have a look at this this is the entire content on this now what we will do is first we will create our Excel and then we will come here and upload and then we will see that so the first step if you'll see here I have an excel file here I have given the name as employees so if I will just open it you can see here I have put employee name address experience a little like this and this this to our single line of text and the our numbers now what's the first thing you have to do is he will select this so whatever this and there are a Recor you want to move then you can select this and you can see here under this home tab this is format as table is there so you can select anything from here the most important thing here is you can select my table has headers if you have actually headers here for example in this case it will see it is employee name and this experience salary these things are there so that is my header if you not put header then what will happen is when you will well uncheck it then it will take out column 1 column 2 column 3 like this and it will ignore the first row it will treat as a row or as a content so since I want my first row should be the header so I select it and then click on OK so once you click on OK you can see here whatever the table format you have selected it comes here like this so it becomes a table now another thing you can do is you can see here this is a table name option you can select it or you can change it actually for example in this case I will put let's say EMP so my table name now becomes EMP so I will just save it and I will close it so you can see here now our excel is will be having the format a table now I will open my serpent online chat and then you can go to the SharePoint documents document library or the shared document so it is basically the documents I'll open this and we can upload that so I will just hope we can just drag and drop or you can use the upload button here so upload files and then I will go to the desktop I will select my file and you can simply drag and drop all shake and do that so I have uploaded it over here now this is the place where you can upload your excel file and then it will come in the next step I'll show you now next thing is now we will see how we can create the list so our excel part is over now so what you can do here is you can go to the site content page first of all this option is available on the site content page though from the home page if L go to the home page then now you have new option we have new list and here you can create the list but this way you cannot select the excel file so what you have to do is you have to go to the site content page and from here you can see here click new and then list so when you will create a click on that you have three option you can create a brand new custom list you can see here and the next one is from an existing list and then third one is from an Excel from an existing list I have created this in another in a separate video I'll put the link in the description as well so you can have a look at that in the free in the other video so what he will do here is can select from Excel and you can provide a name here for example I will give the name as employees you can optionally select so in side navigation so if you'll select instan it will come in the left navigation here you have two option either you can upload from your local system so you can click on this upload file button or you can see here we have the employee dot XLS SX the excel file that we have upload to our document library so this is the place where when you upload and it will appear here now for this particular example what I will do is I'll upload it so I'll click on this and then I'll select this file from our local system you can see here it is showing up loading loading the table and you can see here it has two options select a table from this side we have one table if your excel contains more table then you will have all this table will be populated here and you can select the particular table now next it is quite important that you might require to change the data type so you can see here before that the employee name address experience and salary all these columns are appearing with your data whatever you have selected but you have also the option where you can actually change the data type you can see here I can select the Singh instead of single and update I can select the address as multi line of text and then you can see your number this is of number type and then you can see here even the title field also you can select it now next click on create and then it will take just a couple of seconds and you can see here your employee list got created and you can see here all this data are here this one more thing that we did here is you can see we have formatted that table but might be there will be scenarios when you will not have a formatting option that means in the Excel might not be formatted as a table then what will happen is it will show you four steps basically where you can do the same things in the online excel and you can format it and then it will come back and it will create the list here so for that what to show this what I'll do is I will create one more excel and then I'll show you how it is so for that what I did is I have the X I created one more excel file products and it has you can see here to record and then this is our header now what I will do is I will just say without format as a table option so I will just close it and then I will open my SharePoint site we will go to the same place that means I'll go to the site content page here you can see and from here I will click on new and you can see here new list I'll select from Excel and here I will select products and then I'll upload the file you can see here a select top products well which is not formatted and you can see here now it is showing that he can open the Excel document and then you can select the cells and then you can do the format a stable and then you can come back and you have the option here so just click on this Open button you can see here it is opening in online Excel so I will select the sale and their their data and then I will click on format as table you can see here I will select anything my table has header I'll click on OK so once you click on OK then you can come here and you can just refresh it so the this this file actually you don't need to even save it this will be Auto said we can just close it and then you can come here and you can just refresh it so once you refresh it you can see here now it is coming product name and model number you have the option to select the table if you have more and then this is the list name everything is same as it is and then you can click on create and it will create the list immediately you can see here it created the list with the title model number and this is the product so I hope you liked the video and if you are if you want to learn more things then you can go to our websites speak ID store comments a SharePoint and this is a site for us you are and these are tutor and else you can check it out LinkedIn and Facebook pages as well so thank you and do subscribe to our channel because you will get a lot of free videos on SharePoint office 365 as your SPF ax power ups power bi flow so all these technology videos that we are uploading here and really you will get all this videos regularly on this so thank you and have a nice day

Channel: EnjoySharePoint

Views: 3,112

Rating: 4.8333335 out of 5

Keywords: SharePoint 2013, SharePoint 2016, SharePoint Online, Office 365, SharePoint 2019, SharePointTutorial, sharepoint list, create list from excel sharepoint, create list from excel sharepoint online, create list from excel in sharepoint online, how to create a list from excel in sharepoint online, sharepoint online create a list from excel, sharepoint online create list from excel file, sharepoint online create list from excel spreadsheet, sharepoint moden site create list from excel

Id: Tblz2CINw44

Length: 10min 9sec (609 seconds)

Published: Tue Jun 30 2020