How to Digitize Perfume Formulas From Paper and Spreadsheets

Why digitize at all

Paper notebooks are durable and immediate, and many perfumers keep using them at the bench. Their weaknesses show at scale: they cannot be searched, they cannot calculate, they cannot be backed up without copying, and a single spill, fire or move can lose years of work. A digital record that is searchable, calculable and backed up — alongside paper, not necessarily instead of it — removes those risks. Perfume formula software vs spreadsheets helps decide what the digital side should be.

Step 1: inventory

Gather everything: notebooks, loose sheets, old spreadsheets, files on old computers, exports from old programs. List each source with its date range and what it holds. You will usually find that some formulas exist in several versions across sources, and that some sources are more trustworthy than others.

Step 2: decide the structure first

Decide, and write down, before entering a single formula:

• The formula code format, and how existing formulas will be numbered.
• How versions are recorded, and what to do when only the final version survives.
• The unit for all formulas (grams, percentages, or parts per thousand).
• How dilutions are written — always as a separate value, never in the material name.
• The material list and material codes that formulas will refer to.
• What to do with uncertain entries: flag, never guess.

These are the same rules as for any formula record; the perfume formula template and how to standardize formula documentation cover them in detail.

Step 3: prioritize

1. Formulas in production or for sale.
2. Formulas in active development.
3. Accords and bases used inside other formulas.
4. Approved but inactive formulas.
5. Historical experiments.

Many archives never need step 5 fully transcribed — a scanned page with an index entry is enough.

Step 4: transcribe carefully

Transcription errors are the main risk. Reduce them by:

• building the material list first, so formulas pick materials from it rather than retyping names;
• entering each formula exactly as written, including its units, before converting anything;
• having a second person (or yourself, on another day) read back every number;
• flagging anything illegible or ambiguous rather than guessing — especially dilutions.

Step 5: reconcile

For each formula, check the digital total and percentage sum against the original's. If the original was in parts per thousand and summed to 1000, the digital version must too. Where originals contain arithmetic errors, record the formula as written and note the error separately; do not silently "fix" a historical record. If you are bringing data from existing spreadsheets rather than paper, how to import and clean up existing formula data covers the cleaning steps.

Step 6: keep the originals

Scan notebooks and loose sheets, name the scans consistently (by notebook and page, or by formula code), and store them with your other backups. Keep the paper too. The digital record is a working copy; the originals are the evidence of what was actually written at the time.

For small fragrance businesses

A business digitizing its formula archive is also deciding how it will work from now on. Use the project to standardize: one formula code system, one version convention, one material list, one place where records live. Plan a cut-over date after which new work is recorded digitally first, and decide who is allowed to approve formulas. The broader workflow is covered in building a fragrance development workflow.

After digitizing

A digital archive is only safer than paper if it is backed up and organized. Organize it as described in how to organize a digital perfume formula library, and back it up properly. For the wider choice of tools, see the perfume formulation software guide.

Frequently asked questions

How long does digitizing take?

It depends on the archive, but plan in batches of a few formulas at a time with checks, rather than a weekend marathon. Accuracy matters more than speed.

Should I stop using paper at the bench?

Not necessarily. Many perfumers keep paper at the bench and transcribe daily. What matters is that one record is authoritative and the other is clearly a copy or a draft.