Skip to main content
Your collection data is always yours. Export it as a ZIP of plain CSVs, import it back at any time, or move it to a new instance. Every import shows you a full preview of what will change before anything is written — nothing is committed until you click Apply import. All import and export options live in Settings → Data management. A phone imports too, with Merge or Add only. Replace everything and the full template pack need a screen at least 768 px wide — a tablet or a computer (Phone & Tablet).

​
Getting data out

plamotrack gives you two ways to export:
  1. Full archive (.zip) — go to Settings → Data management → Export. You get one CSV per table plus a manifest.json that records the export timestamp, app version, and row counts. Use this for backups, moving instances, or keeping an offline copy.
  2. Single table (.csv) — one button per table in the Export section, or the Export CSV button at the top of any list page. Use this when you want to pull one table into a spreadsheet without the rest of the collection.
Settings → Data management, with the Export buttons, the Blank templates and the Import area.Settings → Data management, with the Export buttons, the Blank templates and the Import area.

Data management: export, the blank templates, and import with its preview.

​
Importing your collection for the first time

If you’re coming from a spreadsheet, Notion, or Baserow, the starter sheet is the fastest path in.
1

Download the starter sheet

Go to Settings → Data management and click Starter sheet (.csv), under Blank templates on a tablet or computer. The download includes three example rows to overwrite.
2

Fill it in

Add one row per kit. The key columns are:You don’t need to describe orders separately. Write the kits; plamotrack works out the retailers, orders, and order lines from the rows.Numbers follow the same rules as the app’s own forms: a rating is 1 to 5, a quantity starts at 1, and prices, costs, stock levels and low-stock thresholds can’t be negative. A value outside these is refused in the preview, which names its row and column.
3

Import the sheet

Go to Settings → Data management → Import. Drop your filled-in sheet on the upload area or click or browse for one (on a phone, Choose a file), leave If something already exists on Merge, and click Preview changes. Review the preview, then click Apply import when it looks right.
Fill in order_number whenever a shop and date combination isn’t unique. Rows that share the same retailer, order date, and order number collapse into one order — even across separate imports. This is what keeps a multi-kit order together correctly.

​
Import modes

Choose the right mode before you import: Replace everything requires you to type REPLACE to confirm. plamotrack tells you how many existing records it will delete before you do — read that number before you type it.

​
Preview before you commit

Every import — regardless of mode — shows you a full preview of what will change: records to add, update, or delete, table by table. Nothing is written until you click Apply import.
The Import card after Preview changes: a starter sheet read as 9 new and 2 unchanged, with the retailers, orders, order lines and kits it would create listed by row.The Import card after Preview changes: a starter sheet read as 9 new and 2 unchanged, with the retailers, orders, order lines and kits it would create listed by row.

A starter sheet previewed. The two retailers already exist, so they are unchanged; the orders, order lines and kits are new.

If the preview or the import fails, the message appears inside the Import card, beside the button you pressed. Once you click Apply import, the import runs to the end even if you go to another page. Come back to Data management while it runs and it shows as under way (Importing — Merge…), with no file to pick until it finishes; come back after and it shows how it ended, once. Reloading or closing the tab while it runs asks you first, because that would lose the result. The apply step checks against a fingerprint of what you previewed. If your collection changed between the preview and the apply (because you moved a kit or received an order in the meantime), plamotrack refuses and asks you to preview again. You only ever apply exactly what you reviewed.

​
Re-importing safely

Every exported row includes a unique ID. Importing an archive back into the same instance matches those IDs to your existing records — so re-importing is always a no-op. Nothing changes, because nothing has changed. Use this freely for backup verification. Restoring an archive into a new, empty instance keeps those IDs too, so every record comes back exactly as it was exported.

​
Limits

If your spreadsheet app offers a plain “CSV” option and a “CSV UTF-8” option, pick the second one.
CSV cells whose values start with =, +, -, or @ may be interpreted as formulas by spreadsheet apps when you open an export. These are your data bytes, not formulas — plamotrack exports them exactly as stored so they round-trip correctly. Leave your spreadsheet’s formula-detection warnings enabled, especially when opening exports from someone else.