How To Import Contacts Into Outlook 2013?

Import CSV Contacts into Outlook 2013

  1. Open Microsoft Outlook.
  2. Select “People” and “File.”
  3. Select “Open & Export.”
  4. Select “Import/Export.”
  5. Select “Import from another program or file” and “Next.”
  6. Select “Comma Separated Values” and “Next.”
  7. Select “Browse” and locate your CSV file.

https://www.youtube.com/watch?v=ky43UgKBYms

Contents

How do I import contacts into Outlook?

Import Contacts on Outlook.com

  1. Open the Applications Launcher and click People.
  2. Click Manage > Import contacts.
  3. Click Browse.
  4. Select the CSV file, then click Open.
  5. In the Import contacts dialog box, click Import.
  6. Your contacts are uploaded and imported to your Outlook.com email account.

Why can’t I import my contacts to Outlook?

So, if you see this error message, that might be the problem. Use Excel to open your . csv file and see whether there’s data in it. If there’s not, try exporting your contacts from your source email system again and then check whether there’s data in it before going through the steps to import the file to Outlook.

How do I import contacts into Microsoft Exchange?

Overview

  1. Overview.
  2. If you have your contact list saved in a .
  3. Import Contacts.
  4. Click the File tab.
  5. Import Contacts in Outlook/Exchange.
  6. Click Import from another program or file, and then click Next.
  7. In the Import a File dialog box, under Options, click one of the following:
  8. • Replace duplicates with items imported.

How do I import contacts into CSV file?

Navigate to the Google CSV file that you made in Excel. Double-click the file to select it and then click Open in the lower-right corner. Click Import. This imports all the contacts from the CSV file into your Google account.

How do I format a CSV file in Outlook contacts?

Select File > Save As. Use the drop-down box to select CSV (Comma delimited) (*. csv), give your file a name, and then select Save. You can now use this new CSV file to import your contacts into Outlook.

How do I convert a CSV file to PST?

In Outlook, click File > Open & Export > Import/Export. Choose Import from another program or file and click Next. Choose Outlook Data File (. pst) and click Next.

What is the difference between Outlook contacts and address book?

However, the Contacts feature is usually a list of external contacts, while the Address Book contains information for people who work in your company. This is a common setup in the business world because the Address Books are stored on an Exchange Server and can be shared with everyone in the company.

How do I mass add contacts in Outlook?

Bulk add contacts to contact group in Outlook<>

  1. Shift to the Contacts or People view and create a new contact group by clicking New Contact Group under Home tab in Outlook 2010 and 2013.
  2. In the Contact Group window, click Add Members > From Outlook Contacts under Contact Group tab.

How do I Import a list of email addresses to a distribution list in Outlook?

Importing contacts from Excel to Microsoft Outlook

  1. Arrange your contacts and their email addresses in consecutive cells.
  2. Select all the adjoining cells (A1:B5 in example) and choose Copy.
  3. Open Outlook.
  4. From the File menu, choose New.
  5. Select Distribution List.
  6. Give the list a Name.

How do I Import contacts from global address list to Outlook?

If you want to add contacts in the Exchange Global Address List to Outlook’s Contacts, open the Address Book (Ctrl+Shift+B) and select the GAL contacts (using either Shift+ or Ctrl+ to select multiple entries at once) then right-click or open the File menu, and choose Add to Contacts to create copies of the GAL

How do I import contacts into a zip file?

How to Import Contacts

  1. On the Contacts page, click Import Contacts.
  2. Download the .CSV template.
  3. Open the .CSV template in Excel.
  4. Keep the headers as they are.
  5. Copy and paste your contacts’ information into the template.
  6. Save as a .CSV.
  7. On the Contacts page, click Import Contacts.
  8. Upload your .CSV file.

How do you convert XLS to CSV?

Convert XLS to CSV

  1. Open the Import file. This can be done through a spreadsheet software such as Microsoft Excel or Google Sheets, but can also be done in TextEdit (Mac) or Notepad (Windows)
  2. Select File.
  3. Click Save As.
  4. Rename the file if you prefer then select . csv (Comma delimited.)
  5. Click Save.

How do I create a CSV file from Excel contacts?

Here’s how:

  1. In your workbook, click the worksheet with the contact information you want to import.
  2. Click File > Save As.
  3. Choose where to save your file.
  4. In the Save as type box, choose CSV (Comma delimited) (*.
  5. Click OK.
  6. Click Yes to have Excel save the current worksheet as a CSV file.
  7. Close the CSV file.

Where are my contacts in Outlook?

In Outlook, choose People at the bottom of the screen. By default, you see your personal contacts. To view other address books, in the Find group of the ribbon, choose Address Book. Use the drop-down list under Address Book to see all of the different address books and contacts lists in your organization.

How do I Import Google contacts into Outlook?

Import Gmail contacts to Outlook

  1. From your Gmail account, choose Gmail >Contacts.
  2. Select More >Export.
  3. Choose the contact group you want to export.
  4. Choose the export format Outlook CSV (for importing into Outlook or another application).
  5. Choose Export.

How do I Import iPhone contacts into Outlook?

In iTunes, in the source list, under Devices, click the entry for your iPhone or iPod touch. Click the Info tab. Under Contacts, click Sync contacts from, and then click Outlook.

How do I import CSV contacts into Outlook?

Use a comma separated values file (CSV) to import your contacts into your Outlook.com account.

  1. In Outlook.com, select. at the lower left corner of the page to go to the People page.
  2. On the far right of the toolbar, select Manage > Import contacts.
  3. Select Browse, choose your CSV file, and then select Open.
  4. Select Import.

What is the difference between a contact list and a group in Outlook?

There really is no difference between a contact group, contact list, email group, or distribution list when talking about Microsoft Outlook. The terms are used interchangeably.

How do you create a distribution list in Outlook 2013?

Instructions

  1. Open Outlook 2013.
  2. Click the Address Book button.
  3. Select the File tab, then click New Entry.
  4. Click New Contact Group, then click OK.
  5. Click Add Members, then choose the way you want to add contacts to your distribution list.
  6. Double-click on existing contacts and add new email-addresses as needed.

How do I email a contact group in Outlook?

Click People on the Navigation bar.

  1. On the Home tab, click New Contact Group.
  2. In the Contact Group box, enter the name of the group.
  3. Select each contact you want to add to the group and click Members.
  4. Sending an email to a contact group.
  5. On the Home tab, click New Email.
  6. In the new email message, click To.