Skip to the page content

Importing data from Excel

Add many products, customers, suppliers, special prices, or opening balances at once from an Excel or CSV file.

On this page

Have hundreds of products or customers in Excel? There is no need to type them one by one. Vende can read an Excel (.xlsx) or CSV file and add its contents at once.

Data you can import

The import button is on the page of each kind of data:

Data Where the button is
Products Master Data → Products, button Import Products
Customers Master Data → Customers, button Import Customers
Suppliers Master Data → Suppliers, button Import Suppliers
Special prices (while the Customer group prices & Special Prices extra feature is on) Master Data → Special Prices, button Import Special Prices
Opening stock, receivables, and payables Settings → Opening Balances, on the Opening Stock, Opening Receivables, and Opening Payables tabs

When the Services feature is on, services can also be imported from Master Data → Services.

The import button only shows for users who may import that data.

Steps to import

  1. Open the page of the data, then press its import button, for example Import Products.
  2. In the window that opens, press Excel example or CSV example to download an example file.
  3. Fill in the example file with your data. Keep the column headings in the first row.
  4. Upload the file.
  5. Check how the columns are matched, then press Import.

One file may hold up to 5.000 rows. Split more data into several files.

The columns of the product file, and how to update products that already exist, are explained in Importing and exporting products with Excel.

After the import starts

The import runs in the background, so you may leave the page. When it is done, the bell tells you how many rows went in.

A wrong row does not stop the import. That row is skipped and reported one by one with its reason, for example a category that was not found. The other rows still go in.

Viewing the import history

Open Settings → Import History to see every import: who, when, which file, and how many rows Succeeded and Failed.

  • The status of an import: Waiting, Running, Finished, or Failed.
  • While an import runs, its progress bar moves by itself and shows an estimate of the time left.
  • Press Download failed rows to download the refused rows with their reasons. Fix them in Excel, then import that file again.

Important: Every imported row of opening receivables and opening payables adds one new note. Do not import the same file twice.

Moving from another program

Importing from Excel suits lists of data. To move all your data together with the transaction history from your old program, use Full Data Import. See Moving from Doctor Accounting or another program.

Still not answered?

Ask us directly. We help until it is clear.

Ask on WhatsApp