--- title: Can I bulk import contacts from a spreadsheet or CRM? description: Learn how to prepare and upload a CSV file to bulk import contacts into the Wetu Contact Manager, including field mapping and confirming your import. --- [![Wetu](https://knowledge.wetu.com/hubfs/Knowledge%20Base%20Header%20Media/Primary_withouttagline.png)](https://wetu.com) [Contact Us](mailto:support@wetu.com) [Skip to content](https://knowledge.wetu.com/can-i-bulk-import-contacts-from-a-spreadsheet-or-crm#main-content) Open main navigation Close main navigation How can we help you? - There are no suggestions because the search field is empty. 1. [Knowledgebase](https://knowledge.wetu.com/?hsLang=en) 2. [Contact Manager](https://knowledge.wetu.com/contact-manager?hsLang=en) 3. [Creating & Importing Contacts](https://knowledge.wetu.com/contact-manager?hsLang=en#creating-importing-contacts) October 8, 2026 # Can I bulk import contacts from a spreadsheet or CRM? ## Yes. You can upload a CSV file to add multiple contacts to the Contact Manager at once. Follow the steps below to prepare your file, upload it, and confirm your import. **Quick Links** \- [Prepare your CSV file](https://knowledge.wetu.com/can-i-bulk-import-contacts-from-a-spreadsheet-or-crm#Prepare_your_CSV_file) \- [Upload your CSV file](https://knowledge.wetu.com/can-i-bulk-import-contacts-from-a-spreadsheet-or-crm#Upload_your_CSV_file) \- [Mapping fields](https://knowledge.wetu.com/can-i-bulk-import-contacts-from-a-spreadsheet-or-crm#Mapping_fields) \- [Import your contacts](https://knowledge.wetu.com/can-i-bulk-import-contacts-from-a-spreadsheet-or-crm#Import_your_contacts) \- [Need Help?](https://knowledge.wetu.com/can-i-bulk-import-contacts-from-a-spreadsheet-or-crm#Need_help) ### **Prepare your CSV file** #### **Step 1** Make sure your CSV file includes the following columns: - Title - First Name - Last Name - Email - Secondary Email - Country - Passport Number - ID Number - Telephone Number - include the full international country code (*e.g.,* **+27 713 52 6187***)* ![Step 1](https://knowledge.wetu.com/hs-fs/hubfs/Knowledge%20Base%20Content/Contact%20Manager/bulk%20import%20contacts%20from%20a%20spreadsheet%20or%20CRM/Step%201.jpg?width=670&height=212&name=Step%201.jpg) **Note:** Save your Excel file as a **CSV (comma-delimited)** file before uploading. This ensures Wetu can read your data correctly and prevents errors.   [back to top](https://knowledge.wetu.com/can-i-bulk-import-contacts-from-a-spreadsheet-or-crm#back_to_top) ### **Upload your CSV file** #### **Step 2** Go to **Contact Manager** and click on **Import Contacts** in the top right-hand corner. ![Bulk import Contacts gif](https://knowledge.wetu.com/hs-fs/hubfs/Knowledge%20Base%20Content/Contact%20Manager/bulk%20import%20contacts%20from%20a%20spreadsheet%20or%20CRM/Bulk%20import%20Contacts%20gif.gif?width=670&height=482&name=Bulk%20import%20Contacts%20gif.gif) #### **Step 3** Prepare your file for import: 1. Right click on the saved CSV file 2. Open with **Notepad** 3. Select edit and click on **Replace** 4. replace **';'** with '**,**' 5. Click on **Replace All** 6. Save the file ![Updated step](https://knowledge.wetu.com/hs-fs/hubfs/Knowledge%20Base%20Content/Contact%20Manager/bulk%20import%20contacts%20from%20a%20spreadsheet%20or%20CRM/Updated%20step.gif?width=670&height=482&name=Updated%20step.gif) Drag and drop your CSV file into the upload area, ![4](https://knowledge.wetu.com/hs-fs/hubfs/Knowledge%20Base%20Content/Contact%20Manager/bulk%20import%20contacts%20from%20a%20spreadsheet%20or%20CRM/4.jpg?width=670&height=195&name=4.jpg) or click **Upload** to select the file manually. ![Note SS](https://knowledge.wetu.com/hs-fs/hubfs/Knowledge%20Base%20Content/Contact%20Manager/bulk%20import%20contacts%20from%20a%20spreadsheet%20or%20CRM/Note%20SS.jpg?width=670&height=482&name=Note%20SS.jpg) ![Step 4](https://knowledge.wetu.com/hs-fs/hubfs/Knowledge%20Base%20Content/Contact%20Manager/bulk%20import%20contacts%20from%20a%20spreadsheet%20or%20CRM/Step%204.jpg?width=670&height=193&name=Step%204.jpg) #### **Step 4** Select Next in the bottom right-hand corner to continue.  [back to top](https://knowledge.wetu.com/can-i-bulk-import-contacts-from-a-spreadsheet-or-crm#back_to_top) ### **Mapping fields** #### **Step 5** Match each column from your CSV to the corresponding field in the Contact Manager. Check the preview on the right to confirm the data looks correct before proceeding. ![Step 5](https://knowledge.wetu.com/hs-fs/hubfs/Knowledge%20Base%20Content/Contact%20Manager/bulk%20import%20contacts%20from%20a%20spreadsheet%20or%20CRM/Step%205.jpg?width=670&height=357&name=Step%205.jpg) If a field does not need to be imported, select **Do not map this field**. ![Step 6](https://knowledge.wetu.com/hs-fs/hubfs/Knowledge%20Base%20Content/Contact%20Manager/bulk%20import%20contacts%20from%20a%20spreadsheet%20or%20CRM/Step%206.jpg?width=670&height=482&name=Step%206.jpg) [back to top](https://knowledge.wetu.com/can-i-bulk-import-contacts-from-a-spreadsheet-or-crm#back_to_top) ### **Import your contacts** #### **Step 6** Once you are satisfied with the mapping, select **Import**. ![Step 7](https://knowledge.wetu.com/hs-fs/hubfs/Knowledge%20Base%20Content/Contact%20Manager/bulk%20import%20contacts%20from%20a%20spreadsheet%20or%20CRM/Step%207.jpg?width=670&height=482&name=Step%207.jpg) #### **Step 7** The confirmation screen will show: - Any errors that need to be addressed If there are any failed results, check your import file and try again. ![Step 8](https://knowledge.wetu.com/hs-fs/hubfs/Knowledge%20Base%20Content/Contact%20Manager/bulk%20import%20contacts%20from%20a%20spreadsheet%20or%20CRM/Step%208.jpg?width=670&height=482&name=Step%208.jpg) #### **Step 8** Your imported contacts will now appear in the **Contact Manager** dashboard.   [back to top](https://knowledge.wetu.com/can-i-bulk-import-contacts-from-a-spreadsheet-or-crm#back_to_top) ### **Need help?** \- Support: [support@wetu.com](mailto:support@wetu.com) \- Live chat: Available in your dashboard [back to top](https://knowledge.wetu.com/can-i-bulk-import-contacts-from-a-spreadsheet-or-crm#back_to_top) [![wetu-logo-white](https://knowledge.wetu.com/hs-fs/hubfs/Supplier%20Welcome%20Email/wetu-logo-white.png?width=117&height=50&name=wetu-logo-white.png "wetu-logo-white")](http://wetu.com) **Company** [About us](https://wetu.com/about-us) [Careers](https://wetu.com/careers) [Blog](https://wetu.com/blog) [Pricing](https://wetu.com/pricing-plans) [FAQ](https://wetu.com/frequently-asked-questions) [Contact us](https://wetu.com/contact-us) **Products** [Itinerary Builder](https://wetu.com/products) [Content Manager](https://wetu.com/products) [Product Manager](https://wetu.com/products) [TravelKey](https://wetu.com/products) **Solutions** [For DMCs and Operators](https://wetu.com/operators) [For Agents](https://wetu.com/agents) [For Suppliers](https://wetu.com/suppliers) © Copyright Wetu. All rights reserved. | [Terms & Conditions](https://wetu.com/terms-conditions) | [Privacy Notice](https://wetu.com/privacy-notice) | [Cookie Policy](https://wetu.com/cookie-policy)