Import your contacts
Bring contacts, companies and deals into Anoiq from a CSV file or an Apollo export, or move in from HubSpot, without creating duplicates.
7 min
Prepare your file
Imports take CSV files (also .tsv and .txt) up to 20 MB and 50,000 rows. Excel files aren’t read directly: save the sheet as “CSV UTF-8” in Excel or download it as CSV from Google Sheets.
From Apollo, export the people or accounts you want as a CSV and upload the file as it is: the app recognizes an Apollo export and matches its columns for you.
Start the import
- Click “Import” on the Contacts, Companies or Deals page, or open Settings → Imports and click “Start import”.
- Choose what you’re importing and pick your file.
- Check the file name, rows, columns and encoding the “Upload” step shows, then continue.
Map the columns
In “Map columns”, each column of your file shows its header, a few sample values and the field it goes to. Columns the app matched by their header are marked “Auto-matched”, and those from an Apollo export “Apollo”. Choose “Don’t import” to skip a column, or “Custom property (store as is)” to keep it on the record. Required fields, such as Email for contacts, must be mapped to continue.
Choose options and review
- Under “Which rows to import”, keep all rows or import only the rows that match conditions on your columns, such as Email Status is Verified.
- Under “If a record already exists”, choose “Create and update”, “Create new only” or “Update existing only”.
- When updating, choose “Fill empty fields only” or “Overwrite with values from the file”; empty cells never erase data.
- Pick the owner: from a column, one member, or rotating between members.
- Check how many rows will create, update or skip and any errors, then click the import button.
Move in from HubSpot
Owners and admins can bring companies, contacts, deals, notes, emails, custom properties and deal pipelines over from HubSpot without CSV files. Anoiq only reads HubSpot and never changes anything there.
- In HubSpot, create a service key with the read scopes listed on the HubSpot page in Settings → Connected apps.
- Paste the key on that page in Anoiq and click “Connect”.
- Choose what comes over and, if you only want some records, set conditions.
- Click “Start moving in”; it carries on in the background, and “Run again” later updates records instead of doubling them.
Clean up with Data quality
After an import, open CRM → Data quality. “Overview” lists what to fix first, “Duplicates” finds contacts and companies that look like the same one and merges them, “Cleanup” fixes names in capitals, phone numbers without a country code, countries written different ways and company domains, and “Email quality” shows which addresses are invalid or risky. Newly imported records get the cleanup’s fixes by themselves.