Why Excel won't work for inventory management (and when it still does)

Almost every inventory starts in a spreadsheet. Someone opens Excel, types “Item”, “Quantity” and “Location” across the top row, and for a while it works beautifully. The trouble starts later, when more people use the file and more things move each day. The numbers in the sheet and the boxes on the shelf slowly stop agreeing, and nobody can say exactly when that happened.

The short answer: Excel is a good calculator but a poor record of physical stock. It has no idea who changed a number, it cannot tell you when something runs low, and it only knows what someone at a desk remembered to type. This article walks through where spreadsheet inventory breaks, when it is still perfectly fine, and how to move on without a painful migration.

Why Excel is where inventory starts

Spreadsheets earn their place. They are worth defending before we criticise them.

• It is already there. Most offices have Excel or a similar spreadsheet on every computer, so there is nothing to buy or approve.
• It is flexible. You can add a column for colour, supplier or expiry in seconds, and shape the sheet to fit exactly how you work.
• Everyone knows the basics. Sorting, filtering and a simple sum are skills most people already have.
• It is good at analysis. Pivot tables and charts are genuinely useful for looking back over months of data.

For one person tracking a few dozen things that rarely change, a spreadsheet can be the right tool for years. The problems appear when the inventory becomes shared and busy.

1. One file, many hands

A spreadsheet is a document, and documents are designed for one editor at a time. As soon as several people need the inventory, the familiar problems begin: inventory_final_v3_EDIT.xlsx sitting in someone’s downloads, a file locked because a colleague left it open, or two people saving over each other’s changes.

Cloud spreadsheets reduce the locking problem, but they do not change the underlying model. Anyone can overwrite any cell at any time, including a formula, a total, or a whole column after an accidental sort. The file does not understand that “Quantity” means something physical that should only go up when stock arrives and down when it is used.

2. The sheet is only as current as the last person at a desk

Stock moves at the shelf, in the storeroom, on site, or in the van. The spreadsheet lives on a computer. In between is a gap: someone takes three boxes of gloves, means to update the sheet later, and then the phone rings.

This is the most common reason spreadsheet inventory drifts. It is not carelessness; it is friction. When recording a change means walking back to a desk, opening a file and finding the right row, changes get batched, forgotten, or estimated. A phone spreadsheet app helps a little, but scrolling a wide grid on a small screen to find row 214 is not something people do happily while holding a box.

3. Typing is where errors come in

Every number in a spreadsheet was typed by a person, and people make small mistakes: a 50 that should have been 5, a quantity entered in the wrong row, “Tape 48mm” in one place and “48mm tape” in another so the same item appears twice with two different counts.

Spreadsheets have no concept of an item as a thing. They cannot stop you from creating a duplicate, they cannot check a scanned barcode against a product, and a formula that silently stopped covering the new rows at the bottom will keep showing a plausible-looking total for months.

4. No history of who changed what

When the count is wrong, the first question is always “what happened?” A spreadsheet rarely answers it. You can see the current value of a cell, but usually not who changed it from 12 to 4, when, or why. Version history, where it exists, shows whole-file snapshots rather than a clear line of stock movements.

Without history, a discrepancy cannot be traced. Was the stock used, moved to another room, never delivered, or mistyped? Teams end up recounting everything, which is exactly the work the spreadsheet was supposed to save.

5. Nobody is watching the numbers

A spreadsheet is passive. Conditional formatting can turn a cell red when the quantity drops below 10, but only someone who opens the file, scrolls to the right row and notices will ever see it. Nothing taps you on the shoulder.

So running out is usually discovered the hard way: at the moment something is needed. Low-stock checks become a weekly ritual that depends on one conscientious person, and they stop when that person is on holiday.

6. Location is just one more column

Real stock lives in several places: the back room and the front shelf, two offices, a warehouse and three vehicles. In a spreadsheet, location is usually a column, and the same item ends up on several rows. Getting a reliable total means formulas that are easy to break, and moving stock from one place to another means editing two rows correctly, every time.

The question people actually ask, “how many do we have, and where are they?”, is surprisingly hard for a flat grid to answer at a glance.

7. It depends on the person who built it

Many inventory spreadsheets carry years of clever work: lookup formulas, hidden sheets, a macro that prints the order list. They work well until the person who built them changes role or leaves. Then the file becomes something everyone is afraid to touch, and the team starts keeping a second, simpler sheet on the side.

