Bulk Upload Companies

Overview

If you need to add or update multiple companies at once, use kolum's bulk upload to import your company data from a CSV or Excel file. There is a single company upload for all your company master data across modules, so the companies you upload here are immediately available to the PPWR module for applicability checks. This saves time, keeps records organised, and prepares your workspace as your organisation grows.

Before you start

• Download a fresh copy of the template from the upload dialog before preparing your file; the templates are updated to standardised versions.
• Use the two-letter country code (for example DE for Germany, FR for France) in the Country field. Full country names cause an upload error.
• Do not leave mandatory fields empty. At a minimum, include Identifier, Name, City, and Country on every row; for EU-based companies working in customs modules, include the EORI Number.

🟢 Why this matters. The PPWR applicability check runs per company, so an accurate, complete company list is what makes your obligation picture complete. A missing entity means unseen obligations. See Regulation (EU) 2025/40.

The template columns

The columns are: Identifier, Name, EORI Number, Country, City, Postal Code, Street Name, Street Number, Post Office Box, Net Sales, Average Employees, Total Assets.

• Identifier (mandatory, first column). Your unique identifier for the company and the key for the upload: a row whose Identifier matches an existing company updates that company; a row with a new Identifier creates one.
• Net Sales, Average Employees, Total Assets (optional). The company's financial data, used by modules that classify company size. Provide either none or all three, with non-zero values; partial or zero financials make the row invalid.

Step by step

1. Download the template. Go to Companies and click Upload file in the top right. Download the sample Excel or CSV file to see the correct structure.
2. Fill in your company data. Complete all required fields and use two-letter country codes.
3. Upload your file. Click Select file, choose your completed file, then click Upload file. If your column headers do not match the template, kolum can propose a column mapping automatically.
4. Review your data. kolum shows a preview before finalising, with any errors listed per row and field (row number, field, and reason).

5. Confirm the upload. New companies appear in your Companies list; rows matching existing Identifiers update those companies.
6. Run the PPWR applicability check for each newly added company, so roles and obligations become visible.

Validation

• Any single invalid row rejects the entire file; nothing is imported until every row is valid.
• An empty Identifier makes the row invalid.
• EORI numbers must be unique, both within your file and against companies already in your account.
• Financial fields must be provided together and non-zero, or left out entirely.

Tips

• Keep your Identifiers stable; they are how kolum matches upload rows to existing companies.
• Double-check the Country column for two-letter ISO codes before uploading.
• Upload every entity that places packaged products on the EU market, including own-brand sellers.

ℹ️ Regulatory context. Each uploaded company is a legal entity whose activities may trigger PPWR roles and per-member-state registration and EPR duties (Article 3, Chapter VIII). The upload builds the entity list those checks run on. See Regulation (EU) 2025/40.

Common Questions