Skip to content

Data Import

Bring your contacts with you.

Import contact lists from your previous system. Map the columns, update existing records deliberately and review the results before moving on.

Here’s what you can do.

Three examples show how you can use Data Import.

01

Turn your spreadsheet into contacts

Upload a prepared CSV file and map its columns to contact fields. A column named Town can map to City, without entering each contact individually.

CSV columns for email and town are mapped to the corresponding contact fields.
Simplified product example · not a live product view
02

Update existing records deliberately

Choose update mode and a reliable identifier, such as the contact ID. Use a small test file to check that new values reach the correct contact.

The contact ID matches a CSV value to the existing record and updates its city to Leipzig.
Simplified product example · not a live product view
03

Continue with the imported records

Check the import status and a sample of contact profiles. Once the fields and matching are correct, your team can use the imported records.

After import, the example contact is opened to review its imported city value.
Simplified product example · not a live product view

What this changes for your day-to-day work.

The practical benefits of Data Import.

Keep your custom details

Map customer numbers or interests to suitable custom fields. Required fields are created before the import.

The Customer number CSV column is mapped to the custom contact field created beforehand.

Keep imported contacts in view

A shared import tag lets you filter the imported group later. It helps with review but is not an undo function.

A contact tagged with the October import is found again using that tag filter.

Bring your opportunities

Contacts and opportunities can be imported together. Pipelines and stages must already exist, and their mapping is checked during import.

An example contact is linked to the example studio opportunity in the Proposal stage.

Bring your company lists

Companies have their own CSV import. It creates or updates company records; associations with contacts are set up separately.

The companies CSV file leads to a separate example company record.

Correct only affected rows

The error report identifies affected rows and gives details. Correct those records rather than blindly re-importing an entire partially successful file.

The error report flags an invalid example email and prepares the corrected row.

Simplified examples, not live account data.

What you need to get started.

We review source data, required fields and access permissions. Before larger updates, we retain the available export and test a small file. Import, data cleanup and follow-up processes are agreed separately.

A CSV import transfers a snapshot of data. It does not automatically keep your old software up to date. Ongoing exchange needs a separate sync, and any post-import workflows are selected deliberately.

Availability and any add-on or usage costs are confirmed for your ONE LOOP account before implementation.

Your questions, answered.

Can I upload an Excel file directly?

This import requires a CSV file. Export the relevant sheet as CSV with a header row. We check file size, date formats and required values before uploading.

Will it create duplicate contacts?

The importer matches contacts using identifiers such as contact ID, email or phone. That does not replace a clean source file: ambiguous identifiers and conflicting values need review first. Settings for other contact sources do not universally apply to CSV imports.

Does this migrate my entire previous system?

No. The file transfers selected supported records and fields. Conversation histories, files, websites and automations are not automatically included. We review other record types and relationships separately for your migration.

Can I undo an import?

There is no general undo button for a completed import. An import tag does not restore overwritten values. Back up first, test a few records and deliberately distinguish new records from updates.

See it with your own use case.

Let’s explore your use case and what the setup requires.

Book a demo