You can bring a list of people into Aptiro from a CSV file. You choose what each column holds, check what the import would do before anything is saved, and undo it for seven days if it was not what you wanted.
You need permission to import contacts. If Import CSV is missing on the Contacts page, ask an admin.
Import a file
On Contacts, choose Import CSV and drop in your file, or click to browse. A file can be up to 4 MB and hold up to 5,000 rows. Larger lists can be split and imported one part at a time.
Columns. Each column in your file is listed with a few examples. Choose what it should become: the contact's name, role, email, phone or LinkedIn URL, a custom field, the account name or the account website, or Ignore this column. Aptiro makes a first guess from the headers. Name and account name are required. Aptiro remembers your choices, so the next file with the same headers arrives already mapped.
Check. The first 20 rows show as they will be imported. A cell with a problem, such as an email address that is not one, is marked where it is. Rows with a problem are left out of the import and listed in the report. Choose the lawful basis for the people this import creates, then choose Check the file.
The report. Aptiro reads the whole file against your contacts and shows what an import would do, with nothing saved:
- To create: people who are new.
- To update: people who match an existing contact, with the details that would change.
- Skipped, with the reason: on the never re-import list, an account that belongs to someone else, a contact you cannot change, marked do not contact, already up to date, or a repeat of an earlier row in the same file.
- Invalid: rows with a problem in a cell.
- Match an existing contact: every row that matched someone you already have, and whether it matched by email or by name on the account.
Use the filters to look at one group, and Download the full report for a CSV of every row.
Import. Choose Import. A progress bar shows how far it has got. Keep the window open until it finishes.
How rows are matched
A row with an email matches a contact in your organisation with the same email, whoever owns it, so an import does not create someone twice. A row with no email matches by name on the same account. A matched contact is updated with the details in your file. A contact marked Do not contact is never updated. You only update contacts you are allowed to change, and only add to accounts you are allowed to add to. A new account created by the import is yours.
The lawful basis you choose is recorded on the contacts the import creates. A contact it updates keeps the basis already on record.
Undo an import
For seven days after an import finishes, it appears under Recent imports in the import window, with Undo import.
Undo removes the contacts and accounts the import created and puts back the details it changed. It records the undo in the audit log. Only the member who ran the import, or someone allowed to import across the whole organisation, can undo it.
Aptiro never undoes someone else's work. A contact is left as it is, and listed afterwards, if anyone has edited it since the import, or if it now has an activity, a deal, a task or a sequence. An account stays if it still has contacts or deals.
Each detail the import wrote shows where it came from, as described in see where a contact's details came from.