How to Upload Contacts to Microsoft Outlook

This tutorial talks about 2 means to import contacts into Outlook desktop, from .csv and .pst file, and shows how to transfer contacts to Outlook Online.

There may be different reasons why y'all may want to transfer contacts into your Outlook address book. For example, yous inherited an external database with a list of contacts, or you are migrating from another post server, or perhaps y'all are setting upward a new account. Whatever the reason, Outlook provides a straightforward fashion to import all your contacts in one become.

• Preparing contacts for importing into Outlook
• Importing contacts to Outlook from CSV file
• Importing contacts to Outlook from PST file
• Importing contacts to Outlook Online

Microsoft Outlook allows importing contacts from two file types, PST and CSV.

PST (Personal Storage Table). It's a special file format for storing information in Outlook, Exchange Client and other Microsoft software. In a .pst file, contacts are already in the right format and require no farther amendments.

For more information, please see How to export Outlook contacts to PST file.

CSV (Comma Separated Values). If you keep your contact information in Excel or another spreadsheet programme or have exported your contacts from another electronic mail provider, such equally Gmail or Yahoo Mail, they will typically exist in a .csv file, which can exist imported into Outlook with a few adjustments:

• If contact details contain some characters that do non exist in the English alphabet, due east.one thousand. Arabic, Cyrillic, Chinese or Japanese, such contacts may not be imported correctly. To prevent possible issues, consign contacts into a CSV UTF-viii file if such an choice is available to yous, or catechumen CSV to UTF-8 with Excel.
• Make sure the values in your CSV file are separated past commas. Depending on your locale, a different list separator is set past default. For example, in many European countries, the default listing separator is the semicolon. But Outlook only supports the comma as a field separator, so you lot need to replace semicolons or whatsoever other delimiters with commas earlier importing your CSV file into Outlook.

In the below linked tutorials, volition find the detailed guidance on exporting contacts to a CSV file:

• How to consign contacts from Outlook desktop
• How to consign contacts from Outlook Online
• How to export contacts from Excel
• How to export contacts from Gmail

In its simplest form, your .csv file may look as follows:

To import contacts from a CSV file into Outlook 2019, Outlook 2016 or Outlook 2013, carry out these steps:

1. In Microsoft Outlook, click File > Open & Export > Import/Export.
   
2. The Import and Export magician starts. You choose Import from another program or file and click Next.
   
3. To import CSV contacts to Outlook, choose Comma Separated Values and click Next.
   
4. In this step, yous need to brand a couple of choices:
   • Click the Browse push, find and double-click your .csv file to select it.
   • Choose how to handle indistinguishable contact items.

   When done, click Next.
   

   How to handle duplicate contacts:

   • Replace duplicates with items imported. Choose this selection if the information in the .csv file is more complete or more up to date than the information in your Outlook.
   • Let duplicates to exist created (default). If you do not want to lose a single bit of info, allow Outlook to create duplicate items, review them, and combine the details for the same person into a single item.
   • Do not import duplicate items. This is the pick to choose if you just want to import new contacts and leave all existing contacts intact.
5. Nether the target email business relationship, select the Contacts folder and click Side by side.
   
6. If you are importing CSV contacts that y'all have previously exported from Outlook, the contact list is in the required format, and so yous can click Finish to start importing the contacts immediately.

   If y'all are importing contacts from Excel or from a mail app other than Outlook, you may need to map some columns in your CSV file to the Outlook contact fields. In this instance, click Map Custom Fields and continue with the next step.
   

7. If you clicked the Map Custom Fields button in the previous step, the corresponding dialog box will appear:
   • In the left pane, under From, you will meet the column names from your CSV file.
   • In the right pane, under To, you volition see the standard Outlook contacts fields.

   If a column name in the CSV file exactly matches an Outlook field, the column is mapped automatically and appears under Mapped from.

   If a column name does non match any Outlook field, you'll have to do manual mapping. For this, drag the column from the left pane, and drop information technology adjacent to the corresponding field in the right pane. For example, in our imported CSV file, there is a cavalcade named Position and nosotros are mapping it to the Task Title field. To find a match, click the plus sign adjacent to a suitable field in the right pane to expand it.
   

   When all the columns are mapped, click OK, and back in the Import a File dialog box, click Finish.

8. Outlook shows a progress box to let you know that information technology has begun importing your contacts. When the progress box closes, the process is finished. When importing a very small contact list, the progress box may non show upward.

To make sure all your CSV contacts have been imported into Outlook, click the People icon on the Navigation bar to view your contact list.

In some situations, y'all may want to import contacts from a PST file rather than CSV. It is especially useful when:

• Yous are transferring contacts from one Outlook account to some other.
• You are moving contacts from one estimator to some other.
• Yous wish to transfer all Outlook items including emails, contacts, appointments and tasks.

In this example, you first need to export contacts into a PST file, and then import them to your new account or PC by using the Import & Export wizard discussed in the previous department.

Here are the steps to import contacts into Outlook from a .pst file:

1. In Outlook, click File > Open & Export > Import/Consign.
2. Choose Import from another program or file and click Next.
3. Choose Outlook Data File (.pst) and click Adjacent.
   
4. Click the Browse push and choose the .pst file that you lot want to import.

   Under Options, choose how to deal with duplicate items, and then click Next. Please pay attending that when importing from PST, the default is Replace duplicates with items imported.
   

5. If your .pst file is protected with a password, you will be asked to provide it.
6. This is the key pace for the contacts to be imported correctly, and then please be sure to do information technology right:
   • Nether Select the folder to import from, select Outlook Data File if you want to import the PST in full. Or expand it and choose simply a particular subfolder to import, Contacts in our case.
   • If the target account/mailbox is currently selected in the Navigation pane, yous can cull the Import items into the current folder option. Otherwise, bank check Import items into the aforementioned folder in and cull the mailbox or Outlook Information File into which the contacts should be imported.
   • When done, click Finish.

   

Outlook volition start importing the contacts right off. When the progress box disappears, the import is completed.

As with Outlook desktop, to import contacts to Outlook Online, yous volition need a CSV file. For best results, the file should have UTF-8 encoding that works correctly for all languages.

To import contacts into Outlook Online, perform these steps:

1. Sign into your Outlook on the web or Outlook.com account.
2. At the lower-left corner of the page, click the People icon:
   
3. At the upper-right corner of the page, click Manage> Import contacts.
   
4. Click the Browse button, select your CSV file and click Open up.
5. With the CSV file in the box, click Import.
   

If the .csv file contains any contacts that already exist in your Outlook business relationship, duplicate items will be created, only none of your existing contacts will exist replaced or deleted.

That's how to import contacts into Outlook desktop and online. I thanks for reading and hope to see you on our web log next calendar week!

You may besides exist interested in

fitchetttram1965.blogspot.com

Source: https://www.ablebits.com/office-addins-blog/2020/01/15/import-outlook-contacts/

Share this post