Import and export partners and the product catalog using an XLSX (Excel) file instead of entering each record individually.
In the Numbero platform, you can now import multiple customers, suppliers, and products from an XLSX (Excel) file at once, as well as export data that has already been added. Importing partners and the product catalog is useful if you are moving to Numbero from another invoicing or accounting system, or if you want to add new business partners and products in bulk. You no longer need to enter each record individually.
How to import partners from an Excel file?
- Go to the "Partners" section: my.numbero.app/partner
- Click the "Import/Export" button and select "Import list".
- In the import form, click "Download template".
- Fill in the template with your partner data and save the file.
- Attach the completed file in the import form and upload it.
If you are importing a very large number of partners, the upload may take 1–2 minutes.
How to fill in the partner import template?
- The template has 2 worksheets:
data, where you enter partner data, and veidnes apraksts, which describes input data restrictions and indicates which fields are required. - Required fields include, for example, partner type (legal entity - 1, natural person - 0), name, registration number, and country.
- You can also add additional data: email, phone, IBAN (for suppliers), VAT number, etc.
- You can also add partner notes. They will be shown in the invoice form when you issue an invoice to this partner.
- If an input field is highlighted in red, required information is missing from it.
What happens to partners that have already been added?
If a partner with the same registration number and name has already been added, the system will not create a duplicate, but will update the existing partner’s information.
How to export the partner list to Excel?
You can also download all partners added to Numbero in a single XLSX (Excel) file.
- Go to the "Partners" section: my.numbero.app/partner
- Click the "Import/Export" button and select "Export list".
The exported file has exactly the same format as the import template and includes all the partners you have added.
Product catalog import and export
You can import and export the product catalog in exactly the same way. Product catalog import and export work the same way as for partners, just with their own XLSX (Excel) template.
- Go to the "Product catalog" section.
- Click the "Import/Export" button and select "Import list" or "Export list".
- When importing, download the product catalog template, fill it in, and upload it back in the import form.
The product catalog template also describes which fields are required, and the exported file has the same format as the import template.
Common import errors
- Incorrect file format - make sure the file is saved in XLSX (Excel) format.
- Wrong template used - partners and products have different templates, so download the template in the relevant section.
- Required fields are missing - check the red fields in the template and the
veidnes apraksts worksheet.
If you have any difficulties during import, contact us and we will help.