PantryPilotHarborlight Pantry Demo
MOVE YOUR STOCK DATA

CSV tools

Import a simple stock sheet or download a spreadsheet-safe lot and movement export.

Import stock lots

CSV only · up to 5 MB and 2,000 data rows

Supported columnsproduct, category, unit, barcode, source_url, lot_code, quantity, unit_cost, expiry_date, received_date, location, noteOnly product, quantity, expiry_date, and location are required. Dates must use YYYY-MM-DD. source_url is optional and must be a valid Open Food Facts product link. Any invalid row cancels the whole import.Download the sample CSV template ↓

Export or print

Download a copy for review or include it in your own backup routine.

Current stock lotsProduct, lot, quantity, dates, location, and recorded stock value
CSV →
Use and waste historyMovement date, product, amount, reason, and estimated cost
CSV →
Spreadsheet safety: exported text fields beginning with =, +, -, or @ are prefixed to reduce formula injection when opened in common spreadsheet software.

Before importing

Use one row per product lot.

  1. Download the template and open a copy in your spreadsheet app.
  2. Enter one batch per row. Use a distinct row if the same product has a different date or location.
  3. Save as CSV (comma-delimited) and upload. Import runs as one transaction; on a validation error, no rows are added.
  4. Review the resulting lots and make a database backup through your hosting control panel.