Appearance
Understanding Microsoft Lists vs Excel for Tracking
Applies to: Microsoft 365 (Microsoft Lists, Excel, SharePoint)
Article Type: Informational
Last Updated: 2026-08-08
Summary
You have a spreadsheet that several people update, and it keeps going wrong — two versions in circulation, next Tuesday sitting in a date column, and nobody sure who changed the status on row 40. Microsoft Lists exists for exactly that situation, and Excel is still the right answer for plenty of others. This article explains what each one actually is, where the difference shows up in practice, and how to tell which your tracker should be.
Before You Start
- A Microsoft 365 work or school account. Microsoft Lists is included with most business plans at no extra cost.
- No admin rights are needed to create a list.
- Nothing here changes a spreadsheet you already have. This is a decision guide, not a migration.
Instructions
1. The Short Answer
The choice comes down to one question: is this a shared record that several people keep updating, or a calculation you are working out?
| What you are doing | Use |
|---|---|
| Several people updating rows of the same tracker | Microsoft Lists |
| An issue log, request queue, or asset inventory that keeps running | Microsoft Lists |
| Collecting rows from people who should not see the whole table | Microsoft Lists |
| Needing to know who changed what, and when | Microsoft Lists |
| A tracker with a settled set of columns, worked on by a team | Microsoft Lists |
| Formulas, modelling, or a number you are trying to arrive at | Excel |
| One-off analysis, pivoting, or a chart | Excel |
| Work you need to do on a plane, with no signal | Excel |
| Anything going to someone outside who expects a spreadsheet | Excel |
| A scratch table only you will ever touch | Excel |
2. What Each One Actually Is
Every difference below comes from one thing, so it is worth being precise about it before comparing features.
Excel is a grid of cells. Each cell stands alone and accepts whatever you put in it — a number, a word, a date, a formula, or all four down the same column. That openness is exactly what makes Excel so good at working something out, and exactly what makes a shared tracker degrade over months. Nothing in a spreadsheet stops a column headed Due date from holding next Tuesday, TBC, and 12/03 in three consecutive rows.
A list is a small structured database. You define the columns up front, and every column has a type: Text, Number, Date and time, Choice, Person, Yes/No, Hyperlink, and a few more. The type is a rule rather than a suggestion. A Date and time column refuses next Tuesday. A Choice column offers the four statuses you defined instead of accepting a fifth that someone invents on a Friday afternoon. A Person column resolves to a real colleague in your directory rather than a name someone spelled two ways.
Each row in a list is an item, and the list itself carries the things a file cannot: who may edit it, what changed and when, and how each person prefers to look at it.
3. The Differences That Decide It
Six practical differences separate a shared list from a shared spreadsheet, and each one maps to a specific way that spreadsheets go wrong.
| The problem | Microsoft Lists | Excel |
|---|---|---|
| Several people editing at once | Everyone works on the same list at the same time. There is no file to have open, no read-only copy, and no Tracker_v4_FINAL_Jos_edits.xlsx. | Co-authoring works on workbooks kept in OneDrive or SharePoint. A workbook emailed around produces parallel copies that cannot be merged back. |
| Bad data getting in | Column types reject what does not fit, at the moment it is typed. | Any cell accepts any value. Data validation exists, but it is set per range and a careless paste removes it. |
| Knowing who changed what | Each item keeps its own history — the old value, the new value, the person, and the time. | History is kept per file, not per row. Finding who altered one cell means comparing whole workbooks. |
| Everyone wanting a different sort | Each person saves their own views. Yours filters to your rows, theirs groups by status, and neither one disturbs the other. | Sorting or filtering changes the sheet for everyone else in it at that moment. |
| Collecting rows from other people | A form takes new items. The person filling it in answers the questions and never sees the table. | Sending the workbook sends every row in it, to everyone you send it to. |
| Reminders and small automations | Built-in rules send an email or set a value when something changes, with no code involved. | Nothing built in. A formula cannot email anybody. |
Permissions differ in the same direction. A workbook is governed by who can open the file; a list is governed per list, and can be narrowed further to individual items. How to Use List Views and Filters in SharePoint covers the views part in detail, and it is the feature that ends most arguments about sorting.
4. Where Excel Still Wins
A list is the wrong answer more often than its enthusiasts admit, and none of these cases are edge cases.
- Calculation. Formulas across rows, lookups, anything with a
SUMIFSin it. A list holds data; a spreadsheet works something out from it. - Ad-hoc analysis. You do not know yet what you are looking for, so you pivot, re-pivot, and throw most of it away. Structure is a cost here, not a benefit.
- Charts. Excel's charting is far beyond anything a list offers.
- One-off work. A table you will use for two weeks and delete does not repay the effort of defining columns.
- Offline. Excel opens on a laptop with no signal. A list needs a connection.
- Handing it over. A client, an accountant, or an auditor expects a file. "Here is a link to our list" is not a deliverable.
- Heavy numeric data. Hundreds of thousands of rows you are calculating across belong in Excel or a proper database, not in a tracker.
If what you have is really a calculation that a few people happen to read, keep it in Excel and store the single copy in a shared library rather than in an inbox. How to Format Data as a Table in Excel covers the one Excel feature that recovers some of the structure a list would have given you — headers that stay put, a name you can refer to, and formulas that extend themselves down new rows.
5. Where Each One Lives, and Who Can See It
Storage is not a technicality here: it decides who finds your tracker and who is able to change it.
- Lists live in SharePoint. A list created inside a Team or a SharePoint site is visible to that site's members from the start. A list created in your own My lists area is private to you until you share it. Open Lists from the App launcher — the grid icon in the top-left corner of any Microsoft 365 page — or add a Lists tab to a Teams channel so it sits where the team already works.
- Workbooks live wherever you put them. OneDrive, a SharePoint document library, a network drive, a USB stick, or an email attachment. That last one is where trackers go to die: every recipient now holds a copy that starts drifting from yours the moment they open it.
The practical consequence is worth stating plainly. A list has one copy because it is not a file. A spreadsheet has as many copies as people have made, and reconciling them by hand is a job nobody has time for and nobody volunteers for.
6. You Do Not Have to Choose All at Once
A list can be built directly from a spreadsheet you already have, so moving a tracker across is not a rewrite.
- In Microsoft Lists, start a new list and choose From Excel, then pick the workbook. Lists reads your header row and proposes a type for each column.
- Read what it proposed before accepting it. This is the moment the tool shows you where your data is inconsistent — a column it declines to type as Date and time is usually one with
TBChiding in it. - Keep the spreadsheet. Building a list from a workbook copies the data across; your original file is not moved, locked, or deleted, and you can go straight back to it if the list turns out to be the wrong shape.
- Run both for a couple of weeks if the tracker matters. Nothing forces the switch to happen on one day, and a list that nobody depends on yet is a list you can restructure freely.
- Export back to Excel whenever you want to. A list produces a workbook or a CSV on demand, so the data is never stuck. How to Create and Use a List in Microsoft Lists walks through building the list itself.
7. If It Is Really About Tasks, Neither of These Is the Answer
A tracker full of things people have to do is a third problem, and the tools built for it beat both a list and a spreadsheet.
A list of tasks with owners and due dates is task management, not data tracking. Planner gives you a board, assignments, and progress that everyone can see, and To Do gives one person their own working list. Understanding Task Management in Microsoft 365 compares both of them against Lists, and the rule of thumb is short: if every row is a job somebody has to finish, use Planner. If every row is a record of something — an asset, a request, an incident, a piece of equipment — use a list.
Troubleshooting
INFO
Building a list from a workbook changes nothing about the workbook. The original file stays exactly where it is, and you can keep using it while the list settles in — which is the low-risk way to find out whether the list is the right shape before anyone depends on it.
| Symptom / Error | Potential Cause | Solution |
|---|---|---|
| A column refuses a value you know is correct | The column's type rejects that format | Open the column's settings and check its type. A Date and time column will not take TBC — add a separate text column for the exceptions rather than loosening the date column. |
| Everyone is looking at a different set of rows | Each person is on their own saved view | Views are per person by design. Switch back to the default view, or ask whoever built the shared one to give it a clear name. |
| You cannot find the Lists app | Not pinned in your app launcher or in Teams | Go to https://office.com, click the App launcher (the grid icon, top-left), and search for Lists. In Teams, click + at the top of a channel and add a Lists tab. |
| Colleagues cannot open a list you created | Created in My lists, which starts private | Share it with them, or build it inside the Team or SharePoint site those people already belong to. |
| The list will not open on a flight | Lists need a network connection | Export the list to Excel before you travel and work from that copy. |
| The import gave the wrong column types | A source column mixes formats | Change the column's type in the list's settings, or delete the list and import again after cleaning that column. Deleting the list does not touch the workbook it came from. |