DoCuLat can add many accounts and contacts at once, from a spreadsheet or from your own address book.
Who can import
- The company's owners and admins import from a file.
- Every member of the company can import their own Google Contacts or Microsoft 365 contacts.
Import from a file
Open Accounts or Contacts, open the More for accounts or More for contacts menu and choose Import from a file. The import has four steps.
- Upload: choose a .csv or .xlsx file with one record per row and the headings in the first row, up to 10 MB and 20,000 rows. Download a template gives you a file with the right columns. The file is read in your browser. If letters or columns look wrong under First rows, change the Separator or the Character set.
- Map: choose the field each column goes into, your custom fields included. Columns set to Do not import are left out.
- Check: see What the import will do before anything is saved. Choose the Owner and the Tags for every row (by default a tag with today's date). Tick Add missing choices for choice fields and Run automation rules if you need them. Rows with problems are left out, and you can download them to fix.
- Import: choose Start the import. You can leave the page. You get a notification when the import has finished.
A DoCuLat data export (.zip or .jsonl) is imported the same way.
Records the CRM already has
The check finds rows that are records the CRM has: accounts by registration number, VAT number or name, and contacts by e-mail address, phone number or name at the same account. Under What to do with these rows choose:
- Leave the records as they are: the rows are skipped. This is the default.
- Update the records: empty fields are filled from the file, and e-mail addresses, phone numbers and tags are added. With Replace what the records have, values in the file replace the ones in the records.
- Add them as new records: the CRM then has the same company or person twice.
Import from your address book
In More for contacts, choose Import from Google Contacts or Import from Microsoft 365 contacts and connect your account. DoCuLat gets read-only access, and only you can use the connection. Choose All contacts, or some labels (Google) or folders (Microsoft). Next time you can choose Only contacts that are new or changed. You become the owner of the contacts it adds, and no automation rules run for them.
Past imports and undo
Imports, in the same menu, shows who imported which file, when, and what the import added, updated and left out. Owners and admins see every import; other members see their own address-book imports. From an import's menu you can show the imported records, Download the rows left out, or Undo import. An import can be undone for 7 days after it finishes. The records it added go to the trash and the records it updated are set back. Added records that someone has worked on since are kept.
See also
- Accounts and contacts
- Find duplicate accounts and contacts
- Custom fields and tags
- Automate routine work with rules and approval workflows