> For the complete documentation index, see [llms.txt](https://help.mimeeq.com/llms.txt). Markdown versions of documentation pages are available by appending `.md` to page URLs; this page is available as [Markdown](https://help.mimeeq.com/users-and-permissions/users-and-contacts/import-and-export.md). # Import & Export Add or update companies and contacts in bulk instead of one by one. Learn how to prepare CSV files, import and export data, and fix common errors. Managing your contacts and companies efficiently is crucial for any business, and this guide provides detailed instructions for importing and exporting data using CSV files. Whether you're looking to bulk upload new contacts, update existing company information or export your data for backup purposes, you'll find step-by-step procedures and essential best practices. The guide covers everything from preparing your CSV files with the correct template structure to troubleshooting common import issues. {% hint style="info" %} Before importing contacts, you must have companies set up in your system first. The **Company Numeric ID** is a required field and must match existing company records in the system. {% endhint %} *** ## How to import companies with CSV {% stepper %} {% step %} ### Open the import 1. Navigate to the **Companies** tab. 2. Click the arrow (▼) on the **New** button. 3. Select **Import from CSV** from the dropdown menu. ![Import from CSV option in the New button dropdown on the Companies tab](https://621103948-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FsqWfi8ifBhTdkvf1vOlY%2Fuploads%2FNNY6TmsdaMBPz22sQrXx%2Fimport-61-new_1szwrjv.webp?alt=media) {% hint style="success" %} Quick tip: need to add just one company? Click **New** directly, no need to use the dropdown. {% endhint %} {% endstep %} {% step %} ### Prepare your company CSV 1. Use our Company CSV Template: [Download the template](https://d1bd8jihtqzqs4.cloudfront.net/help_articles/Company_Import_Template.csv) 2. Ensure all required fields are properly formatted. Only CSV format is accepted. | Field | Example | Note | | ----------------------- | ------------------- | ---------------------------------------------------------------------------------------------------------------------------------------------------------- | | **Company Numeric ID** | AUTO | Optional. System-generated, cannot be manually specified. Leave empty or use "AUTO" for new companies. To update existing companies, use their existing ID | | **Company Name** | Acme Corporation | Required | | **Status** | ACTIVE | Required. Must be either ACTIVE or INACTIVE | | **Address Street** | 123 Main Street | Optional | | **Address City** | New York | Optional | | **Address Zip Code** | 10001 | Optional | | **Address Country** | USA | Optional | | **Account Email** | | Optional. Company email address. Must be a valid email format (e.g. ). Use a semicolon ( ; ) to separate multiple emails | | **Account Work Number** | +1-555-345-6789 | Optional. Company phone number. Use a semicolon ( ; ) to separate multiple numbers | | **Currency** | EUR | Required. Must be supported by your account (e.g. EUR, PLN, USD) | | **Payment Terms** | Net 30 | Optional | | {% endstep %} | | | {% step %} ### Upload and import 1. Drag and drop or click to upload your CSV file. 2. Check **Update existing companies** if you want to update records with matching IDs. 3. Click **Import** to process.
#Update existing companiesWhat happens to companies with matching IDs
1CheckedUpdated with new information from your CSV
2UncheckedSkipped, even if you've changed their data in the CSV file
{% hint style="warning" %} If you don't check **Update existing companies** but your CSV contains companies that already exist in the system, those records will be skipped entirely and won't be updated. {% endhint %} ![Upload area and Update existing companies option in the import modal](https://621103948-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FsqWfi8ifBhTdkvf1vOlY%2Fuploads%2F2mwybWwA1fc4bgaTnL1w%2Fimport-7-new_jmnouo.webp?alt=media) {% endstep %} {% step %} ### Review the import results The results dashboard shows: * **Records Processed**: total number of companies in your CSV file * ✅ **Records Added**: new companies successfully created in the system * ✅ **Records Updated**: existing companies that were updated with new information (only if **Update existing companies** was checked) * ⏯️ **Records Skipped**: existing companies that were skipped because **Update existing companies** wasn't checked * 🔺 **Records Had Errors**: companies that couldn't be imported due to validation errors ![Company import results dashboard with record counts](https://621103948-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FsqWfi8ifBhTdkvf1vOlY%2Fuploads%2FVXozTf3SwjGKJh77MGMb%2Fimport-8-new_km88ac.webp?alt=media) If some records couldn't be imported: 1. Review errors in the data grid. 2. Hover over the warning icons for details. Common company errors: * Invalid status values (must be "ACTIVE" or "INACTIVE") * Unsupported currency codes (must be supported by your account) * Missing required fields (Company Name, Status, Currency) * Invalid Company Numeric ID (use "AUTO" or leave empty for new companies) {% endstep %} {% endstepper %} *** ## How to export companies to CSV 1. Go to the **Companies** tab. 2. Click **Export to CSV**. 3. A CSV file with all your companies is generated and downloaded. ![Export to CSV button on the Companies tab](https://621103948-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FsqWfi8ifBhTdkvf1vOlY%2Fuploads%2FpbijVmgJ4S90NzIxf6ub%2Fimport-91-new_on2n0w.webp?alt=media) *** ## How to import contacts with CSV {% stepper %} {% step %} ### Open the import 1. Navigate to the **Contacts** tab. 2. Click the arrow (▼) on the **New** button. 3. Select **Import from CSV** from the dropdown menu. ![Import from CSV option in the New button dropdown on the Contacts tab](https://621103948-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FsqWfi8ifBhTdkvf1vOlY%2Fuploads%2Fk2dDy94gCAn6w1qXwDiW%2Fimport-new_1dk1xsy.webp?alt=media) {% hint style="success" %} Quick tip: need to add just one contact? Click **New** directly, no need to use the dropdown. {% endhint %} {% endstep %} {% step %} ### Prepare your CSV file Before importing, you need to prepare your CSV file correctly: 1. Download and use our CSV Import Template: [Download the template](https://d1bd8jihtqzqs4.cloudfront.net/help_articles/Contact_Import_Template.csv) 2. Ensure your CSV includes all required fields. | Field | Example | Note | | ---------------------- | ------------------------- | -------------------------------------------------------------------------------------------------------------------------------------------------------- | | **Contact Numeric ID** | AUTO | Optional. System-generated, cannot be manually specified. Leave empty or use "AUTO" for new contacts. To update existing contacts, use their existing ID | | **First Name** | John | Required | | **Last Name** | Smith | Required | | **Emails** | | Optional. Work email address. Must be a valid email format (e.g. ). Use a semicolon ( ; ) to separate multiple emails | | **Phone Numbers** | +1-555-345-6789 | Optional. Work phone number. Use a semicolon ( ; ) to separate multiple numbers | | **Company Numeric ID** | 25 | Required. Must match an existing company ID | | **Status** | ACTIVE | Required. Must be either ACTIVE or INACTIVE | | **Address Street** | 123 Main Street | Optional | | **Address City** | New York | Optional | | **Address Zip Code** | 10001 | Optional | | **Address Country** | USA | Optional | | **LinkedIn Account** | linkedin.com/in/johnsmith | Optional. LinkedIn profile URL | | {% endstep %} | | | {% step %} ### Upload your CSV file In the **Import Contacts** modal, drag and drop your CSV file into the designated area, or click **Upload File** to browse and select your file. ![Upload area in the Import Contacts modal](https://621103948-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FsqWfi8ifBhTdkvf1vOlY%2Fuploads%2FsSoOTL65NQcrUeRpWClw%2Fimport-2-new_1y8r2ey.webp?alt=media) Before importing, you'll see an option to **Update existing contacts**:
#Update existing contactsWhat happens to contacts that already exist (based on their ID)
1CheckedWe update them with the new information from your CSV
2UncheckedWe skip them, even if you've changed their data in the CSV file. These records won't be updated and appear as skipped in your import results
{% hint style="success" %} Not sure? Leave it unchecked for your first import to avoid accidentally overwriting data. You can always run the import again with the box checked if you need to update existing records. {% endhint %} {% endstep %} {% step %} ### Import After uploading your file, you'll see a green success area with the file. Click **Import** to start processing your contacts. If there's an error, check your connection and try again. ![Uploaded CSV file shown in the green success area, ready to import](https://621103948-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FsqWfi8ifBhTdkvf1vOlY%2Fuploads%2FueCj7nqbpoTdRlvyLnEJ%2Fimport-3-new_1lj4xig.webp?alt=media) {% endstep %} {% step %} ### Review the import results After processing, the **Import Results** dashboard shows: * **Records Processed**: total number of records in your CSV file * ✅ **Records Added**: new contacts successfully created * ✅ **Records Updated**: existing contacts that were updated with new information (only if **Update existing contacts** was checked) * ⏯️ **Records Skipped**: existing contacts that were skipped because **Update existing contacts** wasn't checked * 🔺 **Records Had Errors**: contacts that couldn't be imported due to validation errors ![Contact import results dashboard with record counts](https://621103948-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FsqWfi8ifBhTdkvf1vOlY%2Fuploads%2FrzJ7LNWXZm3BSd7EZDdg%2Fimport-4-new_13ngrl8.webp?alt=media) If some records couldn't be imported: 1. Review the error data grid below the results. 2. Each error row shows the problematic record and a warning icon. Hover over the icon for detailed error information. 3. Click to download a CSV file containing only the failed records. 4. Correct the errors in the downloaded file. 5. Re-upload the corrected file. Common errors include: ID contains letters (must be numbers only), missing required fields (First Name, Last Name) or invalid data format. {% endstep %} {% endstepper %} *** ## How to export contacts to CSV 1. Go to the **Contacts** tab. 2. Click the **Export CSV** button. 3. Your contact list is instantly downloaded as a CSV file containing all current contacts. ![Export CSV button on the Contacts tab](https://621103948-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FsqWfi8ifBhTdkvf1vOlY%2Fuploads%2FuaxVMi4NiiS6YlYawt46%2Fimport-51-new_d8sfrq.webp?alt=media) *** ## Best practices for CSV operations 1. Always back up your data before performing bulk updates. 2. Test with a small batch first to ensure your CSV format is correct. 3. Review the template carefully to understand required fields and formats. 4. Use the update option cautiously, as it will overwrite existing data. 5. Keep your CSV files organised with clear naming conventions. *** ## Troubleshooting common issues * **Upload fails**: check the file format (must be .csv) and verify your internet connection * **All records show errors**: review the template format and ensure proper column headers * **ID errors**: ensure IDs contain only numbers, no letters or special characters * **Status errors**: use only accepted values (e.g. "ACTIVE" or "INACTIVE") * **Missing data errors**: fill in all required fields before importing *** ## Related articles
Invite Team MembersGive colleagues access to the Mimeeq dashboard.Invite Team Members
Invite PartnersInvite client users to view prices and save favourites.Invite Partners
--- # Agent Instructions This documentation is published with GitBook. GitBook is the documentation platform designed so that both humans and AI agents can read, navigate, and reason over technical content effectively. Learn more at gitbook.com. ## Querying This Documentation If you need additional information that is not directly available in this page, you can query the documentation dynamically by asking a question. Perform an HTTP GET request on the current page URL with the `ask` query parameter, and the optional `goal` query parameter: ``` GET https://help.mimeeq.com/users-and-permissions/users-and-contacts/import-and-export.md?ask=&goal= ``` `ask` is the immediate question: it should be specific, self-contained, and written in natural language. `goal` is optional and describes the broader end goal you are ultimately trying to accomplish on behalf of the user. GitBook uses it to tailor the answer towards what is most useful for that goal. The response will contain a direct answer to the question and relevant excerpts and sources from the documentation. Use this mechanism when the answer is not explicitly present in the current page, you need clarification or additional context, or you want to retrieve related documentation sections.