Bulk import and export for Bath & Body data
Move your Bath & Body pantry shelves in and out of Hi Ellie as spreadsheets — download a template, fill it in, and upload, or export a copy of what you've got.
If you're setting up a Bath & Body workspace with a lot to add at once — or you just want a copy of what's on your shelves — you can work in a spreadsheet instead of adding items one at a time. You'll find this under Settings, on the Import & Export page.
Where to find it
The Import & Export page groups its cards by craft. In a Bath & Body workspace you'll see a Bath & Body section with a card for each type you can move:
| Card | What it moves |
|---|---|
| Oils & Butters | Your carrier oils and butters, with costs, on-hand amounts, and reorder thresholds. |
| Lye | Your NaOH and KOH, with purity, on-hand amounts, and reorder thresholds. |
| M&P Bases | Your melt & pour bases, with regulatory class, blendability, and INCI ingredient lists. |
| Bath Ingredients | Your clays, botanicals, exfoliants, and other additives, with reorder thresholds. |
| Essential Oils | Your essential oils, with botanical names, scent families, flash points, and package cost. |
| Preservatives | Your preservatives, with effective-rate and pH ranges used by the recipe calculator. |
A workspace with a Bath & Body craft but no Candle craft also sees Fragrance Oils here, since fragrance oils are shared across Candle and Bath & Body.
The Bath & Body section only appears when your workspace has a soap craft. Every file is an XLSX spreadsheet.
Importing
Each card has an Import side with two steps:
- Download template so your columns line up.
- Upload XLSX to bring the filled-in file back in.
When the upload finishes, a result banner tells you how many rows were imported, updated, skipped, and how many had errors, so you can fix any bad rows and upload again.
Every template opens with one example row and a short note on each column. name is the only required column on every card — the rest are optional, so fill in what you know and leave the gaps for later. A few columns are the exception:
- Lye requires a valid lye_type (
naohorkoh) on every row — there's no default, so a row missing it (or carrying something else) is skipped with a row error. - Preservatives checks effective_rate_min_pct/effective_rate_max_pct and ph_min/ph_max for a sane range (0-14 for pH, min at or below max) — a row outside those bounds is skipped with a row error rather than silently saved, since the recipe calculator reads these values directly.
Heads up: it's an XLSX file, not CSV. Bulk import is a Maker-plan feature — downloading the template and exporting stay free on every plan.
Exporting
Each card also has an Export side. Export all pulls that type back out of the active workspace as a spreadsheet, so you always have a copy. Exports use the same column layout as the templates, which means anything you export can be edited and re-imported.
Exporting is available to owners and editors. Downloading a template and exporting are free on every plan.
Update a lot at once
Because exports round-trip, the fastest way to fix many items is to export the type, edit the spreadsheet, and upload it back in. Rows that match an item you already have are updated rather than duplicated, so you can adjust prices, thresholds, or specs in bulk without redoing your shelf by hand.