Contacts & companies
Before you start
You need the Admin or Manager role to open Data management. Adding a value to one of your lists, or making a column a custom field, needs the same permission as changing that list or those fields in Settings.
Have your data saved as a .csv file, with column headings in the first row.
The Intel identifier column and the Match intel step appear only when your workspace has a data layer switched on. Everything else works the same without one.
In the sidebar, open Settings then Data management. The Import & export panel opens on the Import tab. More steps join the ones along the top once you have uploaded a file, when they apply to it.

Pick Companies or Contacts, then click Next. Click Download template for a CSV with the right headings and one example row. Company name is required for companies, and Full name (or a first or last name) for contacts.
When your workspace has a data layer switched on, the template has an Intel identifier column, under Data layers: a company number, a register ID or another identifier from one of your registers. It links each company to its record and matches companies you already have. A row with only an identifier is named from its record.
Tip

Click Next, then drag your CSV onto the upload area or click Choose file. OroMiQ shows the file name with its row and column counts. Files of up to 50,000 rows are accepted.

Click Next. Each column in your file is listed with a sample value, and columns whose headings match a field are matched for you. Use the Maps to field menu to fix any that are wrong.
For a column with no field of its own, choose one of:

A tick shows a matched column and a note icon a column kept as a note. Required fields are marked with * and must be matched before you can go on. Click Next.

Some columns name something on one of your lists: a segment, a lead source, an account type, an owner, a priority or a custom field’s option. Check values lists every value in your file that is not on its list, with how many rows carry it. For each one, choose:
Priority and account status are fixed lists, so they offer an existing value or blank. An owner email no team member has goes to a team member you pick, or to you as the person importing; an import never adds a team member. Values are matched in any case, so “north” and “North” are one value.
Click Match intel (or Validate when your file has no Intel identifier column). The values you chose to add go on their lists first.

With an Intel identifier column, OroMiQ looks every identifier up in your data layers’ registers. Matching is free. Each identifier is found, possible (more than one record: choose one, or none), not found, or already in your CRM.
Leave Any of my registers to try every register, or choose one to narrow it. Choose whether new companies from intel go on your Watchlist or into your Portfolio.

Show names and places fills in each found record’s registered name and place. Suggest matches looks for records by name and postcode for rows with no identifier the registers know.
Click Validate.

Validating checks every row without saving anything. You see how many rows are ok, duplicate or in error, and how many records will keep a note of what the import does not use from their rows.
With intel, the step says what the import will make: the new companies from intel, and the existing companies it links to their records. Each new company opens its record once.
Note

Click Import. Once your file is sent, the import runs on in OroMiQ, so you can leave the page and come back to it. When it finishes you see how many rows were created, updated, skipped and not imported, and how many companies came from intel.
Rows not imported are listed with the reason and can be downloaded. Rows that failed only because the data layers were busy can be tried again with Try failed rows again.

Open a company or contact and go to Activity. Anything the import did not use from its row (a value left blank, a column kept as a note, a cell it could not read) is in one note, named with the file and the date, for example “From import of companies.csv, 29 October 2026: Region code ‘NE1’”.

A contact is linked to the company with the name in its Company name column. When no company has that name, Check values lists it: choose Create the company to add it by name and link every contact who works there, or Keep the name in a note on the contact. Creating a company needs permission to add companies.
With a data layer switched on, a contact’s Company intel identifier links the contact to the company holding that record, before its company name is tried.

Open the Import history tab. Each company or contacts import from the last 14 days is listed with who ran it, when, the file and what happened to its rows. Click the count under Not imported to download those rows with their reasons, fix them and import them again.
Note

Switch to the Export tab. Next to Companies, Contacts or Products, click Download CSV. An export reads back in through the same import.
Note

Cannot find what you need? Browse the Help Centre or submit a support ticket.