> ## Content Index
> Fetch the complete content index at: https://todayfixtech.com/llms.txt
> Use this file to discover other available public pages before exploring further.

# Microsoft Lists guide: create, customize & share first list
- URL: https://todayfixtech.com/microsoft-lists-create-list/
- Published: 2026-10-31T00:14:35.000Z
- Updated: 2026-10-31T00:14:35.000Z
- Author: Md Sojib Mia
- Tags: Microsoft

[You have Microsoft 365](https://todayfixtech.com/microsoft-365-applications-overview/) and need a simple, shared list for tasks, assets, issues, or inventory. Microsoft Lists gives you a structured place to store that data, with templates, column types, views, conditional formatting and basic sharing. This guide shows how to open Lists from the right app, create a list from a template or from scratch, add columns and items, save views, share safely, and decide when Lists is the right tool instead of Excel or a full SharePoint site.

## How do I open Microsoft Lists right now?

- You need a Microsoft 365 account with access to Lists (most business and enterprise licenses include it).
- If you will share inside a Team or site, you need membership or owner rights on that Team or SharePoint site.
- Mobile: install the Microsoft Lists app and sign in with your Microsoft 365 account.

Open Lists now (pick one based on purpose):

1. Web (quick solo list)

```text
lists.microsoft.com
```

Open in browser

1. Teams (team work tied to a channel)
2. Open Teams, go to the channel where the list belongs, click + to add a tab, choose Lists or add an existing list.
3. SharePoint site (site-hosted, broader access)
4. Open the SharePoint site, click New > List or open the site’s Lists app.
5. Mobile app (view and edit on the go)
6. Open the Microsoft Lists app and sign in.

When to use each entry point:

- Use the web when you want a list you control personally or when you’re experimenting.
- Use Teams when the list belongs to a channel and collaborators use Teams every day.
- Use a SharePoint-hosted list when the list should live with site-level permissions, governance and related site content.
- Use the mobile app for quick updates and reviews while away from your desk.

![A hand holding a smartphone that displays the Microsoft Lists mobile app screen with a list open.](https://tse1.mm.bing.net/th?q=smartphone%20showing%20Microsoft%20Lists%20mobile%20app%20photo&w=624&h=352&c=7)

## Should I use a template or start from a blank list?

Templates save time because they include relevant columns, example views and sometimes formatting. For a beginner, try these templates first:

- Issue tracker — columns for Title, Status, Priority, Assigned To, and Comments. Good for bugs, customer issues, or help tickets.
- Asset manager — tracks asset tag, owner, purchase date, warranty and condition. Useful for equipment or IT inventory.
- Event itinerary — has date/time fields, location and attendees. Useful for small events or schedules.

Rule of thumb: pick a template when it matches your purpose closely. Start from blank when your needs are unusual or you prefer to design columns and views from scratch. If a template is close but not exact, edit or remove columns and save a new view; templates are a starting point, not a restriction.

## Create your first list step by step

### Prerequisites

- A Microsoft 365 account that can use Lists.
- Membership or owner rights if you’re creating the list inside a Team or SharePoint site.

### Steps

1. Create from a template.

```text
1. Open lists.microsoft.com
2. Click New list
3. Choose Issue tracker (or another template)
4. Enter a name and choose location (My lists, Team site, or a channel)
5. Click Create
```

Create from Template

Expected result: a new list with prebuilt columns appears.

1. Create from blank.

```text
1. Open lists.microsoft.com
2. Click New list
3. Choose Blank list
4. Enter a name and choose location
5. Click Create
```

Create from Blank

Expected result: an empty list with default Title column appears.

1. Add columns (one action per column).
2. Click + Add column and pick a type.
3. Create a Text column called `Task`.
4. Create a Choice column called `Status` and add choices: Not started, In progress, Blocked, Done.
5. Create a Person column called `Owner`.
6. Create a Date column called `Due date`.
7. Create a Number column called `Estimate hours`.

Expected result: new columns appear in the list header and are available when adding items.

1. Add items (one item at a time).
2. Click New.
3. Fill `Task`, pick `Status`, choose `Owner`, set `Due date`, enter `Estimate hours`.
4. Click Save.

Expected result: the row appears in the list with entered values.

Granting broad edit access lets people change items, columns and views. Only give edit rights to people who need them.

1. Switch and save a view.
2. Click All items at the top right of the list.
3. Choose a view type (List, Compact, Gallery) or create a new view.
4. Save a custom view.
5. Apply filters or groupings (for example, filter Status is not Done and group by Owner).
6. Click Save view > Save as and give it a name like `Active tasks by owner`.

Expected result: the view is available in the view menu for quick access.

### Completion

You’re done when the list shows the columns you added, at least one saved item appears, and the custom view name appears in the view menu.

![Close shot of hands on a laptop keyboard as someone creates a new list item in Microsoft Lists.](https://tse1.mm.bing.net/th?q=hands%20typing%20to%20create%20a%20list%20in%20Microsoft%20Lists%20photo&w=624&h=352&c=7)

## How do I share the list and control who can edit it?

Lists inherit permissions from the hosting location: My lists (your personal) are private; [lists in a SharePoint](https://todayfixtech.com/share-files-microsoft-365/) site or Teams channel follow that site or channel permissions. You can also share links with specific rights.

1. Open the list, click Share.
2. Choose: Anyone with the link (may be disabled by tenant), People in your organization, Specific people.
3. Set the permission level: Can view or Can edit.

Granting edit access lets people change items, columns and views. Only give edit when collaborators need to add or change items.

Checklist to share safely:

- If work belongs to a Team, add the list as a tab in the channel so channel membership controls access.
- For sensitive data, use Specific people and verify recipients.
- Prefer view-only links for broad audiences and edit only to small collaborator groups.
- If someone needs full control, consider making them a site owner on the SharePoint site rather than sharing an edit link for a single list.

If you need item-level permissions or custom groups, manage access in the SharePoint site permissions settings; that requires site owner rights.

## What useful customizations should I learn next?

Start with these customizations to make your list more useful.

1. Conditional formatting (highlight items visually).
2. Open view settings, choose Format current view > Configure rules.
3. Create a rule: when `Status` is `Blocked`, set row background to red.

Expected result: blocked items stand out in the view.

1. Column formatting basics.
2. Click the column header, choose Column settings > Format this column.
3. Use simple presets (status pills) or paste a JSON snippet if you have one.

Column formatting changes only appearance; it does not alter data.

1. Creating simple automations with Rules.
2. Click Automate > Create a rule.
3. Choose a trigger like When an item changes, then select Send email to `Owner` if `Status` equals `Blocked`.
4. Power Automate templates (for more complex flows).
5. Click Automate > Power Automate > Create a flow from a template.
6. Pick templates like Send an email when a new item is created, then configure recipients.

Example rule: Notify owner when status becomes Blocked.

1. Automate > Create a rule.
2. Trigger: Item changes.
3. Condition: If `Status` equals `Blocked`.
4. Action: Send an email to `Owner` with the item link.

Expected result: Owners receive a notification when their task is blocked and can act quickly.

## I'm not sure when to use Lists instead of Excel or SharePoint — what are the boundaries?

[Use Microsoft Lists when](https://todayfixtech.com/microsoft-365-for-beginners/) you need structured, repeatable data with multi-user tracking, consistent column types, views and simple rules. Use Excel when you need flexible calculations, ad-hoc analysis or complex formulas. Use a SharePoint site when the list should be part of an intranet with advanced permissions, pages, document libraries and site-level governance.

Practical scenarios:

- Use Lists: tracking issues, assets, equipment checkouts, lightweight project tasks shared by a team.
- Use Excel: one-off data cleanup, heavy numerical modeling, pivot table analysis before you import results back into Lists.
- Use SharePoint site lists: when the list must be governed with site-level policies, custom site permissions or integrated with document libraries.

Governance tips:

- Name lists clearly: start names with the team or purpose, e.g., `HR-Equipment-Inventory`.
- Create and reuse templates for repeated list types so structure stays consistent across teams.
- Enable versioning on the SharePoint site list if you need to restore previous item states.
- Regularly review who has edit access and archive old lists rather than keeping unused ones indefinitely.

How you know it worked: team members can find the list in the expected place (Team tab or SharePoint site), you can add and edit items with appropriate permissions, saved views show the filtered or grouped results you created, and rules or automations trigger notifications when conditions are met.

## Conclusion

Now you can open Lists from the browser, Teams, SharePoint or the mobile app; create a list from a template or from scratch; add common columns and save views; and share with appropriate permissions. Next, pick one real use case—your team’s task tracker or an asset register—create that first list, add one conditional formatting rule and a basic automation, and ask one collaborator to confirm they can view and, if intended, edit. That quick feedback ensures the list fits your workflow.

## Frequently Asked Questions

### Can I export a Microsoft List to Excel?

Yes. Open the list, click Export to Excel. That downloads a query file with a snapshot of the data; the exported file does not stay linked unless you set up a sync or a Power Automate flow.

### Will changes I make in a Teams tab list reflect in SharePoint?

Yes. A list added to a Teams channel is stored on the underlying SharePoint site for that Team. Changes in Teams update the SharePoint-hosted list and vice versa.