Guide
How to stop using Excel for stock
There is nothing wrong with Excel. In a small warehouse looked after by one person it does the job well and costs next to nothing. This guide is for the day it starts to fall short: how to spot that point and how to switch without losing data or halting work.
When Excel is still enough
If one person records all the movements, you sell through a single channel and your stocktake comes out close to the sheet, you are in no hurry. Changing tools takes time, and that time needs to pay for itself.
The signs it no longer works
If a couple of these sound familiar, it is probably time to move on:
- Several copies of the sheet are going round and nobody knows which one is right.
- When two people update it at once, one of them overwrites the other.
- You also sell online, and the web shop has no idea what the spreadsheet says.
- The stocktake never matches and there is no way to find out which movement is missing.
- Working out what sells and what does not takes a whole afternoon of formulas.
- When the person who keeps the sheet goes on holiday, nobody else knows what is in stock.
Step 1: do not clean up the sheet too early
A lot of people spend weeks tidying the spreadsheet before switching, and there is no need. The sheet of items and quantities is imported as it stands, columns and names included. If you have several versions, the one thing to settle first is which of them is correct.
Step 2: describe how you work, not how the sheet looks
A spreadsheet shows you figures, while a program has to follow the movements behind them. Write down in your own words how goods arrive, how they leave and who records each step, including the exceptions that currently end up in a comments column.
Step 3: a few weeks in parallel
For a while, record in both places, or at the very least compare them once a week. You will find out where they differ before you rely on the new system, and the team gets used to it at its own pace.
Step 4: one count and a switch-over date
Count the whole warehouse, enter those quantities in the new program and, from that day on, record everything there. The spreadsheet is kept as a record of the past and is no longer used for daily work.
What you gain
More than a new program, you gain the freedom of never having to ask around how much of something is left.
- One stock figure, which each person sees according to their role.
- Every movement shows who made it, when, and what changed.
- If you have a web shop, it draws on the same stock.
- An alert when an item drops below its minimum.
- You can ask in plain words instead of building formulas, for example “what has not moved this quarter”.
- Your data can be exported as a table whenever you like, so you are never locked in.
How the platform does it
You explain how your warehouse runs, upload the spreadsheet and the platform builds the application around the way you work. If you would rather not do it alone, we move the data across with you (see Services). There is more on Warehouse management and Stock and sales, and shop owners can start with how to keep track of stock in a shop. Thinking of asking a chatbot to write the program? Have a look first at what ChatGPT’s code is missing.
Frequently asked questions
Do I have to tidy up the spreadsheet before moving to a program?
No. The table is imported as it is, and you are not asked to rearrange it to fit a template. Just decide which sheet is the right one, if there are several.
How long do we need to run both in parallel?
Until two or three comparisons in a row match. For an ordinary warehouse that is usually a few weeks, not months.
What if the new program does not convince us?
The spreadsheet is still there during the parallel period, and the program's data comes out as a table at any time. If what you get is no use to you, signing up has cost you nothing.
Upload your spreadsheet and see what comes out
Creating an account costs nothing and you will not be asked for a card. Tell us how your warehouse runs and try the application before you pay.