This article is also available in:

Importing and updating suppliers

If you want to import a supplier list or update your supplier info, you can do so with the import template.

Navigate quickly to:

Importing suppliers

For the import of the suppliers you can use 3 tabs in the Excel:

'suppliers' contains the general information of the supplier.
(if you want) 'suppliercontacts' to import the contactpersons linked to the supplier + their information. This tab only works in combination with the 'suppliers' tab.
(if you want) 'comments' to import remarks on the supplier card. This tab only works in combination with the 'suppliers' tab

The link between 'suppliers' and the other tabs is made on the basis of the NR column.

For suppliers, the update can be carried out on the basis of 3 fields:

NAME: the supplier is looked up on the basis of the name.
NR: can only be used if the suppliers were uploaded into Robaws through an import AND were numbered in the import template. The 'NR' then refers to the original 'NR' column. If the suppliers were created manually in Robaws, or if they were not numbered on import, the update has to be done on the basis of Name.
ID: the most accurate way to update an existing supplier, because the id is always unique and is generated automatically. You find the id in the export of the suppliers.

It is not possible to update the 'suppliercontacts' and 'comments' tabs.

The search for an existing VAT tariff, payment condition, ... has to be written identically and is case sensitive!

Column title	Field in Robaws	Explanation
UPDATE_BY	Field that is used for the update	possible UPDATE_BY values
NR	Internal number that is used for the import of other tabs, is not visible in Robaws	number the suppliers if you also want to import an additional tab
NAME	Supplier name
VAT	VAT number	also fill in the country code, for example BE123456789
TEL	Telephone
MAIL	General e-mail
WEBSITE	Website
STREET	Street	street and house number
ZIPCODE	Zipcode
CITY	City
COUNTRY	Country
STATUS	Status
LEGALFORM	Legalform	if written identically it will be linked to an existing legalform in Robaws (settings > general > titles & legalforms), if it does not exist yet it will be created
GSM	GSM
ID	ID of the supplier	this number is given to a supplier card as a unique ID after the import. So you can only use it for an update of data. You find this number in the supplier export.
ACCOUNTNR	IBAN number
VAT_TARIFF	VAT tariff	has to be an existing VAT tariff in Robaws (settings > general > master data > financial > VAT tariffs)
LANGUAGE	Language	choice between: Dutch, French, English, German (if left blank, Dutch will be filled in)
BIC	BIC
ACCOUNTANCYCODE	GL account
PAYMENT_CONDITION	Payment condition	has to be an existing payment condition in Robaws (settings > general > master data > financial > payment conditions)
TYPE	Type	if written identically it will be linked to an existing type in Robaws (settings > project > construction partners), if it does not exist yet it will be created

This tab only works in combination with the 'suppliers' tab. Use the NR column to reference:

Number the suppliers on the 'suppliers' tab (NR column)
Reference the correct supplier by filling in the right number in the NR column on the 'suppliercontacts' tab

Column title	Field in Robaws
NR	Supplier number, has to refer to a number in the NR column on the 'suppliers' tab
TITLE	Title
FIRSTNAME	First name
LASTNAME	Name
EMAIL	E-mail
TEL	Telephone
GSM	GSM
FUNCTION	Function

This tab only works in combination with the 'suppliers' tab.

Number the suppliers on the 'suppliers' tab (NR column)
Reference the correct supplier by filling in the right number in the NR column on the 'comments' tab

Column title	Field in Robaws
NR	Supplier number, has to refer to a number in the NR column on the 'suppliers' tab
USER	Robaws user
COMMENT	Remark
OBJECT_ID	ID of the supplier

Updated on: 09/09/2026

Was this article helpful?

Thank you!