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 · OneDrive vs SharePoint
Ready to automate your busywork?
Carly schedules, researches, and briefs you—so you can focus on what matters.
See what people say
"Before Carly, I relied on a Calendly link, but the whole process felt impersonal and not very professional. Carly changed that by handling all the back-and-forth, so I'm no longer stuck in endless email threads trying to line up schedules.
Now Carly reaches out to candidates, shares my real-time availability, lets them pick a slot, then sends a Zoom link and drops it straight into my calendar. She sends reminders to both of us before each call, which has significantly reduced no-shows and last-minute confusion.
On top of scheduling, Carly acts like a full executive assistant, sending me my schedule the night before so I can prepare for each call. It reminds me of the old x.ai assistant, but Carly is noticeably smarter, faster, and better suited to my healthcare recruitment business."
