--- title: Update Profiles via Excel Import description: Update multiple Lemontaps profiles at once via Excel import. Learn the difference between “Delete data from empty fields” and “Ignore empty fields,” and when to use each option. --- [Skip to content](https://support.lemontaps.com/en/update-profiles-via-excel-import#main-content) - [English](https://support.lemontaps.com/en/update-profiles-via-excel-import) - [Deutsch](https://support.lemontaps.com/de/profile-per-excel-import-aktualisieren) English Show submenu for translations ![Lemontaps Logo-Black (1)](https://support.lemontaps.com/hubfs/Lemontaps%20Logo-Black%20(1).svg) - Start - Produkte - Preise - Blog - Unternehmen Open main navigation Close main navigation - Start - Produkte - Preise - Blog - Unternehmen - - [English](https://support.lemontaps.com/en/update-profiles-via-excel-import) - [Deutsch](https://support.lemontaps.com/de/profile-per-excel-import-aktualisieren) English Show submenu for translations - [Contact us](mailto:support@lemontaps.com) [Contact us](mailto:support@lemontaps.com) How can we help you? - There are no suggestions because the search field is empty. 1. [Lemontaps Helpdesk](https://support.lemontaps.com/en?hsLang=en) 2. [Central User Management](https://support.lemontaps.com/en/central-user-management?hsLang=en) 3. [Bulk Management & Imports](https://support.lemontaps.com/en/central-user-management?hsLang=en#bulk-management-imports) June 29, 2026 # Update Profiles via Excel Import With the Excel import, you can update existing profiles in Lemontaps in bulk. There are two types of imports: 1. Update profiles (empty fields delete data) 2. Update profiles (empty fields are ignored) Both options are explained below: ### 1. Update Profiles (Empty Fields Delete Data) With this option, empty cells in your file are interpreted as deletions. **This means:** If a field (e.g., position) is filled in an existing profile and you upload an Excel file where this field is empty, the existing value will be removed. **Best suited for:** When you export a complete profile list from Lemontaps, edit it, and then re-import it fully. #### How it works: 1. Export existing profiles from Lemontaps Go to: [User Management → All user profiles](https://lemontaps.com/md/profiles) → Export → Excel This downloads a file with all profile data. ![](https://support.lemontaps.com/hs-fs/hubfs/image-png-Mar-16-2026-02-52-41-0161-PM.png?width=670&height=231&name=image-png-Mar-16-2026-02-52-41-0161-PM.png) 2. Edit the Excel file with your updates 3. Upload the file again via: [User Management → All user profiles](https://lemontaps.com/md/profiles) → Bulk Actions → "Update profiles (empty fields delete data)" ![](https://support.lemontaps.com/hs-fs/hubfs/image-png-Mar-16-2026-02-54-05-5912-PM.png?width=670&height=231&name=image-png-Mar-16-2026-02-54-05-5912-PM.png) ![](https://support.lemontaps.com/hs-fs/hubfs/image-png-Mar-16-2026-02-56-34-7002-PM.png?width=670&height=281&name=image-png-Mar-16-2026-02-56-34-7002-PM.png) 4. Map the columns to the corresponding profile fields ![](https://support.lemontaps.com/hs-fs/hubfs/image-png-Mar-16-2026-02-57-22-5192-PM.png?width=670&height=281&name=image-png-Mar-16-2026-02-57-22-5192-PM.png) 5. Review the data and start the import ![](https://support.lemontaps.com/hs-fs/hubfs/image-png-Mar-16-2026-02-58-06-5338-PM.png?width=670&height=281&name=image-png-Mar-16-2026-02-58-06-5338-PM.png) #### Important: Only use this option if your file contains all desired data. Empty fields will delete existing values.   --- ### 2. Update Profiles (Empty Fields Are Ignored) With this option, empty cells are ignored. **This means:** Existing values in profiles remain unchanged if the field is empty in your file. **Best suited for:** When you want to update or add data without removing any existing values. **How it works:** 1. Open the Excel importer via: [User Management → All user profiles](https://lemontaps.com/md/profiles) → Bulk Actions → "Update profiles (empty fields are ignored)" 2. Create your Excel file - Either create a new file - Or use the template provided in the popup ![Bildschirmfoto 2026-03-17 um 16.53.04](https://support.lemontaps.com/hs-fs/hubfs/Bildschirmfoto%202026-03-17%20um%2016.53.04.png?width=391&height=158&name=Bildschirmfoto%202026-03-17%20um%2016.53.04.png) - - **Important:** Each row must include **the user’s email address**. It is used as a unique identifier to match the data to the correct profiles in Lemontaps. - Fill in the columns with the information you want to update ![](https://support.lemontaps.com/hs-fs/hubfs/image-png-Mar-16-2026-03-00-52-5258-PM.png?width=586&height=63&name=image-png-Mar-16-2026-03-00-52-5258-PM.png) 3\. Upload the Excel file in the popup 4\. Map the columns to the corresponding profile fields ![](https://support.lemontaps.com/hs-fs/hubfs/image-png-Mar-16-2026-02-57-22-5192-PM.png?width=608&height=255&name=image-png-Mar-16-2026-02-57-22-5192-PM.png) 5\. Review the data and start the import ![](https://support.lemontaps.com/hs-fs/hubfs/image-png-Mar-16-2026-02-58-06-5338-PM.png?width=603&height=253&name=image-png-Mar-16-2026-02-58-06-5338-PM.png) **Important:** Empty fields will not overwrite existing data in this option.   --- ### Frequently Asked Questions **Why can’t I update account email addresses via Excel import?** Account email addresses cannot be updated in bulk because they are used as the unique identifier for the import process. For this reason, the “Account Email” field is not included in the Excel template. Any changes to account email addresses must be done manually.   - [Central User Management](https://support.lemontaps.com/en/central-user-management?hsLang=en#main-content) - [User Management](https://support.lemontaps.com/en/central-user-management?hsLang=en#user-management) - [Email & Communication](https://support.lemontaps.com/en/central-user-management?hsLang=en#email-communication) - [Roles, Permissions & Approvals](https://support.lemontaps.com/en/central-user-management?hsLang=en#roles-permissions-approvals) - [Manage Profile Content](https://support.lemontaps.com/en/central-user-management?hsLang=en#manage-profile-content) - [Bulk Management & Imports](https://support.lemontaps.com/en/central-user-management?hsLang=en#bulk-management-imports) - [Organization & structure](https://support.lemontaps.com/en/central-user-management?hsLang=en#organization-structure) - [White-Label](https://support.lemontaps.com/en/central-user-management?hsLang=en#white-label) - [Identity & Security](https://support.lemontaps.com/en/central-user-management?hsLang=en#identity-security) - [Integrations](https://support.lemontaps.com/en/integrations?hsLang=en#main-content) - [Identity & User Management](https://support.lemontaps.com/en/integrations?hsLang=en#identity-user-management) - [CRM Integrations](https://support.lemontaps.com/en/integrations?hsLang=en#crm-integrations) - [Other Integrations](https://support.lemontaps.com/en/integrations?hsLang=en#other-integrations) - [Digital Business Card](https://support.lemontaps.com/en/digital-business-card?hsLang=en#main-content) - [Share Digital Business Card](https://support.lemontaps.com/en/digital-business-card?hsLang=en#share-digital-business-card) - [Design & Layout](https://support.lemontaps.com/en/digital-business-card?hsLang=en#design-layout) - [NFC card](https://support.lemontaps.com/en/digital-business-card?hsLang=en#nfc-card) - [Lead capture](https://support.lemontaps.com/en/lead-capture?hsLang=en) - [Email signature](https://support.lemontaps.com/en/email-signature?hsLang=en#main-content) - [Centralized email signatures (Outlook)](https://support.lemontaps.com/en/email-signature?hsLang=en#centralized-email-signatures-outlook) - [Manual email signatures](https://support.lemontaps.com/en/email-signature?hsLang=en#manual-email-signatures) - [Email signature design](https://support.lemontaps.com/en/email-signature?hsLang=en#email-signature-design) - [Paper business card ordering system](https://support.lemontaps.com/en/paper-business-card-ordering-system?hsLang=en) - [Legal & Data Protection](https://support.lemontaps.com/en/legal-data-protection?hsLang=en) - [Troubleshooting & Problem Resolution](https://support.lemontaps.com/en/troubleshooting-problem-resolution?hsLang=en#main-content) - [Login & Access Issues](https://support.lemontaps.com/en/troubleshooting-problem-resolution?hsLang=en#login-access-issues) - [Email signature – issues](https://support.lemontaps.com/en/troubleshooting-problem-resolution?hsLang=en#email-signature-issues) - [Technical Diagnostics](https://support.lemontaps.com/en/troubleshooting-problem-resolution?hsLang=en#technical-diagnostics) - [Feature & Function Issues](https://support.lemontaps.com/en/troubleshooting-problem-resolution?hsLang=en#feature-function-issues) - [Paper Card Ordering System – Issues](https://support.lemontaps.com/en/troubleshooting-problem-resolution?hsLang=en#paper-card-ordering-system-issues) - [NFC & Hardware – Issues](https://support.lemontaps.com/en/troubleshooting-problem-resolution?hsLang=en#nfc-hardware-issues) - [SCIM problems](https://support.lemontaps.com/en/troubleshooting-problem-resolution?hsLang=en#scim-problems) - [Account & Security](https://support.lemontaps.com/en/account-security?hsLang=en#main-content) - [Account Settings](https://support.lemontaps.com/en/account-security?hsLang=en#account-settings) - [Billing & Subscription](https://support.lemontaps.com/en/billing-subscription?hsLang=en#main-content) - [Trial Period & Plans](https://support.lemontaps.com/en/billing-subscription?hsLang=en#trial-period-plans) - [Invoices & Payments](https://support.lemontaps.com/en/billing-subscription?hsLang=en#invoices-payments) - [Licenses & Cancellation](https://support.lemontaps.com/en/billing-subscription?hsLang=en#licenses-cancellation) # Lemon Innovation & Technology GmbH [mailto:support@lemontaps.com](mailto:support@lemontaps.com) Copyright © 2026, Lemon Innovation & Technology GmbH