Moving a salon off spreadsheets without losing a week
The migration that goes wrong is the one that starts with ten years of history. Start with tomorrow's bills instead.
30 days free · No card required
How do I move my salon from spreadsheets to software?
In the order that keeps the salon trading: catalogue first, then customers, then start billing, and only afterwards consider looking backwards. Services and products define what a bill is even able to contain, so they must exist before anything else functions. Historic invoices are the one thing rarely worth importing — the effort is large and almost nothing depends on it.
What a spreadsheet is genuinely good at
It is worth being fair to the thing you are leaving, because the reasons it survived this long are also the requirements the replacement inherits. A spreadsheet is instant, costs nothing, bends to any shape you need on a Tuesday afternoon, and never tells you that something is not permitted. Any system that cannot be adjusted by the owner without raising a request will feel worse than the spreadsheet for months, however much more it can do.
- Immediate, with no permissions to configure and nobody to ask
- Free, and already installed on the machine at the counter
- Shaped exactly to how this salon happens to work
- Honest about being a spreadsheet, which no bad software is
Where it starts quietly costing money
The failures are rarely dramatic and that is precisely why they persist for years. Two people edit the same file and one version wins silently. Tax gets applied as one percentage to a total because a formula per line is tedious to maintain. Nobody can say which customers have not been in since March, because answering it means reading every row. None of these announces itself; they simply cap how large the salon can get before the admin consumes the owner.
- No single version of the truth once more than one person edits
- Tax applied to totals rather than lines, which is wrong on any mixed bill
- Questions about customers that require reading rather than filtering
- No link between a booking, the bill it produced and the follow-up it should trigger
- Nothing recording who changed a figure, or when
The order that keeps you trading
Migrations fail when they are attempted as a single weekend event, and they succeed when the salon is billing on the new system by day two with the tidying still outstanding. The sequence matters because each step depends on the one before it: a bill cannot contain a service that does not exist, and a customer cannot hold a membership before there is a plan to sell. Do these in order and nothing blocks anything else.
- One — services and products, with prices and tax treatment, because bills need them
- Two — staff and their roles, so work can be attributed from the first bill
- Three — customers, with phone numbers, since the phone number is the identity
- Four — start billing everything on the new system, from a chosen date, with no exceptions
- Five — memberships and outstanding packages, entered as they turn up at the counter
What to import, and what to leave where it is
Customers, services and products are worth importing because everything you do tomorrow depends on them. Historic bills are not: recreating last year in a new system is weeks of work whose only real use is a comparison you could get from the spreadsheet you are keeping anyway. Keep the old file, read-only, in a folder nobody edits. It costs nothing to retain and it answers the occasional backward-looking question without shaping the entire migration around it.
- Import: customers with phone numbers, services with prices, products with stock
- Import: outstanding memberships and packages, since customers will ask for them
- Leave: historic invoices, unless a specific obligation requires them in the new system
- Leave: dormant customers who have not visited in years and will not be messaged
- Keep the old spreadsheet read-only rather than deleting it
The first week afterwards
The week after a migration decides whether it took, and the thing that undoes it is running both systems in parallel out of caution. Two systems means neither is complete, and the moment one bill goes on the old sheet the reports on the new one are wrong. Pick a date, bill everything after it in the new system without exception, and accept that the first two days will be slower than the last two days of the old way.
- One system from a named date — parallel running is what causes the relapse
- Expect the first days to be slower, and warn the counter staff that they will be
- Check the first week's reports against your own expectation before trusting them
- Fix the catalogue as errors surface at the counter rather than in a review meeting
Common questions
- Can I import my customers from Excel?
- Yes, from a spreadsheet or a Google Sheet, through a guided import that previews what it is about to do and reports each row's outcome. Records are matched on phone number, and you choose whether an existing match is skipped, updated or merged.
- Should I import my past invoices?
- Almost never. It is the most laborious part of any migration and the least used afterwards — the questions it answers are ones your old spreadsheet still answers perfectly well if you keep it read-only in a folder. Spend that effort on a clean service catalogue instead.
- How long does moving off a spreadsheet take?
- For a single salon with a few hundred customers, an afternoon of setup and a slower-than-usual first day at the counter. What lengthens it is dirty data rather than the software — inconsistent phone numbers and duplicated service names cost far more time than the import itself.
- Can I run both systems for a month to be safe?
- You can, and it is the most common way a migration quietly fails. Two systems mean neither is complete, and one bill on the old sheet makes the new reports wrong. Picking a date and committing to it is uncomfortable for two days and correct thereafter.
What it doesn’t do
Worth knowing before you start, not after.
- There is no importer for historic invoices. Customers, services and products can be brought in from a file; past bills cannot, by design.
- Imports are matched on phone number, so a spreadsheet without reliable phone numbers needs cleaning before it is worth importing rather than after.
- Nothing here migrates data out of another salon product automatically. If your current system exports a spreadsheet, that spreadsheet is the route.
- Bookings already in a paper diary are not imported. Future appointments are entered by hand, which for most salons is an afternoon.
See it with your own salon’s data
30 days free, no card required, and a guided setup that takes four steps.