Skip to main content

How to import and export with Excel

  • Updated

On a product overview, open Excel.

Import is for an administrator or a superuser.

  1. Choose Import.
  2. Choose the Excel file and choose Import. The log is shown on the page.
  3. Each row is matched on GTIN (D8165) and Target market (D8255). See Creating and Maintaining Excel Profiles for how the sheet is set up.

To clear a field, put @Delete in the cell. See How to Delete Field Content with '@Delete' During Excel Import.

Choose Imported files in the Excel menu to open an earlier import and read its log.

To export, choose Export and pick the fields, or choose a saved profile under the divider. Tick products to export those. With no products ticked, a search exports the products that match.

Two extra columns can mark the imported rows to be sent to the data pool. See Can I use Excel sheets to automatically upload products to GS1?.