Import of clients (or products) from EXCEL files to InvoiceOcean

Created: 2020-10-27
Last updated: 2024-01-17

In order to import data to InvoiceOcean, go to the Clients (or Products) menu, in the upper right corner you will find the settings function button. Using it, expand the tab and select Import from CSV (or Import products from CSV).

Then, in the first step of import, select the CSV file saved on the disk. The second step of import is to match the data to the appropriate columns.

How does it work in practice?

First choose the file.

import

  Here we also assign column names to their contents.

import2

NOTE!!! In the second step of importing products, you can import product codes visible on invoice items; just assign them to the appropriate column



After matching the appropriate fields to the indicated boxes, use the Import data button.

A comma-separated CSV file can be obtained by exporting from programs like EXCEL, OpenOffice, or Google Docs as follows:
Expand the File tab, then Save As. Enter a file name. In the Save as type field, select the CSV (Comma delimited) option.

import4

 

The XLS/CSV import has a limit of 1000 rows at a time. If the file is larger, it should be split, and multiple imports should be carried out


What happens if you want to update a previous client or product import by overwriting the data with another import file?

As for client data, when importing a file with updated data, the program searches for customer VAT ID numbers and automatically updates other data.

As for updating product data, you can find more information here.

Invoices are imported in the system in a similar way,  you can read about it here.

If you have any problems with importing - please contact us at helpdesk@invoiceocean.com - we will try to assist you.

 

Create unlimited invoices and more with InvoiceOcean. Start your 30-day free trial.

Sign up free


Back


Add Comment