{"id":48957,"date":"2023-05-18T11:13:20","date_gmt":"2023-05-18T19:13:20","guid":{"rendered":"https:\/\/cirahub.com\/?p=48957"},"modified":"2023-06-01T03:34:07","modified_gmt":"2023-06-01T11:34:07","slug":"create-a-sharepoint-list","status":"publish","type":"post","link":"https:\/\/cirahub.com\/fr\/blog\/create-a-sharepoint-list\/","title":{"rendered":"How to Create a SharePoint List: Step-by-Step Instructions!"},"content":{"rendered":"<p>Are you looking to create a list on SharePoint? This blog post will outline how to create a SharePoint list. We&rsquo;ll cover everything from creating a SharePoint site to adding columns, customizing the list view, and managing list items. By the end of this post, you&rsquo;ll have all the knowledge you need to create your own SharePoint list like a pro.<\/p>\n<h2><span class=\"ez-toc-section\" id=\"What_is_a_SharePoint_List_and_Why_Use_One\"><\/span>What is a SharePoint List, and Why Use One?<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p><a href=\"https:\/\/cirahub.com\/blog\/what-is-sharepoint-and-what-is-it-used-for\/\"><strong>SharePoint is an essential tool for organizing and managing data<\/strong><\/a>, and a SharePoint list is a customizable way to store and manage information in organizations. Improved collaboration, workflow automation, and streamlined data management are just some benefits of using SharePoint lists.<\/p>\n<h2><span class=\"ez-toc-section\" id=\"How_to_Create_a_SharePoint_List\"><\/span>How to Create a SharePoint List<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>Creating a SharePoint list is a simple process that can be accomplished in just a few steps. Following these steps, you can create a customizable way to store and manage information.<\/p>\n<p>Once your SharePoint list is ready, you can add and manage items while collaborating with team members. Follow the steps below to create your new list.<\/p>\n<ol>\n<li aria-level=\"1\">Navigate to the \u00ab\u00a0Site Contents\u00a0\u00bb page and click \u00ab\u00a0+ New\u00a0\u00bb and then \u201cList\u201d from the drop-down menu.<\/li>\n<li aria-level=\"1\">Choose the type of list you want to create. SharePoint gives you access to different templates to choose from (more about this below). You can create a \u201cBlank\u201d list, Import a list from Microsoft Excel (more below) or <strong><a href=\"https:\/\/support.microsoft.com\/en-us\/office\/create-a-new-list-based-on-the-columns-in-another-list-49666e8c-8c48-414f-8e5e-dc0e232acd27\">create a new list based on the columns in another list<\/a><\/strong>.<\/li>\n<li aria-level=\"1\">Enter a name for your new list and click \u201cCreate.\u201d<\/li>\n<\/ol>\n<p>That is it! You just created a SharePoint list.<\/p>\n<p>But if a list has become irrelevant, check out the <strong><a href=\"https:\/\/cirahub.com\/fr\/blog\/delete-sharepoint-list\/\">easy steps to follow to delete a SharePoint list<\/a><\/strong>.<\/p>\n<p>Now, let\u2019s share some expert tips with you.<\/p>\n<p><b>SharePoint list templates:<\/b> SharePoint provides various templates, including custom, task, and calendar lists.<\/p>\n<p>Each template has its own features and functionality that cater to specific data types and purposes. Therefore, it&rsquo;s crucial to consider the type of data you want to store in your list and its purpose before selecting a list type.<\/p>\n<p>Custom lists are versatile and can be used for storing various data types, while task lists are suitable for tracking team projects and deadlines. Similarly, calendar lists can be used to track events and appointments.<\/p>\n<p><b>Naming Tips:<\/b> Giving your SharePoint list a proper name is crucial for easy identification and access.<\/p>\n<p>A descriptive and concise name can help to quickly differentiate it from other lists on your site or organization. Avoid using special characters or spaces in the list name, which can cause issues with URLs and links.<\/p>\n<p>Also, consider using a consistent naming convention for all your lists so that you can quickly recognize them.<\/p>\n<h2><span class=\"ez-toc-section\" id=\"Work_With_Columns_in_SharePoint_Lists\"><\/span>Work With Columns in SharePoint Lists<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>When creating SharePoint lists, using the right column type is crucial. Every column within a SharePoint list represents specific information, such as text, numbers, or dates. Selecting the most appropriate column type based on your data needs is essential to ensure that your list is understandable and user-friendly.<\/p>\n<h2><span class=\"ez-toc-section\" id=\"Customize_Your_List_View\"><\/span>Customize Your List View<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>Customizing the list view in SharePoint allows you to display only the columns and data most relevant to your needs. You can add or remove columns from the list view by going into the settings and selecting \u00ab\u00a0List Settings\u00a0\u00bb and then \u00ab\u00a0Columns.\u00a0\u00bb<\/p>\n<p>You can also choose whether to display items as a list or in a grid format. Customizing your list view can enhance your productivity by enabling you to quickly access and analyze the information you need, depending on your requirements.<\/p>\n<p>Additionally, filtering and sorting capabilities offer flexibility for displaying specific data. Once you&rsquo;ve customized your list view, you can save it as a new view or set it as the default view for all your list users.<\/p>\n<h2><span class=\"ez-toc-section\" id=\"How_to_Add_New_Items_to_Your_List\"><\/span>How to Add New Items to Your List<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>You can add new items to your SharePoint list in the following steps:<\/p>\n<ul>\n<li aria-level=\"1\">Click the \u00ab\u00a0New Item\u00a0\u00bb button to open a form and fill in the item&rsquo;s details.<\/li>\n<\/ul>\n<p><b>Note:<\/b> It&rsquo;s essential to make sure you fill in all required fields and any additional information that may be helpful, such as attaching files or images. Once you&rsquo;ve filled in all the necessary information, click \u00ab\u00a0Save\u00a0\u00bb to add the item to your list.<\/p>\n<p>Adding new items isn&rsquo;t just about filling in forms, though. It&rsquo;s about maximizing the benefits of SharePoint lists. Using different column types like \u201cChoice\u201d or \u201cDate\/Time\u201d, you can capture specific information to help you organize your data more effectively.<\/p>\n<h2><span class=\"ez-toc-section\" id=\"How_to_export_data_from_an_Excel_table_to_a_SharePoint_list\"><\/span>How to export data from an Excel table to a SharePoint list<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>Exporting data from an Excel spreadsheet to a SharePoint list can save time for managing data across multiple platforms.<\/p>\n<p>You can create a list based on an existing Excel spreadsheet in the following steps:<\/p>\n<ol>\n<li aria-level=\"1\">From the Lists app in Microsoft 365, select \u201c+New list,\u201d or from your site&rsquo;s home page, select \u201c+ New,\u201d then \u201cList.\u201d<\/li>\n<li aria-level=\"1\">On the Create a List page, click \u201cFrom Excel.\u201d<\/li>\n<li aria-level=\"1\">Click \u201cUpload file\u201d to choose a file on the system, or click a file already on your site.<\/li>\n<li aria-level=\"1\">Enter a name for your list<\/li>\n<li aria-level=\"1\">Click \u201cCreate.\u201d<\/li>\n<\/ol>\n<h2><span class=\"ez-toc-section\" id=\"How_Many_Items_Can_You_Add_to_a_SharePoint_List\"><\/span>How Many Items Can You Add to a SharePoint List?<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>The maximum number of items that can be added to a SharePoint list varies depending on the version and licensing. In SharePoint Online, the default limit is 30 million items per list. However, keeping the number of items in your list below 5,000 is recommended for optimal performance. If you need to exceed this limit, consider additional licensing or partitioning large lists into smaller ones can help increase the item limit.<\/p>\n<h2><span class=\"ez-toc-section\" id=\"What_is_the_Difference_Between_a_SharePoint_Site_and_List\"><\/span>What is the Difference Between a SharePoint Site and List?<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>A <strong><a href=\"https:\/\/cirahub.com\/fr\/blog\/how-to-create-a-sharepoint-site\/\">SharePoint site<\/a><\/strong> is a comprehensive collection of pages, lists, libraries, and apps that work together towards a common objective. On the other hand, a list is a container for related data items.<\/p>\n<p>Sites provide an overarching structure for all the information in your organization, whereas lists are critical tools for managing specific types of content within those sites. By utilizing sites and lists in tandem effectively, you can create custom solutions tailored to fit the needs of your company or team.<\/p>\n<p>Recommended reading: <strong><a href=\"https:\/\/cirahub.com\/fr\/blog\/sharepoint-team-site-vs-communication-site\/\">What\u2019s the difference between a team site and a communication site in SharePoint?<\/a><\/strong><\/p>\n<h2><span class=\"ez-toc-section\" id=\"Conclusion\"><\/span>Conclusion<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>Creating a SharePoint list can seem daunting, but with the easy-to-follow steps above, you&rsquo;ll be up and running quickly. Whether creating a new site or just adding to an existing one, our guide is handy to take you through every step of the process.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Are you looking to create a list on SharePoint? This blog post will outline how to create a SharePoint list. We&rsquo;ll cover everything from creating a SharePoint site to adding columns, customizing the list view, and managing list items. By the end of this post, you&rsquo;ll have all the knowledge you need to create your [&hellip;]<\/p>\n","protected":false},"author":10,"featured_media":48964,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"page-cirahub.php","format":"standard","meta":{"_et_pb_use_builder":"","_et_pb_old_content":"","_et_gb_content_width":"","footnotes":""},"categories":[39],"tags":[172,287],"ppma_author":[373],"class_list":["post-48957","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-blog","tag-sharepoint","tag-sharepoint-list"],"authors":[{"term_id":373,"user_id":10,"is_guest":0,"slug":"ikimi","display_name":"iog@ciraapps.com","avatar_url":"https:\/\/secure.gravatar.com\/avatar\/a53a3bfa22a6e4ed6682d08e5c634e2c20be9dfba3e712a07cdbd26d90d24e78?s=96&d=mm&r=g","0":null,"1":"","2":"","3":"","4":"","5":"","6":"","7":"","8":""}],"_links":{"self":[{"href":"https:\/\/cirahub.com\/fr\/wp-json\/wp\/v2\/posts\/48957","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/cirahub.com\/fr\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/cirahub.com\/fr\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/cirahub.com\/fr\/wp-json\/wp\/v2\/users\/10"}],"replies":[{"embeddable":true,"href":"https:\/\/cirahub.com\/fr\/wp-json\/wp\/v2\/comments?post=48957"}],"version-history":[{"count":10,"href":"https:\/\/cirahub.com\/fr\/wp-json\/wp\/v2\/posts\/48957\/revisions"}],"predecessor-version":[{"id":49312,"href":"https:\/\/cirahub.com\/fr\/wp-json\/wp\/v2\/posts\/48957\/revisions\/49312"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/cirahub.com\/fr\/wp-json\/wp\/v2\/media\/48964"}],"wp:attachment":[{"href":"https:\/\/cirahub.com\/fr\/wp-json\/wp\/v2\/media?parent=48957"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/cirahub.com\/fr\/wp-json\/wp\/v2\/categories?post=48957"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/cirahub.com\/fr\/wp-json\/wp\/v2\/tags?post=48957"},{"taxonomy":"author","embeddable":true,"href":"https:\/\/cirahub.com\/fr\/wp-json\/wp\/v2\/ppma_author?post=48957"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}