How to Upload Exported Contacts File Csv Into Outlook

This tutorial talks near ii 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 accost book. For example, you inherited an external database with a list of contacts, or you lot are migrating from another mail server, or perhaps you are setting up a new account. Whatever the reason, Outlook provides a straightforward way to import all your contacts in ane get.

  • 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 data 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 than information, please see How to consign Outlook contacts to PST file.

CSV (Comma Separated Values). If you keep your contact information in Excel or another spreadsheet program or have exported your contacts from another email provider, such as Gmail or Yahoo Post, they will typically be in a .csv file, which can exist 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 not exist imported correctly. To prevent possible issues, export contacts into a CSV UTF-8 file if such an selection is available to you, 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 dissimilar listing separator is prepare by default. For example, in many European countries, the default list separator is the semicolon. Merely Outlook only supports the comma as a field separator, then y'all need to replace semicolons or any 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 consign 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 every bit follows:

Sample .csv file.

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 up & Export > Import/Consign.
    Start the Outlook Import/Export wizard.
  2. The Import and Consign wizard starts. You choose Import from another program or file and click Adjacent.
    Import from another program or file.
  3. To import CSV contacts to Outlook, choose Comma Separated Values and click Next.
    Import contacts from a CSV file.
  4. In this step, you demand to make a couple of choices:
    • Click the Scan push, notice and double-click your .csv file to select it.
    • Choose how to handle duplicate contact items.

    When done, click Adjacent.
    Choose how to handle duplicate contact items.

    How to handle duplicate contacts:

    • Replace duplicates with items imported. Choose this choice if the data in the .csv file is more than complete or more upwardly to engagement than the information in your Outlook.
    • Allow duplicates to exist created (default). If you do not want to lose a single bit of info, permit 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 only desire to import new contacts and go out all existing contacts intact.
  5. Under the target email business relationship, select the Contacts folder and click Next.
    Choose the folder into which to import contacts.
  6. If you are importing CSV contacts that you have previously exported from Outlook, the contact listing is in the required format, so you can click Terminate to get-go 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 keep with the adjacent step.
    Finish importing contacts or map custom fields.

  7. If you clicked the Map Custom Fields push button in the previous footstep, the corresponding dialog box volition announced:
    • In the left pane, nether From, you will see the cavalcade names from your CSV file.
    • In the right pane, under To, you will 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 nether Mapped from.

    If a column proper name does non match whatsoever Outlook field, you'll have to exercise manual mapping. For this, elevate 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, in that location is a column named Position and we are mapping it to the Job Title field. To observe a friction match, click the plus sign next to a suitable field in the correct pane to expand information technology.
    Mapping custom fields

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

  8. Outlook shows a progress box to permit you know that information technology has begun importing your contacts. When the progress box closes, the process is finished. When importing a very modest contact listing, the progress box may not prove 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 lot 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.
  • Yous are moving contacts from one computer to another.
  • You wish to transfer all Outlook items including emails, contacts, appointments and tasks.

In this instance, you showtime demand to export contacts into a PST file, and then import them to your new account or PC by using the Import & Export magician 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. Cull Outlook Information File (.pst) and click Next.
    Importing contacts from a PST file
  4. Click the Scan button and cull the .pst file that you want to import.

    Under Options, choose how to deal with duplicate items, and and so click Side by side. Please pay attention that when importing from PST, the default is Supercede duplicates with items imported.
    Choose how to deal with duplicate contact items.

  5. If your .pst file is protected with a countersign, y'all will exist asked to provide it.
  6. This is the key footstep for the contacts to exist imported correctly, and then please be sure to do it correct:
    • Under Select the folder to import from, select Outlook Information File if you want to import the PST in full. Or aggrandize it and choose 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 choose the Import items into the current folder selection. Otherwise, check Import items into the same folder in and choose the mailbox or Outlook Information File into which the contacts should be imported.
    • When done, click Stop.

    Choose the folder to import the contacts to.

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

Every bit with Outlook desktop, to import contacts to Outlook Online, you will demand a CSV file. For all-time results, the file should have UTF-viii encoding that works correctly for all languages.

To import contacts into Outlook Online, perform these steps:

  1. Sign into your Outlook on the spider web or Outlook.com account.
  2. At the lower-left corner of the folio, click the People icon:
    In the lower-left corner, click People.
  3. At the upper-correct corner of the page, click Manage> Import contacts.
    Importing contacts into Outlook Online
  4. Click the Browse button, select your CSV file and click Open.
  5. With the CSV file in the box, click Import.
    Choose a CSV file to import contacts from.

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

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

You may also be interested in

tollewhadming.blogspot.com

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

0 Response to "How to Upload Exported Contacts File Csv Into Outlook"

Post a Comment

Iklan Atas Artikel

Iklan Tengah Artikel 1

Iklan Tengah Artikel 2

Iklan Bawah Artikel