Short answer
Formula data portability is your ability to take all of your records out of a tool — every material, formula, version, dilution and note — in a complete, documented format that another tool or a person can use. It matters because every tool is eventually replaced, discontinued or outgrown, and a formula library is years of work. Test it before you commit: export everything, inspect the files, and confirm you could rebuild your library from them.
Why it matters
- Tools end. Products are discontinued, companies close, subscriptions lapse, devices change. Your records should outlive all of them.
- Needs change. The tool that suits ten formulas may not suit a thousand, or a team.
- Others need data. A manufacturer, safety assessor or new colleague may need records in a form they can use.
- Backup depends on it. A backup that only one program can read is only as durable as that program.
What a complete export contains
| Data | What must survive |
|---|---|
| Materials | Every record and every field, including custom fields, codes, dilutions, IFRA limits, prices with their units |
| Formulas | Every entry with its material reference, amount and dilution; code, version, status, tags, notes |
| Versions | Old versions, not only the latest |
| Relationships | Which material each formula entry refers to, by a stable identifier |
| Notes and history | Evaluation notes, change reasons |
| Attachments | Pictures, documents — or at least a clear statement that they are not included |
Watch especially for dilutions. An export that lists formula entries by weight but drops their dilutions has silently changed every diluted formula.
Formats that travel
Open, documented formats are the most portable: CSV and spreadsheet files for tables, JSON for structured records, PDF for human-readable archives. A proprietary file that only one program can open is not portable, however complete. How to export perfume formulas compares the formats and what each is good for.
A portability test to run before committing
- Enter a small but realistic sample: ten materials (some with custom fields), three formulas with diluted entries, at least two versions of one formula, and some notes.
- Export everything, in every format offered.
- Open the files. Is every field there? Are dilutions there? Are versions there? Are material references unambiguous?
- Try importing the export into a spreadsheet or another tool. Could you work with it?
- Re-import it into a fresh copy of the same tool, if possible. Does it come back identical?
If any step fails, find out why before you put years of work into the tool. The same test belongs in any software evaluation — see how to choose perfume formulation software.
Planning a move without losing history
When you do change tools, the risk is losing what is hardest to see: old versions, the reasons behind changes, the link between batches and the formula versions they used.
- Export everything from the old tool, in every format, and archive it unchanged.
- Also produce PDFs of approved and production versions — readable forever without any software.
- Map the old structure to the new one, including codes and version numbers. Keep codes the same.
- Import into a test copy, check counts and totals, and compare sample formulas row by row.
- Decide how to carry old versions: imported as versions, or archived as read-only exports with a reference.
- Keep the old tool's export as part of your backups.
The data-cleaning side of a move is covered in how to import and clean up existing formula data.
Portability and confidentiality
A complete export is a complete copy of your formulas. Store it as carefully as your working data, and do not send a full export when a single formula will do.
RUŌOD Lab's position
We built RUŌOD Lab on the principle that software should never be what traps a formula library. Materials, formulas and collections export as PDF, CSV, Excel and JSON; a complete backup carries every record whole, including material pictures; and the app imports CSV, Excel and JSON. Run the test above on it as you would on anything else. For how portability fits with backup and confidentiality, see the formula data management guide.
Frequently asked questions
Is a PDF export portable?
For people, yes: a PDF is readable almost anywhere for a very long time. For software, no: getting the numbers back out of a PDF reliably is difficult. Keep both a PDF and a structured export.
What if my current tool has no complete export?
Export what it can, record everything else by hand or screenshot, and plan a move while you still have access. The longer you wait, the more there is to recover.
Written and reviewed by the RUŌOD Lab team. This article is general education about perfume formulation and record-keeping; it is not legal, regulatory or safety advice, and the examples are illustrations, not validated commercial formulas. How we write and check these guides.