If I Upload a Csv File to Comcast Email Address Book Where Is It?

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

There may be unlike reasons why you lot may want to transfer contacts into your Outlook address book. For instance, yous inherited an external database with a list of contacts, or you are migrating from another mail server, or maybe y'all are setting upwards a new account. Any the reason, Outlook provides a straightforward way to import all your contacts in 1 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 Tabular array). It's a special file format for storing information in Outlook, Substitution Client and other Microsoft software. In a .pst file, contacts are already in the right format and crave no further amendments.

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

CSV (Comma Separated Values). If yous keep your contact information in Excel or another spreadsheet programme or have exported your contacts from another e-mail 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 contain some characters that do not exist in the English alphabet, e.g. Standard arabic, Cyrillic, Chinese or Japanese, such contacts may non be imported correctly. To prevent possible bug, consign contacts into a CSV UTF-8 file if such an selection is bachelor to y'all, or convert CSV to UTF-8 with Excel.
• Make sure the values in your CSV file are separated by commas. Depending on your locale, a unlike listing separator is set by default. For instance, in many European countries, the default list separator is the semicolon. Only Outlook only supports the comma as a field separator, and then yous need to supercede semicolons or whatever 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 export contacts from Outlook desktop
• How to export 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 wizard 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 Side by side.
   
4. In this step, you lot need to make a couple of choices:
   • Click the Browse button, find and double-click your .csv file to select it.
   • Choose how to handle duplicate contact items.

   When done, click Adjacent.
   

   How to handle indistinguishable contacts:

   • Supersede duplicates with items imported. Choose this option 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 non desire 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 particular.
   • Practise not import duplicate items. This is the option to choose if you simply want to import new contacts and leave all existing contacts intact.
5. Nether the target email account, select the Contacts binder and click Side by side.
   
6. If you are importing CSV contacts that yous have previously exported from Outlook, the contact listing is in the required format, so you tin can click End to start importing the contacts immediately.

   If yous 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 go on with the next step.
   

7. If y'all clicked the Map Custom Fields push in the previous footstep, the corresponding dialog box will appear:
   • In the left pane, under From, you volition see the column names from your CSV file.
   • In the right pane, nether 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 proper noun does non match any Outlook field, you'll have to do manual mapping. For this, elevate the cavalcade from the left pane, and drop it next to the corresponding field in the right pane. For example, in our imported CSV file, there is a column named Position and we are mapping it to the Job Title field. To find a match, click the plus sign next to a suitable field in the right pane to aggrandize information technology.
   

   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 it 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 bear witness up.

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

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

In this case, 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 section.

Here 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 another program or file and click Next.
3. Choose Outlook Information File (.pst) and click Adjacent.
   
4. Click the Browse push button and choose the .pst file that yous want to import.

   Under Options, cull how to deal with duplicate items, so click Side by side. 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 countersign, you will be asked to provide it.
6. This is the key stride for the contacts to be imported correctly, and then please be certain to do information technology correct:
   • Under Select the folder to import from, select Outlook Data File if you want to import the PST in total. Or expand it and cull only a particular subfolder to import, Contacts in our case.
   • If the target business relationship/mailbox is currently selected in the Navigation pane, you tin can cull the Import items into the current binder choice. Otherwise, check Import items into the aforementioned binder in and choose the mailbox or Outlook Data File into which the contacts should be imported.
   • When washed, click Finish.

   

Outlook will 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, you will demand 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 business relationship.
2. At the lower-left corner of the folio, 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.
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 volition be created, but none of your existing contacts volition be replaced or deleted.

That's how to import contacts into Outlook desktop and online. I cheers for reading and hope to see y'all on our blog next calendar week!

You may besides be interested in

ortizoblee1979.blogspot.com

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