Bulk Upload Companies
If you need to add or update multiple companies at once, you can use kolum's bulk upload feature to quickly import your company data using a CSV or Excel file. There is now a single company upload for all your company master data — the previous separate CBAM and EUDR company uploads have been replaced by one upload entry point on the Companies page. This saves time, keeps your records organized, and helps you prepare your workspace efficiently as your organization grows.
Before You Upload
To ensure your upload is successful:
- Use the two-letter country code (for example, DE for Germany, FR for France) in the Country field. Writing the full country name will result in an upload error.
- Do not leave any mandatory fields empty. At a minimum, you must include:
- Identifier (your unique company identifier — mandatory on every row)
- Name (company's legal name)
- EORI Number
- City
- Country (two-letter ISO code)
If required fields are empty, your upload will fail, and you will need to correct the file before trying again. For EU-based companies, entering the EORI Number is required for reporting. For non-EU companies, you can leave this field empty.
The Template Columns
Always download a fresh copy of the template before preparing your file. 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. Provide either none or all three, with non-zero values; when present, the company is also set up for EUDR. Partial or zero financials make the row invalid.
TRACES credentials are not part of the upload — they are managed in the company's page directly.
How to Bulk Upload Companies
- Download the template: Go to Companies and click Upload file in the top right. You can download the sample Excel or CSV file to see the correct structure.
- Fill in your company data: Enter your company details into the file, ensuring all required fields are complete and using the two-letter country codes.
- Upload your file: Click Select file, choose your completed file, and then click Upload file. If your column headers don't match the template, kolum can propose a column mapping automatically.
- Review your data: kolum will display a preview of your entries before finalizing the upload, with any errors shown per row and field (row number, field, and reason). Check that all rows are correct and complete.
- Confirm the upload: Once reviewed, confirm the upload. New companies appear in your Companies list, and rows matching existing Identifiers update those companies.
Validation
- Any single invalid row rejects the entire file — zero rows are imported until every row is valid. Correct the flagged rows and re-upload.
- An empty Identifier makes the row invalid.
- EORI Numbers must be unique — duplicates within your file or against companies already in your account are flagged during validation.
- Financial fields must be provided together and non-zero, or left out entirely.
Tips for a Smooth Upload
- Use clear, consistent company names for easy management.
- Always double-check that the Country field uses two-letter ISO codes to avoid errors.
- Make sure there are no empty required fields before uploading.
- Add EORI Numbers for EU companies to prepare your workspace for compliant reporting.
- Keep your Identifiers stable — they are how kolum matches upload rows to existing companies.
What's new
Company bulk upload is now a single unified upload replacing the separate CBAM and EUDR uploads: a new template with Identifier first and mandatory (the upsert key), address fields, and optional Net Sales / Average Employees / Total Assets financials (all three together, non-zero) that set the company up for EUDR. Any invalid row rejects the whole file and EORI numbers are checked for uniqueness.