How to Upload Contacts to Outlook Plus 2010

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

At that place may be different reasons why you may want to transfer contacts into your Outlook address book. For example, you inherited an external database with a list of contacts, or you are migrating from another mail service server, or perhaps yous are setting up a new business relationship. Any the reason, Outlook provides a straightforward mode to import all your contacts in one go.

• 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 Customer and other Microsoft software. In a .pst file, contacts are already in the correct format and require no further amendments.

For more information, delight come across How to export Outlook contacts to PST file.

CSV (Comma Separated Values). If yous keep your contact information in Excel or another spreadsheet plan or have exported your contacts from some other email provider, such as Gmail or Yahoo Mail, they will typically exist in a .csv file, which can be imported into Outlook with a few adjustments:

• If contact details incorporate some characters that do not exist in the English language alphabet, east.thou. Standard arabic, Cyrillic, Chinese or Japanese, such contacts may not exist imported correctly. To prevent possible issues, export contacts into a CSV UTF-8 file if such an choice is bachelor to yous, or catechumen CSV to UTF-viii with Excel.
• Make certain the values in your CSV file are separated past commas. Depending on your locale, a different list separator is set up by default. For example, in many European countries, the default list separator is the semicolon. But Outlook only supports the comma as a field separator, so you need to supercede semicolons or whatsoever other delimiters with commas earlier importing your CSV file into Outlook.

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

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

In its simplest grade, your .csv file may await 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 & Consign > Import/Export.
   
2. The Import and Consign wizard starts. Y'all 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, y'all need to brand a couple of choices:
   • Click the Scan push, detect and double-click your .csv file to select information technology.
   • Cull how to handle duplicate contact items.

   When done, click Side by side.
   

   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 appointment than the information in your Outlook.
   • Allow duplicates to be created (default). If yous 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 unmarried item.
   • Exercise not import duplicate items. This is the option to cull if you simply want to import new contacts and leave all existing contacts intact.
5. Under the target email account, select the Contacts folder and click Next.
   
6. If you are importing CSV contacts that you accept previously exported from Outlook, the contact list is in the required format, so you tin click Finish to start importing the contacts immediately.

   If you 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 case, click Map Custom Fields and continue with the next stride.
   

7. If you clicked the Map Custom Fields push button in the previous stride, the corresponding dialog box will appear:
   • In the left pane, under From, you will encounter the column names from your CSV file.
   • In the right pane, under To, you will come across 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 not friction match any Outlook field, you'll accept to do manual mapping. For this, drag the column from the left pane, and drop it side by side to the corresponding field in the correct pane. For example, in our imported CSV file, there is a cavalcade named Position and we are mapping it to the Chore Title field. To find a lucifer, click the plus sign adjacent to a suitable field in the correct pane to expand it.
   

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

8. Outlook shows a progress box to let yous know that it has begun importing your contacts. When the progress box closes, the procedure is finished. When importing a very small contact listing, the progress box may not show up.

To make certain 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, you may desire to import contacts from a PST file rather than CSV. It is especially useful when:

• You are transferring contacts from one Outlook business relationship to another.
• You are moving contacts from one computer to another.
• You wish to transfer all Outlook items including emails, contacts, appointments and tasks.

In this case, y'all get-go need to consign contacts into a PST file, and then import them to your new account or PC by using the Import & Export sorcerer discussed in the previous section.

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

1. In Outlook, click File > Open & Export > Import/Export.
2. Choose Import from some other programme or file and click Next.
3. Choose Outlook Data File (.pst) and click Adjacent.
   
4. Click the Scan push and cull the .pst file that yous want to import.

   Under Options, cull how to deal with indistinguishable items, and then click Next. Please pay attending that when importing from PST, the default is Supervene upon duplicates with items imported.
   

5. If your .pst file is protected with a password, you will exist asked to provide it.
6. This is the fundamental step for the contacts to be imported correctly, and so please be sure to do it right:
   • Under Select the folder to import from, select Outlook Data File if you lot want to import the PST in full. Or expand it and choose only a item subfolder to import, Contacts in our case.
   • If the target account/mailbox is currently selected in the Navigation pane, yous tin can cull the Import items into the current folder pick. Otherwise, check Import items into the same folder in and choose the mailbox or Outlook Data File into which the contacts should be imported.
   • When done, click Finish.

   

Outlook will kickoff importing the contacts correct off. When the progress box disappears, the import is completed.

As with Outlook desktop, to import contacts to Outlook Online, you lot will 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 folio, click Manage> Import contacts.
   
4. Click the Scan push, select your CSV file and click Open.
5. With the CSV file in the box, click Import.
   

If the .csv file contains whatever contacts that already exist in your Outlook account, duplicate items will exist created, but none of your existing contacts will be replaced or deleted.

That's how to import contacts into Outlook desktop and online. I thank you for reading and hope to see you on our blog adjacent calendar week!

Y'all may also be interested in

pylantphouter.blogspot.com

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

Share this post