<\/span>Techniques to Transfer Contacts from Excel to Microsoft Outlook<\/span><\/h2>\nGo through the instructions to transfer Excel file address book to MS Outlook.<\/p>\n
\n- Reach to in Microsoft Outlook\u2019s File <\/strong>menu<\/li>\n
- Select Open & Export<\/strong> option<\/li>\n
- From Import & Export wizard, hit on Import\/Export<\/strong><\/li>\n<\/ul>\n
![\"excel-2-outlook-1\"](\"https:\/\/www.gaintools.com\/how\/wp-content\/uploads\/2022\/08\/excel-2-outlook-1.jpg\")
<\/p>\n
\n- Pick Import from another program or file <\/strong>option under choose action to perform. Hit the Next <\/strong><\/li>\n
- Click the Next<\/strong><\/li>\n<\/ul>\n
![\"excel-2-outlook-2\"](\"https:\/\/www.gaintools.com\/how\/wp-content\/uploads\/2022\/08\/excel-2-outlook-2.jpg\")
<\/p>\n
\n- Hit the Browse <\/strong>button to pick desired .csv file<\/li>\n
- Go to Excel file that needs to import<\/li>\n
- Highlight the file that you need to import. Hit Next<\/strong><\/li>\n<\/ul>\n
![\"excel-2-outlook-3\"](\"https:\/\/www.gaintools.com\/how\/wp-content\/uploads\/2022\/08\/excel-2-outlook-3.jpg\")
<\/p>\n
\n- Make sure to choose \u201cDo not import duplicate items or replace duplicates with items imported\u201d <\/strong>under Options section.<\/li>\n<\/ul>\n
![\"excel-2-outlook-4\"](\"https:\/\/www.gaintools.com\/how\/wp-content\/uploads\/2022\/08\/excel-2-outlook-4.jpg\")
<\/p>\n
\n- Press the Next <\/strong>button to import Excel spreadsheet contacts to Outlook PST<\/li>\n
- Pick Contacts <\/strong> This is the folder where data will be imported<\/li>\n<\/ul>\n
![\"excel-to-outlook-5\"](\"https:\/\/www.gaintools.com\/how\/wp-content\/uploads\/2022\/08\/excel-to-outlook-5.jpg\")
<\/p>\n
\n- Hit Next <\/strong>and pick Map Custom Fields<\/strong><\/li>\n
- To map fields, drag items from source file on left side and drop them to destination field on right-hand side. Drag each item from right to left side to remove from mapping field.<\/li>\n<\/ul>\n
![\"excel-2-outlook-6\"](\"https:\/\/www.gaintools.com\/how\/wp-content\/uploads\/2022\/08\/excel-2-outlook-6.jpg\")
<\/p>\n
\n- Now, hit Ok <\/strong>and then Finish <\/strong> Now a new contact list that has imported data from Excel sheet.<\/li>\n<\/ul>\n
![\"excel-2-outlook-7\"](\"https:\/\/www.gaintools.com\/how\/wp-content\/uploads\/2022\/08\/excel-2-outlook-7.jpg\")
<\/p>\n
\n- Select new contact list and pick the New Contact Group <\/strong>button from the Home <\/strong>tab<\/li>\n
- Now, this will open create a new distribution list <\/strong>form<\/li>\n
- Type name for contact group inside Name <\/strong>field<\/li>\n
- Hit on Add Members <\/strong>and pick the option From Outlook contacts<\/strong><\/li>\n<\/ul>\n
![\"excel-2-outlook-8\"](\"https:\/\/www.gaintools.com\/how\/wp-content\/uploads\/2022\/08\/excel-2-outlook-8.png\")
<\/p>\n
\n- Tap to right corner and hit on drop-down arrow. Now, this will create name of second contact list<\/li>\n
- Click to pick first individual that must be present in this contact group<\/li>\n
- Hold Shift key and during this, click on last individual in the given list.<\/li>\n
- Highlight all names by click on Members <\/strong> Then, press OK <\/strong>button to import contacts from Excel file sheet to Outlook<\/li>\n
- This can add selected members to distribution list.<\/li>\n
- Lastly, click on Save <\/strong>and Close button<\/strong><\/li>\n<\/ul>\n