When a spreadsheet is still the right tool

None of this means you must abandon spreadsheets. They remain a good fit in some situations, and a poor one in others.

Situation	Spreadsheet	Shared inventory app
One person tracks the stock	Works well	Optional
A few dozen items that rarely change	Works well	Optional
Several people use and restock items	Drifts quickly	Designed for it
Stock is used away from a desk	Updated late, if at all	Record on the spot from a phone
You need to know who changed what	Hard to trace	Built-in history
Running out is costly	Noticed too late	Alerts before it happens
Stock is spread over several places	Fragile formulas	Totals across storages
Monthly analysis and reports	Excellent	Export to a spreadsheet

The last row matters. The best setups often keep both: an app for the day-to-day record and a spreadsheet for analysis, fed by a clean export instead of hand-typed numbers.

What to look for when you move beyond Excel

If the problems above sound familiar, look for a tool that removes the friction rather than adding more features. A short checklist:

1. Recording at the shelf. Updating a quantity should take a tap or two on a phone, not a trip to a computer.
2. Scanning. QR labels on shelves and support for the barcodes already printed on products make finding the right item instant.
3. Stock by location. Quantities should belong to a place, with totals worked out for you.
4. History. Every change should show who made it, when and where.
5. Alerts. You should hear about low stock before anyone runs out.
6. Shared access with roles. Everyone who handles stock should be able to record it, without everyone being able to change the settings.
7. A way back out. Exporting to a spreadsheet keeps your analysis habits and means you are never locked in.
8. Free to start. You should be able to try it with real stock before paying for anything.

Moving from Excel without a big bang

Switching does not have to be a weekend project. A gradual move works better.

• Clean the list first. Merge duplicate names, decide what one unit means for each item (a box or a single piece), and delete rows nobody recognises.
• Start where it hurts most. Pick the storeroom, category or site where running out causes the most trouble, and move only that.
• Paste, don’t retype. Copy the item names from your spreadsheet and paste them in bulk.
• Count once, properly. Do one fresh count of the stock you moved and record exact quantities, rather than importing numbers you already doubt.
• Label the shelves. Put scannable labels where the stock actually lives, so recording becomes a habit.
• Invite everyone who touches stock. The record is only as accurate as the least connected person who uses it.
• Keep the spreadsheet for reports. Export when you need to analyse, and let the app hold the live numbers.

Where Tana fits

Tana is an inventory app built for exactly this move: from a spreadsheet one person maintains to a shared list the whole team keeps up to date.

• Items, storages and locations. Stock is recorded per storage, such as a shelf, a room or a vehicle, and each item’s total is the sum across all of them. Locations group storages by building or site.
• One-tap recording. The − and + buttons record everyday use, and = sets an exact quantity after a count.
• Paste your list. Add up to 200 items at once by pasting one name per line straight from your spreadsheet. Item names are unique in a team, so duplicates do not creep in.
• QR labels and barcodes. Print QR labels for items and storages from the web app, scan them with a phone camera, or attach the barcode already printed on a product.
• Low-stock alerts. Set a threshold per item and get an email and push notification before you run out.
• History. Every change shows who made it, when, and in which storage.
• CSV export. Download your stock as a CSV file that opens in Excel or any spreadsheet, whenever you want to analyse it.
• Everywhere your team is. Apps for iPhone, iPad and Mac, Android, and a web app for any computer, in 28 languages.

Tana has a free plan with no card required, so you can move one storeroom across and see whether the numbers start staying true.

Frequently asked questions

Is Excel good enough for small business inventory?

Yes, if one person manages a small number of items that rarely change. Once several people take and restock items, or stock sits in more than one place, a spreadsheet tends to drift out of date because updates happen late and changes cannot be traced.

Does a shared cloud spreadsheet fix the problem?

It fixes file locking and version copies, but not the rest. Anyone can still overwrite any cell, there is no clear history of stock movements, nothing alerts you to low stock, and recording on a phone at the shelf is still awkward.

Will I lose my spreadsheet if I switch to an inventory app?

No. Keep it for analysis. A good inventory app lets you export your stock to a CSV file, so you can keep building reports in a spreadsheet while the app holds the live numbers.

How long does it take to move from Excel to an app?

For a single storeroom, it can take an afternoon: clean the list, paste the names in, count once and label the shelves. Moving one area at a time is usually faster overall than trying to switch everything at once.