← All posts

From Excel to a working till in one morning

Many shops already have their products, prices and customer balances in a spreadsheet. With an hour of tidying and a careful import, that file becomes a working till before lunch. A plan, hour by hour.

By the CreekPOS team 3 min read

From Excel to a working till in one morning

A surprising number of shops in the UAE run on a spreadsheet: one sheet of products with prices, one of customers who owe money, one of suppliers. It works until the shop grows: two people edit the file, a price changes on the shelf but not in the sheet, and nobody knows which copy is the latest.

The good news is that the spreadsheet is already most of the work of starting a till. Our article on switching from another POS covers moving from an old system. This one is for the Excel shop, and it fits in a morning.

7:00 — Make a copy and tidy it

Never import your only copy. Save a copy of the file, then in the copy:

  • One row per product, one heading row at the top, no merged cells, no totals at the bottom.
  • Columns you need: name, barcode (if any), selling price, cost, quantity in stock, category. Optional: a second name in Arabic, expiry date, supplier.
  • Prices as numbers. "12.50" or "AED 12.50" is fine; "12.50 (new)" is not.
  • Barcodes as text, so Excel does not turn 6291234567894 into 6.29E+12. Format the column as text before pasting.
  • Remove duplicates. Sort by barcode and by name; delete the second "Water 500ml".

Do the same for the customers' sheet (name, phone, balance owed) and suppliers (name, phone, balance you owe).

8:00 — Import the products

Open the import, choose the file and look at the guess for each column: what the system thinks it is, and why. Correct the ones it got wrong. Then read the dry run before anything is written: how many products will be added, updated or skipped, and why each skipped row was skipped.

A typical first dry run finds a few dozen problems: prices with text, missing names, two products with one barcode. Fix them in the file, not one by one in the till, and run the check again.

9:00 — Customers, suppliers and opening balances

Import the customers with their balances on a chosen date — the morning you start. Each balance becomes an "opening balance" line on the customer's account, so the statement starts with the right figure. The same for suppliers.

Do not import old sales. They belong in the old file, which you keep.

10:00 — Stock: count what matters

Your spreadsheet's quantities are probably approximate. Import them as opening stock, then spend half an hour counting the fifty products you sell most and correcting those. The rest can be counted shelf by shelf over the following weeks. See a stock-take that adds up.

11:00 — Ring up ten real sales

Before customers see the new till, ring up ten typical baskets: a scanned product, a product without a barcode, a weighed item, a customer on account, a return. Check the receipt and the stock after each. Fix the printer and the drawer now, not at 6 p.m.

12:00 — Open

Keep the spreadsheet for reference, read-only. From now on, prices change in one place.

If something went wrong

An import is one batch. If you notice the next day that the prices column was mapped to cost, undo the whole import and run it again rather than fixing a thousand products by hand.

In CreekPOS

Bring your data is in every plan of CreekPOS Online: Excel (.xlsx), CSV, TSV and TXT files, headings in English, Arabic, Hindi or Urdu, a guess for every column with its reason, a dry run with its findings, opening balances and stock, and undo within 30 days. No file? Download the empty template in your language. See the manual chapter and the features page.

This article is general information as of its date, not legal or tax advice. Rules change; check the official source or ask your accountant before acting.

Add CreekPOS as a preferred source on Google

Try CreekPOS free

CreekPOS Online free for 14 days, or the program on your PC for 14 days. Every feature, no card.

Help centre

Search by feature, screen or task. Open a guide and share its link with your team.

Help centre