# Importing data from Excel

Section: Settings. Address: https://vende.id/docs/pengaturan/impor-dari-excel?lang=en

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

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](https://vende.id/docs/produk-dan-harga/impor-ekspor-produk?lang=en).

## 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](https://vende.id/docs/mulai/pindah-dari-program-lain?lang=en).
