Contacts & companies

Import companies and contacts

9 min read
Already keep your companies and contacts in a spreadsheet? Import them in one go from a CSV file. OroMiQ checks every row before anything is saved, asks you what to do with values it cannot match, and keeps anything it does not use in a note on the record, so nothing in your file is lost.

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.

Open Data management

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.

The Data management page in Settings with the Import & export panel open on the Import tab, the Export and Import history tabs beside it, the Data type, Template, Upload, Match columns, Validate and Import steps, and cards for Companies, Contacts, Products and Companies by identifier.

Choose what to import and get the template

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

Import your companies first, then your contacts, so the companies your contacts work at are already there.
The Template step for companies, with a Download template button, Company name under Required columns, and optional column groups for Details, Data layers, Phone numbers, Email addresses, Address and Billing address.

Upload your file

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.

The Upload step with companies.csv uploaded, 5 rows and 8 columns, and the steps now including Check values and Match intel.

Match your columns

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:

  • Keep as a note: each record keeps the column’s value in a note.
  • Make it a custom field: OroMiQ adds a text field named after the column and matches the column to it.
  • Ignore this column: the column is left out.
The Match columns step with the field menu open for the Region code column, offering Ignore this column, Keep as a note and Make it a custom field above the fields grouped under Details, Data layers and Phone numbers.

Check your columns

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.

Every column matched: Company name, Intel identifier, Postcode, Segment, Lead source and Owner email to their fields, Region code to Keep as a note with a note icon, and Showroom to the new Showroom custom field.

Choose what to do with values we couldn't match

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:

  • Add it to the list, offered when you may change that list in Settings. Add all to the list does it for a whole column.
  • Use an existing value, and pick it.
  • Leave it blank (kept in a note), the choice until you make another.

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.

The Check values step, Values we couldn't match: segment North in 3 rows set to Add it to the list, an owner email from an old CRM given to a team member, Robin Ashby, and lead sources Trade show set to Use an existing value, Event, and Web left blank, with a message that 1 value will be added to its list when you continue.

Match intel

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.

The Match intel step: Any of my registers, new companies added to the Watchlist, 3 found, 0 possible, 1 not found and 1 already in your CRM, a table of each identifier with its result, a Show names and places button, Suggest matches for 2 rows, and the limits on companies from intel.

See names and places, if you want them

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.

After Names and places shown: each found identifier has its registered name and place, such as BRASSWICK JOINERY LIMITED in Leeds.

Check the rows and the cost

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.

  • A row is in error only when it is missing what identifies its record: a company’s name, or a contact’s name or a valid email address. Everything else is imported, and what cannot be used is kept in the note.
  • Duplicates match a record you already have, or an earlier row in the file: by intel identifier, company number or name for companies, and by email address for contacts. Choose Skip duplicates or Update existing records.

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

One import can create at most 1,000 companies from intel, and your workspace 2,000 a calendar month. Import stays blocked while a file goes past either.
The Validate step: 5 total, 4 ok, 1 duplicate, 0 error and 4 keep a note; a message that the import makes 2 new companies from intel, and the limits; a message that 4 records will keep a note; Skip duplicates and Update existing records; and the rows to look at, one matched on intel identifier.

Import

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.

The Import step after the import: Import complete, 5 rows, 4 created, 0 updated, 1 skipped, 0 not imported and 2 from intel, with an Import another file button.

Find what the import kept

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 company's Activity, with a note added by the import: From import of companies.csv, 29 October 2026: Region code 'NE1', also listed under Notes.

Import contacts whose company is not in OroMiQ

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.

Check values for a contacts file: under Company name, Marlowbeck Studio Ltd set to Create the company and Skelvane Joinery set to Keep the name in a note.

Look back at your imports

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

Imports, and the rows in them, are deleted 14 days after they were made. Admins and Managers see every import in the workspace; others see their own.
The Import history tab listing two imports with when, who, the file, Finished, and the rows, created, updated, skipped and not imported counts.

Export your records

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

Note

Your workspace can download up to 5,000 rows a day from the Export tab. If a download would go past that, you get the rows that fit and OroMiQ tells you the file is incomplete. Once the limit is used up, downloads stop until it resets at midnight UTC.
The Export tab with Download CSV buttons for Companies, Contacts and Products.