עברית

Moving from Excel to a management system without stopping work

By Boris Shapiro, Founder & CEO · Last updated:

You move from Excel to a system without stopping work by not moving everything in one day. Work out what each sheet does, move customers and leads first, start new orders in the system from an agreed day, and run both for a week or two. Then pick one cut-over day and keep the Excel file as a read-only archive.

How do you know Excel is no longer enough?

Excel does not "die" on a particular day. It stops being enough gradually, and you usually notice it from one of these signs:

  • Several people edit the same file, and someone has already overwritten someone else's change.
  • There are several copies of the file and nobody is sure which is right: "orders final", "orders final 2", "orders final new".
  • There is no history: you cannot tell who changed a status, when and why.
  • There are no reminders. If you do not remember to open the file, nothing happens.
  • Orders live in one sheet, leads in another and customers in a third, so what you know about one customer is scattered.

If that sounds familiar, the full comparison is on managing orders in Excel or in a system. This guide covers what comes after the decision: how to switch without bringing day-to-day work to a halt.

How do you move from Excel to a system, step by step?

  1. List what each sheet and column is really used for. Go through the file and ask about every column: who fills it in, and who reads it? A column nobody uses does not move.
  2. Decide the statuses and stages. What path does an order take in your business, and what path does a lead take? Write it on a page, using names your team already uses. These become the statuses and stages in the system.
  3. Clean only what you need. Duplicate customers and phone numbers typed in several formats are worth fixing before the move. Do not try to make the whole file perfect: that is the surest way to get stuck.
  4. Move customers and leads first. This is the easiest part to move, and in systems that support it you can import it from a CSV file instead of retyping.
  5. Start new orders in the system from an agreed day. Orders that are already open are finished in Excel or, if there are only a few, retyped by hand. That way no order stops halfway.
  6. Run both for a week or two. Record in the system and compare with the Excel file from time to time: is every order there? Are the statuses right? This is where you find what is missing, while it is still easy to fix.
  7. Pick one cut-over day. From then on you work only in the system. Keep the Excel file as a read-only archive and add no more rows to it.

Where does a move like this get stuck?

  • Copying every old column. Some columns were created for a reason that no longer exists. The move is a chance to drop them.
  • Moving everything on day one. One big move stops the work and stresses the team.
  • Not naming an owner for the move. If it belongs to everyone, it belongs to no one. Name one person who decides, checks and answers the team's questions.
  • Not setting a cut-over day. Without a date, working in two systems drags on for months, and the team does not know where to record things.

How do you get the team to use the system?

A system does not replace a habit. What works in practice is one simple rule: if it is not in the system, it did not happen. An order that was not recorded, a call that was not written on the customer's card and a task with no owner count as if they never existed. In the first weeks, whoever runs the business should be the first to keep to it, and not ask on WhatsApp "what is the status?" about something that is already recorded.

Training does not need to be long: a short session in which everyone sees how to add an order, change a status and find a customer is enough to start. The rest is learned on the job.

Where does Dougri fit?

Dougri holds customers, leads and orders in one system, in Hebrew and English. What is relevant to a move, and what is not:

  • CSV import and export of customers and leads. You can import your customer and lead lists from Excel, and your company admin can export customers and leads to CSV.
  • Orders do not move by file. Orders cannot be exported to CSV, and Dougri does not import orders from Excel. So open orders are finished in Excel or retyped, and the old history stays in the file.
  • Setup by LET ME. We set the system up around the way your business works, and train your team.
  • Statuses defined by the business. You define your own statuses and pick colours from nine presets (on Solo: start from a ready-made template).
  • Works in the phone browser. You can check an order or update a status away from the office too.

The full comparison with Excel is on managing orders in Excel or in a system, and plans and prices are on the pricing page. If you want to see how it would look for your business, you can ask for a demo on any page of the site.

Common questions about moving from Excel to a system

How long does it take to move from Excel to a system?

There is no fixed number; it depends on how tidy the file is and how many open orders you have. What matters is not moving everything at once: move customers and leads first, start new orders from an agreed day, run both for a week or two, then pick a cut-over day.

Can I import my orders from Excel into Dougri?

No. Dougri imports customers and leads from a CSV file, but not orders. Orders that are still open can be finished in Excel or, if there are few, retyped by hand. The history of closed orders stays in the original file.

What do I do with the Excel file after the move?

Keep it as a read-only archive: add no rows and make no updates, so there is only one source for day-to-day work. If you like, you can keep using Excel for calculations and reports.

How long should I run both systems side by side?

A week or two is usually enough to see that every order and status appears in the system. Longer than that confuses the team, because it is unclear where to record things. That is why the cut-over day should be set in advance.

Who does the setup in Dougri?

The LET ME team, the company behind Dougri. During setup we configure the system around the way your business works and train your team.

Want to see it with your business?

A free demo, about half an hour on Zoom or by phone. We show you Dougri on orders and customers like yours.

Book a demo or pick a time in our calendar (opens in a new window)