Skip to main content

How to create sharepoint list using excel

List is important part of SharePoint. Feature to create list from spreadsheet is very useful. User can create the list using spreadsheet/excel using add list option in site content.

Create a SharePoint List from Excel:

1. Log in to your tenant and move to the site.

2. Now navigate to the Site content and click on the New option and select List.

SharePoint List
 
3. Select the From Excel option and Upload file or you can choose file from site also.

SharePoint List
 

4. File you uploaded, if it's not in the table format, you need to do that. 
  •  Click on the link Go to file in this example it is Expense Info.xlsx, present above to the Refresh option.
  •  Select the cells and Click on the Format as table.
  •  Refresh it.

SharePoint List

5. Once you refresh it, Give the name to the list and check the column type, if it's not appropriate you can change this from column type drop down. Now click on Create.

SharePoint List

6. Now your list is created.

SharePoint List

Note: In this example I used date in one column but when I imported that excel, on SharePoint,  column type is showing as single line of text and in that column there is no option available to change column type to date but when I created list. In list it show column type as  the date type. I will update you on this soon.

Thanks.

 


Comments

Popular posts from this blog

How to create list from template in sharepoint

In this article, we are going to learn how to create a list from list template or using(.stp) file or we can say create list from existing list. Once you save the list as a template, It appears into List template option under the web designer gallery on site setting page. Steps to create list from list template: 1 Move to the site setting section where you have saved the list template. 2. When you click on the List templates, you will redirect to the List template gallery and from the list template gallery. 3. Now click on the File in ribbon and click on the upload document. 4. Browse the location where your list template is downloaded. I am uploading the template of an address list. 5.  After browsing the template, now you can give the name what you want to give to the list template and click on save. 6. Now the list template file appears into the list template gallery. Now click on the gear  icon and click on the Add an app. 7. On clicking add an app,

Content editor web part missing in SharePoint/Modern SharePoint.

Media and content editor web part missing in SharePoint online. At Some Point, you need to add content editor web part into the modern site but the content editor web part did not appear on the page, to appear content editor web part on page you need to follow the below steps. 1 Log in as the SharePoint Global Administrator or SharePoint Administrator. 2.  Log in and navigate to your site collection ("https://xyz.sharepoint.com") and under the site settings activate the below features.   Site settings – site features – SharePoint Server Publishing .   Site Settings – Site Actions – Manage site features- SharePoint Server Publishing Infrastructure.                For this, you also need to enable Custom site scripts on your site collection(But In Modern SharePoint Its not recommended to enabling custom site scripting)  For this go to the  SharePoint Admin center – Settings -  Classic settings page (option mentioned on page)- Scroll the page you found an optio

SharePoint Designer workflow error : server side activities have been updated. you need to restart sharepoint designer to use the updated version of activities.

While working with SharePoint designer at the time of creating custom forms and workflows, on editing the workflow or creating new one, error occurred and stated as : "server side activities have been updated. you need to restart sharepoint designer to use the updated version of activities." to resolve this error follow steps provided below. Before moving on the steps mentioned below some time it's needed to clear the cache. First clear the cache from locations mentioned below: %APPDATA%\Microsoft\Web Server Extensions\Cache %APPDATA%\Microsoft\SharePoint Designer\ProxyAssemblyCache %USERPROFILE%\AppData\Local\Microsoft\WebsiteCache %APPDATA%\Microsoft\SharePoint Designer Steps to resolve this problem: To resolve this issue you need to update the SharePoint designer and to do so you have to follow this two steps : 1. Check whether the Microsoft SharePoint 2013 service pack 1 is installed or not in your system.If not Please download it and inst