Skip to content

Excel Import and Export

Main → Settings → Excel Import and Export

One mapping serves both directions: the columns you assign here are where imports read each field from — and where exports write it.

SettingWhat it does
Choose file format**Excel (.xls, .xlsx) or CSV (*.csv) — the format both import and export use.
Values separatorCSV only: the delimiter between values.
Skip first n row (headers) of Excel file during importExcel only: how many header rows an imported file starts with.

Each row pairs a StoDo field with a spreadsheet column; Do not use leaves a field out. Only Item name is mandatory. In order:

Item name · SKU · Item barcode · Quantity · Group · Group path · Description · Unit of Measure · Store · Image with Exported image size (pixels) · Image Link · Purchase price / Selling price (when prices are on) · Expected quantity (stock-taking) · Minimum quantity · Tags — followed by a row per custom field.

The Image and Image Link rows appear for the Excel format only, and the price rows follow your Prices settings.

Excel only, folded behind Show: columns for an item’s extra photos beyond the first.

  • The import doesn’t force this screen on you: picking a file can open an interactive preview where you assign columns by tapping the sheet’s headers — the import guide covers it.
  • In StoDo Online, these settings are shared with the database and editable by the owner or an admin-profile user.

Still need help? Contact us