Skip to content
Back to Journal
Guides5 November 2026

Moving watch stock out of Excel: an import guide

How to move a watch inventory from a spreadsheet into dealer software. Which columns to clean first, what to check after the import, how to get data out.

Viktor Siewert
Viktor Siewert
Founder, ChronoDesk
Contentstap to expand

Short answer: moving a watch inventory out of Excel takes three steps: clean the columns that carry identity and money (reference, serial, buying price, buying date, tax scheme), import, and check the result against the sheet before you switch over. The work is in the cleaning, not the import. And before you move anywhere, check how your data gets out again.

Before you start: one row per watch

Most dealer sheets grew over years. Before importing, make sure:

  • One row is one watch. Not one row per reference with "2x" in a note.
  • Sold and in-stock pieces are clearly separated, or marked with a status column.
  • Each column holds one thing. "126710BLRO full set 2022" in one cell is three fields. Split what you can; a good import can split the rest, but you will check it either way.

The columns that matter most

Reference. The single most important field. Write it the way the brand does, "126710BLRO", not "GMT Pepsi". See how to read a watch reference number.

Serial. It identifies the piece and proves later that it is the one you bought. See Rolex serial number lookup.

Buying price and date. Note whether the price included VAT you reclaimed. A gross price with reclaimed VAT is not your cost.

Tax scheme. Bought from a private seller, or another dealer under the margin scheme, or with VAT? This decides how the sale is taxed later (§ 25a). If the sheet does not say, find out now; it is much harder at the moment of sale.

Costs. Service, polishing, parts, shipping. Ideally one line per cost, not one total. See the watch inventory data model.

Set and condition. Full set, box only, watch only, and a condition you apply the same way to every piece. See full set.

Status and location. Your own words ("Reserved", "At watchmaker", "Safe 2") are fine. Use them consistently.

After the import: check before you switch

  • Count. Same number of watches in stock as in the sheet.
  • Capital. The sum of buying prices matches the sheet.
  • Ten random pieces. Reference, serial, price and tax scheme, compared one by one with the sheet.
  • Duplicates. The same serial twice usually means a watch that was sold, bought back or typed twice.

Keep the old sheet, read-only, for as long as your retention obligations require. Do not keep updating it in parallel; two sources of truth become two different numbers within a month.

Getting your data out again

Ask any system this before you move in: how do I get everything out? You should be able to export your stock, sales and documents in open formats at any time, without asking anyone.

How ChronoDesk handles it

The ChronoDesk import takes a spreadsheet, a PDF, or photos of a watch and its papers. AI reads brand, model, reference, serial, year, condition, set, buying price and date where they are present, a duplicate check flags pieces you already have, and you confirm every field before anything is saved. On the phone you can also dictate fields by voice.

Once your stock is in, each watch carries its tax scheme, its costs as separate lines and its status, and the KPIs are calculated from the first day.

Getting data out is just as direct. The owner or a user with full access can download a full company export at any time: a ZIP of CSV and JSON with watches, costs, sales, customers, wants, invoices, documents, team and settings. The Bestandsliste, the inventory valuation and the profit and loss report export as Excel, CSV or PDF, and live exports in CSV, JSON, XML or Excel feed other systems. See connecting your own tools.

FAQ

How long does it take to move a watch inventory from Excel?

The import itself is quick. The time goes into cleaning the sheet and checking the result. A sheet with clean reference, serial, price and tax scheme columns can move in a day.

What if my sheet has no tax scheme column?

Work it out per watch from how you bought it: private seller or margin-scheme seller, or with VAT. Ask your tax advisor for any unclear cases before the first sale.

Can I keep using my spreadsheet next to the software?

You can, but the two will drift apart quickly. Use the old sheet as a read-only archive and the new system as the one place you change.

ChronoDesk is free for 60 days. Bring your stock list. See the plans.

Last updated on 5 November 2026. General information reflecting ChronoDesk’s understanding at the time of publication, not legal, tax, or financial advice. Rules differ by country and change over time, so have your tax advisor or lawyer confirm your own case before you act on it. See our disclaimer for the full notice.
Share
Tagsimportinventoryexcelmigrationonboardingexport