---
title: "Importing & Exporting Contacts"
description: "Complete reference for importing and exporting contacts in Aesthetix CRM: CSV formatting, tags, opportunities, Companies and Custom Objects, troubleshooting, exporting, and platform migration."
url: https://help.aesthetixcrm.com/en/articles/1454-importing-and-exporting-contacts
collection: "Import & Export Contacts"
updated: 2026-11-04
language: en
---

# Importing & Exporting Contacts

Complete reference for importing and exporting contacts in Aesthetix CRM: CSV formatting, tags, opportunities, Companies and Custom Objects, troubleshooting, exporting, and platform migration.

Aesthetix CRM lets you move patient and prospect data in and out of the platform using CSV files. This reference covers everything from formatting your spreadsheet, running a bulk import, adding tags, importing opportunities alongside contacts, and importing Companies and Custom Objects, through troubleshooting failed imports, exporting your contacts, and migrating from another platform (including the onboarding contact migration, Vagaro, and Nextech). Only Admin users can import and export.

**Interactive walkthrough**

## How to Import Contacts via CSV

Follow these steps to bulk import a list of contacts from a CSV file.

1.  Click **Contacts** in the left-hand menu.
    
2.  Click **Actions** (or the **Import Contacts** button on the [Smart Lists](https://help.aesthetixcrm.com/en/articles/1453-smart-lists.md) tab).
    
3.  Click **Import**.
    
4.  Choose **Upload a file or drag and drop**, then select your CSV file. Make sure the file is a supported size (under 30 MB).
    
5.  **Map** your columns. Align each column from your imported file with the matching contact field in Aesthetix CRM. Use the preview column to confirm the mapped data looks correct.
    
6.  If any columns do not match a field, check **Don't import data in unmatched columns**. You cannot proceed to the next step until unmatched columns are either mapped or this option is selected.
    
7.  On the **Details** step (the final step), confirm your import settings.
    
8.  Enter an **Import Name**. You can keep the default name or customize it.
    
9.  Optionally check **Create a list of contacts from the import** to generate a fresh Smart List from this import.
    
10.  Click **Advanced** to control how existing contacts are handled. You have two choices:
     
     -   **Add New and Update Existing Contact Records:** creates a list for new contacts and simultaneously refreshes your existing contacts by incorporating the imported data.
         
     -   **Add New Contact Records:** creates a new list and adds only the contacts, without updating existing records.
         
11.  If updating, set **Find Existing Contact Records** rules. Merging is restricted to existing contacts only.
     
12.  Set **Find Existing Contacts Based on (Primary)**. When merging or updating, you can choose to skip existing contacts that share the same primary phone number, or include them. You may also check the box to **exclude updating blank values** for pre-existing records (so empty cells in your file do not overwrite data already on the record).
     
13.  Under **Add Tags**, search for existing tags or create new ones to attach to the imported contacts.
     
14.  Under **Add to workflow**, optionally enroll the imported contacts in a workflow.
     
15.  Click **Submit**.
     

You can watch the progress and results of any import on the [**Bulk Actions**](https://help.aesthetixcrm.com/en/articles/1455-bulk-actions.md) page (covered in the troubleshooting section below).

> **Updating existing contacts clears their email verification status.** When you import a file that updates contacts already in your account (the "Add New and Update Existing Contact Records" option), the email verification status on those updated records is reset. This matters if you rely on a **Valid Email** filter in a Smart List, because those updated contacts will no longer be marked valid until you re-verify them. Re-verifying consumes email-verification credits and has a cost, so plan imports carefully and avoid re-verifying the same contacts repeatedly. Only re-verify when you genuinely need a clean Valid Email segment (for example, before a large email send).

## How to Format the CSV File

A clean, correctly formatted CSV is the single best way to avoid import errors. CSV stands for Comma-Separated Values: each line is one record, and fields are separated by commas. You can create or edit a CSV in Excel, Google Sheets, or Notepad.

### File requirements

<table style="min-width: 50px;"><colgroup><col style="min-width: 25px;"><col style="min-width: 25px;"></colgroup><tbody><tr><th colspan="1" rowspan="1"><p><strong>Requirement</strong></p></th><th colspan="1" rowspan="1"><p><strong>Detail</strong></p></th></tr><tr><td colspan="1" rowspan="1"><p>File format</p></td><td colspan="1" rowspan="1"><p><code>.csv</code> only (Excel <code>.xlsx</code> and Google Sheets links are not supported for Companies and Custom Objects; for contact imports a <code>.csv</code> is always recommended)</p></td></tr><tr><td colspan="1" rowspan="1"><p>Sheets allowed</p></td><td colspan="1" rowspan="1"><p>One sheet/tab per file</p></td></tr><tr><td colspan="1" rowspan="1"><p>Max file size</p></td><td colspan="1" rowspan="1"><p>30 MB (split larger files into smaller files)</p></td></tr><tr><td colspan="1" rowspan="1"><p>Header row</p></td><td colspan="1" rowspan="1"><p>Required, and the first row must not be blank; at least one column header must match a field in the system</p></td></tr></tbody></table>

### Required and optional fields

At least one of the following is required to create or update a contact:

-   First Name
    
-   Email Address
    
-   Phone Number
    

For updating existing contacts, include a unique identifier (Contact ID, Email, or Phone) consistent with your duplicate-detection settings. Common optional fields include Company, Tags, Status (Subscribed/Unsubscribed), Created Date, additional emails, and additional phone numbers.

A simple example:

<table style="min-width: 200px;"><colgroup><col style="min-width: 25px;"><col style="min-width: 25px;"><col style="min-width: 25px;"><col style="min-width: 25px;"><col style="min-width: 25px;"><col style="min-width: 25px;"><col style="min-width: 25px;"><col style="min-width: 25px;"></colgroup><tbody><tr><th colspan="1" rowspan="1"><p><strong>First Name</strong></p></th><th colspan="1" rowspan="1"><p><strong>Last Name</strong></p></th><th colspan="1" rowspan="1"><p><strong>Email</strong></p></th><th colspan="1" rowspan="1"><p><strong>Phone</strong></p></th><th colspan="1" rowspan="1"><p><strong>Company</strong></p></th><th colspan="1" rowspan="1"><p><strong>Tags</strong></p></th><th colspan="1" rowspan="1"><p><strong>Status</strong></p></th><th colspan="1" rowspan="1"><p><strong>Created Date</strong></p></th></tr><tr><td colspan="1" rowspan="1"><p>Jane</p></td><td colspan="1" rowspan="1"><p>Doe</p></td><td colspan="1" rowspan="1"><p><a target="_blank" rel="noopener noreferrer nofollow" class="linktype-link link" data-linktype="link" href="mailto:jane@example.com">jane@example.com</a></p></td><td colspan="1" rowspan="1"><p>+11234567890</p></td><td colspan="1" rowspan="1"><p>Glow Med Spa</p></td><td colspan="1" rowspan="1"><p>VIP, Lead</p></td><td colspan="1" rowspan="1"><p>New</p></td><td colspan="1" rowspan="1"><p>01/01/2024</p></td></tr><tr><td colspan="1" rowspan="1"><p>John</p></td><td colspan="1" rowspan="1"><p>Smith</p></td><td colspan="1" rowspan="1"><p><a target="_blank" rel="noopener noreferrer nofollow" class="linktype-link link" data-linktype="link" href="mailto:john@example.com">john@example.com</a></p></td><td colspan="1" rowspan="1"><p>+15556667777</p></td><td colspan="1" rowspan="1"><p>Glow Med Spa</p></td><td colspan="1" rowspan="1"><p>Patient</p></td><td colspan="1" rowspan="1"><p>Active</p></td><td colspan="1" rowspan="1"><p>02/02/2024</p></td></tr></tbody></table>

### Field format rules

Follow these formatting rules so each column maps cleanly:

<table style="min-width: 50px;"><colgroup><col style="min-width: 25px;"><col style="min-width: 25px;"></colgroup><tbody><tr><th colspan="1" rowspan="1"><p><strong>Field type</strong></p></th><th colspan="1" rowspan="1"><p><strong>Accepted formats / notes</strong></p></th></tr><tr><td colspan="1" rowspan="1"><p>Date Picker (date fields)</p></td><td colspan="1" rowspan="1"><p><code>MM/DD/YYYY</code>, <code>YYYY/MM/DD</code>, <code>MM-DD-YYYY</code>, <code>YYYY-MM-DD</code>. In a recent update, substituting <code>/</code> with <code>-</code> or <code>.</code> may also be supported</p></td></tr><tr><td colspan="1" rowspan="1"><p>Multi-Select / Checkbox / Textbox List</p></td><td colspan="1" rowspan="1"><p>Separate values with commas, semicolons, or periods: <code>Blue, Yellow, Green</code> or <code>Blue; Yellow; Green</code>. Slashes are invalid</p></td></tr><tr><td colspan="1" rowspan="1"><p>Single Option / Radio</p></td><td colspan="1" rowspan="1"><p>One value only, e.g. <code>Blue</code></p></td></tr><tr><td colspan="1" rowspan="1"><p>Contact Owner</p></td><td colspan="1" rowspan="1"><p><code>FirstName LastName</code> or <code>LastName FirstName</code>, e.g. <code>Logan Paul</code>. Both first and last name must be present or the user will not be recognized</p></td></tr><tr><td colspan="1" rowspan="1"><p>Tags</p></td><td colspan="1" rowspan="1"><p>Separate with commas, semicolons, or periods: <code>Blue, Yellow, Green</code></p></td></tr><tr><td colspan="1" rowspan="1"><p>Do Not Disturb (DND)</p></td><td colspan="1" rowspan="1"><p><code>True</code>/<code>False</code> or <code>Yes</code>/<code>No</code></p></td></tr><tr><td colspan="1" rowspan="1"><p>Phone Number</p></td><td colspan="1" rowspan="1"><p>E.164 recommended: <code>+11234567890</code>. US numbers also accept <code>123-456-7890</code>, <code>(123) 456-7890</code>, or <code>1234567890</code></p></td></tr><tr><td colspan="1" rowspan="1"><p>Numerical</p></td><td colspan="1" rowspan="1"><p><code>1.23</code>, <code>1234</code>, <code>.123</code></p></td></tr><tr><td colspan="1" rowspan="1"><p>Monetary</p></td><td colspan="1" rowspan="1"><p><code>1234</code>, <code>1,234,234.33</code></p></td></tr><tr><td colspan="1" rowspan="1"><p>Additional Emails</p></td><td colspan="1" rowspan="1"><p>Comma-separated in their own column: <code>abc@email.com, abc1@email.com</code></p></td></tr><tr><td colspan="1" rowspan="1"><p>Additional Phone Numbers</p></td><td colspan="1" rowspan="1"><p>Comma-separated in their own column: <code>+17877123460, +17877123461</code></p></td></tr><tr><td colspan="1" rowspan="1"><p>File Upload / Signature</p></td><td colspan="1" rowspan="1"><p>Not supported in imports</p></td></tr></tbody></table>

For international phone numbers, you can verify formatting at libphonenumber.appspot.com before uploading.

If your CSV includes a **Country** field, the value must match an accepted country name or short code exactly (for example, `United States`, not `USA` or `U.S.`). Aesthetix CRM supports the full standard list of countries and global timezones during import; timezone values are also case-sensitive and must match exactly (for example, `America/New_York`).

Before importing, make sure any custom fields you want to populate already exist in your account using the same labels and data types, and remove blank rows and columns to avoid unexpected behavior.

## Adding a Tag to an Import

Tags help you organize and segment imported contacts. There are two ways to apply them.

> **Be careful adding tags during an import.** Many workflows are triggered when a tag is added to a contact. If you add a Tags column or apply a tag to the whole list during import, you can unintentionally enroll every imported contact into those tag-triggered workflows, which may send a flood of emails or texts. Before importing with tags, check whether any active workflow is triggered by the tags you plan to use, and pause those workflows or remove the tags from your file if needed.

### Option 1: Tag individual contacts via a Tags column

Use this when you want different tags on different contacts in the same list.

1.  Open the `.csv` file containing your contact list.
    
2.  Create a column titled **Tags** and enter as many tags as you want per row, separating each tag with a comma. These tags are created (if new) and applied to the matching contact records during import.
    

For example, if your file has four contacts and you want the tag `Test1` on all four but `TestTag` on only two, put `Test1, TestTag` in the Tags cell for those two rows and just `Test1` in the other two.

### Option 2: Tag the entire list during import

Use this when you want the same tag (or tags) applied to every contact in the import.

1.  Click **Contacts**.
    
2.  Start the **Import** process.
    
3.  Proceed to **Step 3: Details**.
    
4.  Click **Advanced**.
    
5.  In the tags field, enter the desired tags separated by commas. These tags are added to all contacts in the list.
    

For example, to add the tag `test` to every contact, simply enter `test`. You can add one or multiple tags, and you can use existing tags or create new ones during import.

## Importing Contacts and Opportunities Together

Aesthetix CRM can import contacts and opportunities at the same time from a single CSV, which is useful when you want patient records and their pipeline opportunities created in one pass.

### Prerequisites

-   **Admin access** is required.
    
-   The file must be **CSV (.csv)**, under **30 MB**, and contain **only one sheet**.
    
-   The first row must be a header row, with at least one header matching a system field.
    

### Common mistakes to avoid

-   Mismatched headers: ensure CSV headers match system fields.
    
-   Blank required fields: every row needs at least one of Name, Email, or Phone.
    
-   Special characters in phone numbers: remove spaces, dashes, or letters where they cause issues.
    
-   Duplicate records within the CSV: clean the list before importing.
    

### Steps

1.  Open the import flow from either the **Contacts** tab (Smart Lists, then **Import Contacts**) or the **Opportunities** tab (**Import** button, or the three-dot options menu). Both routes lead to the same process.
    
2.  **Choose what to import:** Contacts, Opportunities, or both Contacts and Opportunities at the same time. Click **Next**.
    
3.  **Upload your CSV file**, then click **Choose how to import** to decide whether to **Create**, **Update**, or **Create & Update** records. If an **Opportunity ID** is provided in the CSV, that opportunity is updated; if not, a new one is created.
    
4.  **Map columns to fields.** When importing both objects, make sure you select the correct object (Contacts or Opportunities) for each field you map. If contacts and opportunities are on the same line in the CSV, they are automatically linked to each other. This step also supports contacts with multiple email addresses and phone numbers, which are added automatically.
    
5.  **Review and complete.** Confirm your mappings. You can also choose to create a Smart List, add the contacts to a workflow, or add a new tag to the imported contacts. You must check the box confirming all the contacts/opportunities for import.
    

A few behavior notes:

-   Checking **Don't update empty values** prevents blank cells in your file from clearing fields that already have a value.
    
-   If you choose not to import a field, leave it unmapped and check the option to **not import data for unmapped columns** to proceed.
    
-   Contact de-duplication is set by default to match on **email first, then phone**. These settings are pulled from your global settings and cannot be changed during the import itself.
    

## Importing Companies & Custom Objects via CSV

You can bulk import **Companies** and **Custom Object records** using a CSV file, creating new records, updating existing ones, or both in a single import. This is useful when migrating data from another CRM, onboarding, or maintaining structured records at scale. Import supports **only CSV (.csv) files**; Excel (.xlsx) and Google Sheets links are not supported.

### Prerequisites

-   **User permissions:** Admin access is required.
    
-   **File requirements:** `.csv` format, maximum 30 MB, only one sheet/tab, a header row in the first row, and headers that match existing standard or custom fields.
    
-   **Field preparation:** required fields must contain valid values, custom fields must already exist in your account, and if updating records you must include the correct identifier (for example, Record ID).
    

### Common mistakes to avoid

-   Missing required fields
    
-   Blank primary field values
    
-   Incorrect Record IDs when using Update mode
    
-   Unique field conflicts
    
-   CSV headers that don't match field names
    

Always test with a small file first.

### Import modes

When uploading your CSV you choose one of three modes:

-   **Create:** creates new records only. Requires the Primary field. Existing records are not updated, and duplicate handling follows unique field rules if applicable.
    
-   **Update:** updates existing records only. Requires a Record ID or unique field (for custom objects). Rows without a matching Record ID or unique field are skipped.
    
-   **Create & Update:** creates new records and updates existing ones. If a Record ID or unique field matches, the record updates; if not, a new record is created. Unique field rules apply if configured.
    

### Steps

1.  **Navigate to Import.** For Companies, go to **Companies** and click **Import** in the top right. For Custom Objects, go to **Custom Object** and click **Import** in the top right.
    
2.  **Select the object.** Choose the Company or Custom Object you want to import. Only one Custom Object can be imported at a time.
    

![](https://staticfiles.us.gleap.ai/g/IzCo1Gl4GrVAvhZuyTsEtqRw39nwBPFVkkmrHlxWYbw7qdY7rZ0F7wdJ85Q6w7MSXX5fswONnYq.jpg)

3.  **Upload your CSV file.** Upload your CSV and choose your import mode.
    

![](https://staticfiles.us.gleap.ai/g/bGUZCLMgBzO4iMl4M4DJ0Xo3gkY5DuoUUIf0BBz6ydBNZCFOVXL3hSK98TKFN6uLvnL3raNYnBh.jpg)

If applicable, select the unique field to deduplicate on.

4.  **Map columns to fields.** Match each CSV column to the correct field. Required fields must be mapped, unmapped columns can be ignored, successfully mapped fields show a green indicator, and errors or warnings are highlighted.
    

![](https://staticfiles.us.gleap.ai/g/o0ATJzUO398nPr4UnViDX5GzKKvzuHKRqZnzllHI1zs6zuU9PHsWcTt2LDTIdlVUGKEbTbe9sHu.jpg)

The **Don't Update Empty Values** option controls blanks: when enabled, blank cells in your CSV will not overwrite existing values; when disabled, blank cells will clear existing values (except for restricted fields).

### Duplicate handling and unique fields

If your Company or Custom Object contains unique fields, you must select a Record ID or one unique field as the deduplication field when multiple are mapped. The system then checks other unique fields for conflicts, and if a non-selected unique field conflicts, that row fails. This keeps your data clean and conflict-free.

![](https://staticfiles.us.gleap.ai/g/yZxRg6tTrOBWIgmYIW1Mwl43E63c6rNjy8NVaxPYvJQnw2Ur1tuUfM5gRXiGuxPFUencJ17xEGT.jpg)

### Update empty values restrictions

The Primary field and any required fields cannot be updated to empty. These protections prevent accidental data loss.

## Troubleshooting Bulk Imports

Every import (contacts, opportunities, Companies, and Custom Objects) is tracked on the **Bulk Actions** page, where you can review results and resolve errors.

### Find and read the error log

1.  Click **Contacts**.
    
2.  Click **Bulk Actions**. Your import appears in the list here.
    
3.  Click **Show Status** (or **Show Stats**) on your import row.
    
4.  Any errors from the import are displayed here.
    
5.  Click the **three dots** on the row to access the logs.
    
6.  Select **Show Error Log**.
    
7.  Review the detailed error log, which includes the line number, Record ID, the primary field, the status, the error or warning message, and resolution guidance.
    

![](https://staticfiles.us.gleap.ai/g/BLGTO7zoB4T3oQMaJVethN35KEJ7PyYaR0MKuUKrhw6PTzp3Utak35c00b6WwZBkJ52OPENCG1X.jpg)

Import statistics are organized into tabs: **All**, **Success**, **Error**, and **Warning**. While an import is running you can also pause, resume, or cancel it from Bulk Actions.

![](https://staticfiles.us.gleap.ai/g/cViujuOv3qzaGUT0RZJHVAwhngb1UYMudtDuVW3fQkWCnhLPNGJl1y1xVmPZD4CphwN8cPDMRmP.jpg)

### Common errors and fixes

-   **Import failed entirely:** check the error messages on the import status page, download the error log, fix the flagged rows, and re-import the corrected CSV.
    
-   **Mismatched or unrecognized fields:** a column that does not match a system field is ignored unless you map it to an existing standard or custom field during import.
    
-   **Phone numbers rejected:** remove parentheses, dashes, and spaces, or reformat to E.164 (`+11234567890`). Some exported files (for example, from legacy systems) store phone numbers with `()` and `-` that must be cleaned by highlighting the entire phone column and removing those characters before importing, so the data is not corrupted.
    
-   **Contacts all set to Do Not Disturb:** if your CSV includes a **DND** column, DND is automatically applied to all channels (SMS, Email, Calls, Voicemail). To apply DND to specific channels only, leave the DND column out and use a workflow with tags instead.
    
-   **Notes not importing fully:** you can import only one note per contact, with a limit of 5,000 characters.
    
-   **Unique field conflict (Companies/Custom Objects):** only that row fails; the rest of the import continues.
    
-   **File too large:** split files over 30 MB into smaller files and import them separately.
    

Imports cannot be undone, so always validate your CSV before starting.

## Exporting Contacts

Exporting downloads your contacts to a CSV file you can back up, analyze, or migrate. The exported file includes details such as names, emails, phone numbers, tags, and selected custom fields. Only Admin users can export contacts.

### Steps

1.  Click **Contacts**, then open **Smart Lists**.
    
2.  Refine your selection with **Advanced Filters** if needed, then check the boxes next to the contacts you want to export. To export everything, click the checkbox beside the filter fields and choose **Select All Contacts**.
    
3.  (Optional) Click **Manage Fields** to check or uncheck which columns to include. The exported CSV contains only the columns currently visible in the Contacts table, so confirm your column settings before exporting.
    
4.  Click **More**, then **Export** (or click the three dots beside the **\+ Add Contact** button and choose **Export**).
    
5.  Confirm your selection in the export modal and click **Export**. You will see a message that the export has started.
    
6.  The export runs in the background, so you can keep working. Click **Check Progress** to watch it in Bulk Actions, or dismiss the message. You will get a notification when the file is ready.
    
7.  Go to **Contacts**, then **Bulk Actions**, and find your export row (Operation: Export, Status: Complete, with a file name). Click the **Download** (down arrow) icon to save the file to your device.
    

### Export notes and limits

-   Exports run asynchronously on the server, so large datasets process without freezing your screen.
    
-   Completed export files remain available for **30 days**, after which the download link is disabled.
    
-   Only Admin users can download completed exports.
    
-   A contact's latest note is truncated to 255 characters in the export, and exports do not include automation history (past emails, SMS logs).
    
-   Export contacts separately for each account or location; you can combine the resulting CSV files in a spreadsheet afterward.
    
-   Scheduled automatic exports are not available at this time.
    

## Migrating from Another Platform

If your scheduling, POS, EMR, or marketing system is not directly integrated with Aesthetix CRM, the recommended approach is a regular export from that system and an import into Aesthetix CRM. Syncing your client data this way lets you update contact type from Lead to Patient, update Patient Lifetime Value, improve lead-source reporting, enable marketing automation and personalization, and run bulk actions such as review requests.

### Onboarding contact migration

During onboarding, Aesthetix CRM performs a historical contact import so your database transfers accurately and efficiently.

**Timing:** Your contact export must be completed as part of the **Go-Live Prep Checklist** so your data is ready before your official Go-Live date.

**Where to submit:** Your onboarding manager provides an encrypted, secure cloud hosting link. Drag and drop your file(s) into the secure folder and the team handles the rest.

**What to provide:** A historical contacts spreadsheet in `.csv` or `.xlsx` format, exported from your current CRM, EMR/EHR, email marketing platform, SMS marketing system, or any other contact storage tool. You may provide up to two separate spreadsheets: one for leads and one for patients. Multi-location practices may provide one patient list and one lead list per location. Additional files can be self-imported or imported for an added fee.

**Matching and duplicate prevention:** Aesthetix CRM uses a strict protocol to prevent duplicates. Contacts are created or updated based on **Email Address** and **Phone Number**, and a unique identifier (email or phone) is required to create a new record. Duplicate contacts are not allowed. When multiple lists are provided, marketing-system contacts are imported first as **Leads** and your EMR list is imported second as **Patients**, which produces the most accurate contact classification.

**Fields to include:**

-   **Required:** Email Address or Phone Number (unique identifier), and Subscribed/Unsubscribed status. First Name, Last Name, Email Address, Phone Number, and Type of Contact (Lead or Patient) are also requested.
    
-   **Optional:** Lead Source, Location, Treatment of Interest, Patient Lifetime Value, User Assignment, New Lead Date, Patient Since.
    
-   **Custom fields:** Aesthetix CRM will configure up to three new custom fields complimentary for your initial import. For additional custom fields, contact your Onboarding Manager or email [support@aesthetixcrm.com](mailto:support@aesthetixcrm.com) to coordinate a quote.
    

**Contact types:** A **Lead** is someone who has never visited your practice. A **Patient** is a contact who has completed an appointment.

**Smart Lists:** During onboarding, Aesthetix CRM automatically builds Smart Lists for Leads, Patients, Mass SMS, and Mass Email. Smart Lists let you filter and segment contacts by custom fields, tags, activity, lead status, and more.

### Importing from Vagaro

If you use Vagaro for scheduling and POS, export regularly and import into Aesthetix CRM:

1.  Export a Vagaro report (`.csv`) for the time period since your last import.
    
2.  Add a column titled **Type of Contact** and enter `Patient` for all records.
    
3.  Import the `.csv` into Contacts.
    
4.  Map the data fields.
    
5.  Choose your import settings: uncheck **Don't update empty values for existing records**, and add tags such as `patient` and `send review`.
    
6.  Submit and review the list from Bulk Actions.
    

### Importing from Nextech

If you use Nextech EMR, run a regular data reconciliation by exporting from Nextech and importing into Aesthetix CRM:

1.  Export the report from Nextech.
    
2.  Format the file: align it to your import template, format the date columns, confirm email addresses, and save as `.csv`.
    
3.  Import into Aesthetix CRM: map the fields, and under **Advanced** uncheck **Don't update empty values for existing records**.
    
4.  Enroll the import in a workflow that uses the Next Appointment and Procedure Date so it updates opportunities for Consult Booked and/or Surgery Scheduled.
    

### Migrating directly from HubSpot

If you are moving from HubSpot, Aesthetix CRM also includes a dedicated importer that connects to your HubSpot account and brings your data over directly, so you do not need to build and clean a manual CSV export first.

The HubSpot importer can bring over Contacts, Opportunities (converted from HubSpot Deals), Companies, Custom Fields (mapped from HubSpot Contact and Deal Properties), Custom Folders, Pipelines and Stages, Emails, Notes, and Tasks. Supported pipeline and stage structure carries over with your imported Opportunities, and the import finishes with a report showing what imported successfully, what failed, and what may need review so you can spot and fix issues.

Before starting a HubSpot import:

-   Import into a clean account when possible. Data that was already created manually in the account makes duplicates and errors harder to review.
    
-   Turn on **Allow duplicates** for both Contacts and Opportunities before you begin, then re-enable duplicate blocking once the import finishes. Leaving duplicate blocking on during a HubSpot import causes a lot of avoidable errors.
    
-   The import runs in the background, so you can close the window and check back on its progress later.
    
-   Set your account language to English before importing.
    
-   Test the import in a new or non-production location before running it against a location you actively use.
    

For any HubSpot data the importer does not support, fall back to the general CSV export and import process described earlier in this article.

## Frequently Asked Questions

**Who can import and export contacts?** Only Admin users can import or export contacts.

**What file format and size are supported?** CSV (`.csv`) only, one sheet per file, with a header row, and under 30 MB. Split larger files into smaller ones.

**Can I import contacts with more than one phone number or email?** Yes. Put additional values in separate columns (for example, Additional Phone Numbers and Additional Emails) and separate entries with commas. They are stored as secondary fields rather than replacing the primary value.

**How does Aesthetix CRM handle duplicates?** Based on your duplicate-detection settings, it matches by Contact ID, email, or phone (email first, then phone by default) and either updates the existing record or skips it instead of creating a duplicate.

**Can I update existing contacts with a CSV import?** Yes. Choose Update or Create & Update during import, and include a field used for matching (Contact ID, email, or phone).

**What happens if I include a column that doesn't exist as a field?** It is ignored unless you map it to an existing standard or custom field during import.

**Why are all my imported contacts set to Do Not Disturb?** A DND column applies DND to all channels automatically. To set DND for specific channels only, omit the DND column and use a workflow with tags.

**Can I undo an import?** No. Imports cannot be reversed, so always validate your CSV before starting.

**My import failed. What should I do?** Open Bulk Actions, read the error messages, download the error log, fix the flagged rows, and re-import the corrected CSV.

**How long are exported files available?** Export files are available for 30 days, after which the download link is disabled.

**Can I migrate directly from HubSpot instead of building a CSV?** Yes. A dedicated HubSpot importer connects to your HubSpot account and migrates Contacts, Opportunities, Companies, Custom Fields, Pipelines and Stages, Custom Folders, Emails, Notes, and Tasks without a manual CSV export. Turn on Allow duplicates for Contacts and Opportunities before you begin, and test in a non-production location first.

**How are new contacts added after onboarding?** Once your historical import is complete, new contacts can come in through many channels: manual entry, website forms, EMR integrations, Meta Instant Forms, Facebook Messenger and Instagram DMs (via Aesthetix CRM integrations), phone calls to your Aesthetix CRM number, text messages to your Aesthetix CRM number, the chat widget on your website, third-party automation tools (such as Zapier, Keragon, or Integrately), and inbound webhooks.

**How will my contact source(s) be displayed?** Aesthetix CRM supports a comprehensive list of contact sources. If you provide source data in your import file, it is displayed on the contact record. Moving forward, contact sources are assigned automatically by the channel each contact comes in through (see Contact Source Reporting and Campaign Tracking for details). UTM parameters are supported, workflow actions can assign or update the Contact Source automatically based on system triggers, and the Contact Source can also be updated manually by users.

## Need Help?

If you need help preparing your contact spreadsheets, configuring custom fields, or planning a migration, email [support@aesthetixcrm.com](mailto:support@aesthetixcrm.com). During onboarding, your Onboarding and Customer Success teams can guide you through the historical contact import end to end.
