How to Create a List in SharePoint

SharePoint lists provide a powerful way to structure and share data, eliminating the need for a separate database or third-party application.

This guide walks you through how to create a SharePoint list using both the modern interface and classic options, while also covering best practices to maximize usability and governance.

1. Navigate to Your SharePoint Site

Start by accessing the site where you want the list to live:

1. Go to https://yourdomain.sharepoint.com or launch SharePoint via the Microsoft 365 app launcher
2. Click on the appropriate site (e.g., “Marketing,” “Finance,” or “Project Phoenix”).
3. You must have at least Contribute permissions to create a list.

2. Create a New List (Modern Experience)

SharePoint’s modern experience makes list creation fast and intuitive.

Option 1: Create from Scratch

1. From the site’s home page, click “New” > “List.”
2. Choose “Blank list.”
3. Name your list and optionally:
   • Add a description
   • Choose whether to display in the site’s navigation
4. Click “Create.”

Option 2: Create from a Template

1. Select “From template” instead of blank list.
2. Choose a built-in template like:
   • Issue Tracker
   • Event Itinerary
   • Asset Manager
3. Click Use template and customize as needed.

Option 3: Create from an Existing List or Excel

• You can also import a list from an Excel file or use an existing list as a structure blueprint, useful for consistency across teams.

3. Add Columns and Customize the List

Once the list is created:

1. Click “+ Add column” to define custom fields:
   • Text
   • Choice (dropdowns)
   • Number, Date, Currency
   • Person or Group
   • Yes/No
   • Lookup (from another list)
2. Click “Column settings” to rename, reorder, or enforce validation rules.
3. Use views to filter, sort, or group your list data based on team needs:
   • Grid view
   • Calendar view
   • Kanban (Board) view with Microsoft Lists

4. Add and Manage Items

• Click “New” to add individual list entries
• Use “Edit in grid view” for spreadsheet-style editing
• Bulk import data by copying from Excel or pasting into the grid

All items are auto-saved and version-controlled by default, no need to manually hit “Save” each time.

5. Automate and Integrate

Once your list is set up, enhance it with:

• Power Automate flows (e.g., alerts, approvals, reminders)
• Power Apps to build custom front-ends for mobile or form-based entry
• Lookups and connected lists for relational data
• Permissions to control who can view, edit, or manage list data

Use JSON formatting for advanced column customization and visual cues (e.g., highlight overdue items).

6. Manage List Settings

Click the gear icon > List settings for advanced options:

• Enable versioning or content approval
• Set item-level permissions
• Add calculated or indexed columns
• Manage list workflows and integrations

This is especially useful for IT teams managing complex SharePoint deployments or data-sensitive workflows.

Creating a list in SharePoint is more than just setting up a table; it’s a low-code way to organize information, collaborate in real-time, and build lightweight business applications. With just a few clicks, teams can replace spreadsheets, simplify workflows, and increase visibility across projects and departments.