Excel Import: Products, Contacts and Events
After reading this, you'll know which data you can import via the Excel wizard, how the five-step flow works, and how Univents detects duplicate entries for each data type.
As of 07/10, Univents has one unified Excel import wizard for three data types: products (including recipes and bundles), contacts, and events. Instead of typing lists in by hand, download a template, fill it in, and let the wizard handle the rest. This article covers all three import flows — detailed steps for each data type are in the linked articles.
What you can import
| Data type | Where the import starts | Special feature |
|---|---|---|
| Products | Inventory → Import | Second template sheet for recipes & bundles |
| Contacts | Contacts → Import | People and companies in the same file |
| Events | Events → Import | Customer is matched by email, location by name |
All three areas use the same wizard and the same five-step flow — only the template and the target fields differ per data type.
Starting an import
- Open the relevant area in the menu: Inventory, Contacts, or Events.
- Click Import in the top right.
- The wizard guides you through five steps: Template → Upload → Mapping → Review → Import.
How the import works
Template. Click Download template (.xlsx) to get the matching Excel template — it has the right column headers, example rows, and a Notes sheet listing every allowed value. Your own list with different columns works too; you'll map it manually in the next step.
Upload. Drag your file into the drop zone or pick it via the file dialog. Supported formats are .xlsx, .xls, and .csv, up to 10 MB.
Mapping. The wizard automatically detects your column headers and suggests a mapping to the target fields. Required fields are marked; columns you don't need are set to Ignore. For products, the wizard also automatically detects a recipe/bundle sheet and shows a note about it.
Review. Before anything is saved, an overview shows you, row by row, whether it will be New, Updated, or Skipped — errors only block the affected row, not the whole file. You can download the error rows as an Excel file.
Import. Once you confirm the review, the import runs with a progress indicator. At the end you get a report with the number of newly created, updated, and skipped records.
Required fields per data type
| Data type | Required fields |
|---|---|
| Products | Name, net price |
| Contacts | Type (Person/Company), email — plus first or last name for a person, or company name for a company |
| Events | Name, start date |
All other columns are optional. If the end date is left empty for an event, Univents defaults it to 11:59 pm on the start day; if the status is left empty, Draft is used.
How Univents detects duplicates
The three data types handle repeated imports differently:
| Data type | Matched by | Behavior on a match |
|---|---|---|
| Products | SKU, otherwise name | Missing fields are filled in, existing values are never overwritten |
| Contacts | Primarily email (including alternative emails), otherwise name + type | Missing fields are filled in, existing values are never overwritten |
| Events | Name + calendar day of the start date | The row is marked Skipped — there is no update |
That last point matters: an import never changes an existing event, since that would be risky for events already underway. To edit an event after importing it, open it directly in Events.
Common errors
- Required field empty or invalid. A missing name/start date (events), type/email (contacts), or name/price (products) marks that row as an error and skips it — the rest of the file still imports.
- Unrecognized status or type value. For events, the status must be one of the allowed values (Draft, Option, Requested, Confirmed, Cancelled, Completed); a typo produces an error rather than silently landing in the wrong status.
- File too large or wrong format. Only
.xlsx,.xls, and.csvup to 10 MB are accepted. - Recipe/bundle row without a matching product. The product and the component must already exist in Univents or be included in the same import — otherwise the link is skipped.
Frequently asked questions
Can I import multiple data types from one file? No. Each import runs for exactly one data type (products, contacts, or events) through its matching area.
What happens if I upload the same Excel file again? For products and contacts, existing records are recognized and only missing fields are filled in. For events, an event that already exists (same name, same day) is simply skipped.
Do I have to use the template exactly as downloaded? No. Your own files with different column headers work too — you map them to the target fields manually in the Mapping step.
Are comma-formatted numbers and values in another language recognized? Yes. The import recognizes both German and English number formats as well as German and English values (e.g. "pro Stück" or "Per Piece") automatically.
Related articles
- Import products — detailed steps for products, including recipes & bundles
- Import Contacts — detailed steps for the contact import
- Create an event with the creation wizard — creating a single event manually instead of via import