Skip to content
14-day free trial, no card9 languages176 business types · 50 apps
EN· USD
Try a live demoStart free trial

Import customers or products from Excel (CSV)

Load many customers, products, suppliers, expenses or employees at once from a spreadsheet saved as CSV.

Lesson 15 of 17 · Step by step

  • 3-minute lesson
  • Catalog & stock → Products

Step by step

  1. Save your Excel sheet as a CSV file, with one header row at the top.

  2. Open the list you want to fill, for example Products or Customers.

    /admin/products
  3. Open the Export Export downloads a list as a file: CSV or XLSX for Excel, or JSON for other software. Import loads records from a file into a list. More words in the glossary menu and choose Import from CSV…. Click Download template to see the right columns.

  4. Click Choose CSV file, check the matching under Map columns and the preview of the first rows.

  5. Start the import. The result says how many records were new, updated or skipped, and why.

Where to find it

Checklist

Before you move on, check that you can:

  • Open Catalog & stock → Products
  • Save your Excel sheet as a CSV file, with one header row at the top.
  • Open the list you want to fill, for example Products or Customers.
  • Open the Export menu and choose Import from CSV….
  • Click Choose CSV file, check the matching under Map columns and the preview of the first rows.
  • Start the import.

Tips and common mistakes

  • One import takes up to 5,000 rows. Split bigger files.
  • Export works from the same menu: it downloads what you see on screen, with the same filters.