How to Upload Contacts to Constant Contact

Import contacts to Outlook

Outlook for Microsoft 365 Outlook 2021 Outlook 2019 Outlook 2016 Outlook 2013 Outlook Web App for Part 365 Office for business Microsoft 365 admin Outlook on the web Outlook 2010 Outlook on the web for Substitution Server 2016 More...Less

Outlook has an Import/Export wizard that makes it like shooting fish in a barrel to import contacts from a CSV file.

1. At the elevation of your Outlook ribbon, choose File.

   If your ribbon doesn't have a File option in the top left corner, you're using an older Outlook version. See What version of Outlook do I have? to get to the import instructions for your version of Outlook.

   

2. Choose Open & Export > Import/Export. This starts the sorcerer!

   

3. Cull Import from some other plan or file, and and then choose Next.

   

4. Cull Comma Separated Values, and and then choose Next.

   

5. In the Import a File box, browse to your contacts file, and so double-click to select it.

   

6. Choose ane of the following to specify how you desire Outlook to handle duplicate contacts:

   • Replace duplicates with items imported   If a contact is already in Outlook and your contacts file, Outlook discards the info information technology has for that contact and uses the info from your contacts file. You should cull this pick if the contact info in your contacts file is more consummate or more current than the contact info in Outlook.

   • Let duplicates to be created   If a contact is in Outlook and your contacts file, Outlook creates duplicate contacts, one with the original Outlook info and 1 with the info imported from your contacts file. You can combine info for those people after to eliminate duplicate contacts. This is the default pick.

   • Practice non import indistinguishable items If a contact is in Outlook and your contacts file, Outlook keeps the info information technology has for that contact and discards the info from your contacts file. Y'all should cull this selection if the contact info in Outlook is more consummate or more than current than the info in your contacts file.

7. Click Side by side.

8. In the Select a destination folder box, scroll to the top if needed and select the Contacts binder > Next. If y'all have multiple email accounts, cull the Contacts folder that'south under the email account you want to be associated with the contacts.

   

9. Cull Finish.

   

   Outlook begins importing your contacts immediately. You lot'll know information technology'southward finished when the Import Progress box closes.

10. To see your contacts, at the bottom of Outlook, cull the People icon.

    

1. At the top of your Outlook ribbon, cull the File tab.

   If your ribbon doesn't have a File selection in the top left corner, you're not using Outlook 2010. See What version of Outlook do I have? to get to the import instructions for your version of Outlook.

   

2. Cull Open > Import. This starts the sorcerer!

   

3. In the Import and Export Wizard, click Import from another program or file, and the click Next.

   

4. To import a CSV file, choose Comma Separated Values (Windows).

   

5. Choose Browse, then choose the .csv file you want to import, and cull Side by side.

   Notes:

   • Under Options, if you desire the imported information to replace duplicate items already in Outlook, choose that. Otherwise, choose Practice not import duplicates.

   • 

6. Set the options for importing items. Choose Filter if you lot want to only import certain emails. Choose the More Choices tab if you lot want to simply import emails that are read or unread.

   The default settings usually don't demand to be changed. The height folder — usually Personal Folders, Outlook Data File, or your email address — is selected automatically.

   

7. Include subfolders is selected by default. All folders under the folder selected volition be imported.

8. The default choice of Import items into the aforementioned folder in matches the folders from the imported file to the folders in Outlook. If a folder doesn't exist in Outlook, information technology will exist created.

9. Cull Stop. Outlook starts importing your data immediately. Y'all'll know information technology's finished when the progress box closes.

10. To view your contacts, at the bottom of the Outlook navigation bar, choose Contacts.

    

Utilize a comma separated values file (CSV) to import your contacts into your Outlook on the web account.

Tip:For best results, make sure that the CSV file has UTF-8 encoding. This encoding works for all languages and alphabets.

1. At the bottom of the page, select to go to the People page.

2. On the toolbar, select Manage > Import contacts.

   

3. Select Browse, choose your CSV file, and then select Open.

4. Select Import.

Note:If the file doesn't have UTF-8 encoding, the import tool may not recognize and display all text correctly. The import tool volition then show you some example contacts from your file, and y'all tin check that the text is readable and right. If the text is not displayed correctly, select Abolish. You lot volition need a file in UTF-8 encoding to proceed. Convert your CSV file to utilise UTF-8 encoding, and restart the import. To learn more about UTF-8 encoding, run across Why should I care almost UTF-viii encoding?

Why should I care about UTF-8 encoding?

Typically, you tin import contacts without worrying near the underlying details of how the text is stored in the CSV file. Nonetheless, if the contact information includes characters not found in the English alphabet, such as Greek, Cyrillic, Arabic, or Japanese characters, this tin can cause problems when importing contacts. Therefore, you should relieve the contacts file with UTF-viii encoding if y'all take that option during export.

If you can't export your contacts using UTF-8 straight, you can convert the exported CSV file using Excel or third-party apps. How to do this volition be different between apps and app versions.

How to convert your CSV file to UTF-8 using Microsoft Excel 2016:

1. In Excel, create a new bare document (workbook).

2. From the Data menu, select From Text/CSV. Browse to your exported CSV file (you may have to select to brandish Text Files (....csv) to see it). Select Import.

3. In the dialog box that appears, nether File Origin, cull the encoding that makes the characters in the text announced correctly, for example, Cyrillic Windows 1251, and then select Load.

4. Bank check that characters are displayed correctly in Excel.

5. Select File >Save As. Enter a proper name for your file, and select CSV UTF-8 (Comma delimited) (*.csv) as your file type.

6. Select Save.

Didn't work?

Run into Fix problems importing contacts to Outlook.

See Also

Import and export Outlook email, contacts, and agenda

Need more help?

ayalables1994.blogspot.com

Source: https://support.microsoft.com/en-us/office/import-contacts-to-outlook-bb796340-b58a-46c1-90c7-b549b8f3c5f8

Share this post