How to Create a SharePoint List (2026)
A SharePoint list is a structured table — anything from a contact directory to an issue tracker to an asset register. You can build one from scratch, start with a template, or import an existing Excel file. Here’s how to do all three.
Step 1: Open the Site and Start a New List
- Go to the SharePoint site that should own the list.
- On the top bar, click + New > List.
The list-creation panel opens with four starting points.
Step 2: Pick a Starting Point
Blank list
Start empty and add columns one at a time. Best when your data structure is unique or simple.
From Excel
Upload an Excel file (or pick one already in the site). SharePoint reads the table, guesses each column’s data type, and lets you adjust before importing.
- The Excel data must be formatted as a table (
Ctrl+Tin Excel) — not just rows of values. - You’ll see a preview where you can correct each column’s data type (text, number, date, choice).
From existing list
Copy the structure of any list you have access to — same columns, no data. Useful when you’re standing up a “v2” or duplicating a tracker across departments.
Template
Pick from SharePoint’s built-in templates — Issue tracker, Asset manager, Employee onboarding, Travel requests, Event itinerary, Work progress tracker, and more. Each comes with pre-built columns and a tuned view.
Step 3: Name and Configure the List
- Type a list name — keep it short; it becomes the URL slug.
- Add a description so others understand the purpose.
- Decide whether to Show in site navigation (recommended — leaves a left-nav link).
- Click Create.
SharePoint provisions the list in a few seconds and opens it.
Step 4: Add Columns
If you started blank or want to extend a template:
- Click + Add column at the far right of the header row.
- Pick a column type:
- Text — short answers
- Number / Currency
- Date and time
- Choice — drop-down with preset options
- Person — picks a user from your org
- Yes/No — checkbox
- Hyperlink, Image, Lookup, Calculated
- Name the column, configure options, and click Save.
Step 5: Add Items
- Click + New at the top of the list to add a row using the side form.
- Or click Edit in grid view to type into the rows directly, Excel-style.
- Paste rows of data from Excel or a spreadsheet straight into grid view to bulk-add.
Optional: Save a List View
Different teams want to see different slices.
- Filter and sort the list however you want.
- Click the view selector (top right) > Save view as.
- Name the view and decide whether to make it public (visible to everyone) or private.
Switch between views from the same dropdown.
Troubleshooting
”+ New” is missing or grayed out
You only have Read permission on the site. Ask the owner to add you to the Members group or grant Contribute access.
Excel import fails
The data isn’t formatted as a table. Open the Excel file, select your data, press Ctrl+T, confirm “My table has headers,” save, and try the import again.
A column type can’t be changed
Once a column has data, SharePoint locks the type. To change it, create a new column with the correct type, copy the values over, and delete the old column.
Quick Reference
| Source | When to use |
|---|---|
| Blank list | Unique structure, simple needs |
| From Excel | Migrating an existing spreadsheet |
| From existing list | Copying a proven structure |
| Template | Standard use cases — issues, assets, onboarding |
Related SharePoint guides: How to export a SharePoint list to Excel · How to create a SharePoint site · How to create a SharePoint folder · How to create a SharePoint page · How to sync SharePoint with OneDrive
Ready to automate your busywork?
Carly schedules, researches, and briefs you—so you can focus on what matters.
Get Carly Today →Or explore our free tools
