How to Upload Long List of Emails to Outlook Address Book

Even in times of Facebook and WhatsApp, east-mails still play an important part. Especially in the business globe, electronic messages proceed to be an indispensable means of communication, and distribution lists and newsletters are still among the simplest tools for contacting a large user group with the least possible effort. The central component of e-mail traffic is a customer including an address volume in which all relevant contact data can be stored.

In the ranks of these mail clients, Microsoft Outlook has been a central player for more than two decades – also thank you to bang-up liberty in contact direction. The integrated import/export wizard, for example, enables you to easily import existing lists of contacts into Outlook. How is an address import prepared, and which steps are necessary?

Hosted Substitution with IONOS

The prefect solution for your business! Become the globe's leading electronic mail and agenda solution together with secure hosting from a single source!

25 GB electronic mail

Costless domain

24/vii back up

Contents

1. Importing Outlook contacts: What are the requirements?
2. Saving your spreadsheets as a CSV file
3. Importing contacts into Outlook: Step-past-step instructions for desktop clients and web app
   1. How to import contacts in Outlook 2016 and 2013
   2. Importing contacts in Outlook on the web – how it works
   3. How to import contacts in Outlook 2010

Importing Outlook contacts: What are the requirements?

There are different reasons why information technology is useful to import contacts into Outlook: Typically, you'll have external lists of contacts that you would similar to import into your Outlook accost volume. Notwithstanding, it's also possible that you'll desire to import contacts that you have previously exported from Outlook – for example, to create a backup or because you want to alter the version. In the latter case, the contact list already exists in the required import format CSV (the values in this file are divided by separators). If yous take your ain contact list, e.1000. in the form of an Excel spreadsheet, y'all must start save it in CSV format before you can import information technology into your Outlook accost book.

In order to protect your privacy, the video volition non load until you click on information technology.

Saving your spreadsheets every bit a CSV file

All common spreadsheets such as Microsoft Excel, OpenOffice, or LibreOffice Calc offer the option of saving workbooks as CSV files. For Excel users, for instance, this works as follows:

1. In the starting time step, click the worksheet that contains the contact information that yous want to import into the Outlook accost volume. Then navigate to the "File" tab and click "Save As."
2. Determine where you want to salve the file and open up the menu in the "File Type" field by clicking the small, downward-pointing triangle icon.
3. Locate and select "CSV (delimited)." Finally click "Save." Excel will inform you that some features of the workbook will be lost (due to the switch to CSV format), which you accept by clicking "OK."

CSV supports both the semicolon and the comma equally a separator – Outlook only supports the latter, so you should bank check whether your Excel contact list is structured accordingly earlier saving.

Importing contacts into Outlook: Step-past-step instructions for desktop clients and web app

If yous have the contacts you desire in CSV format, you lot can immediately start importing them into your Outlook accost volume. You do not demand any boosted software for this. The import/consign wizard of Microsoft Outlook is integrated by default, and supports the import without external tools or plugins. Depending on the current version of Outlook and whether yous are working with the desktop or the spider web customer, the process differs slightly. We have summarized the import process in the different editions of Outlook below for you lot.

How to import contacts in Outlook 2016 and 2013

Users of newer Outlook versions can find the import/export wizard in the "File" menu. The first step is to open information technology via the tab of the same name:

You'll find the tabs of Outlook 2016 in the upper card bar. The "File" tab is on the far left.

In the left bill of fare bar, navigate to "Open & Export," where you showtime the wizard past clicking on "Import/Export."

Using the "Open & Export" carte, y'all tin not only import contacts into Outlook, simply as well open up Outlook information files or calendar files.

In the start carte du jour of the import/export wizard y'all can select various actions. The activity "Import from another programme or file" required for the import is already marked past default, so that y'all only have to printing the "Next" button.

If the "Import from some other program or file" entry is not selected, click it in the Outlook import/export sorcerer.

Be sure to specify the correct file (the contact list CSV file) when searching.

Earlier you click "Next," you have the option of selecting one of iii import variants:

• Replace duplicates with items imported: If a contact already exists in Outlook, the listed information for this contact is discarded and replaced by the information from the import file.
• Allow duplicates (default option): If a contact already exists in Outlook, the import/export wizard creates a indistinguishable of this contact. Subsequently, you can combine the information in the address book or remove the desired version.
• Do not import indistinguishable items: If a contact already exists in Outlook, the data to import it is discarded.

Irrespective of the selection fabricated, yous will be prompted to specify the destination folder in the following bill of fare. Search for the entry "Contacts" and click on "Next."

If you lot use several email accounts, it is important that yous select the contacts binder of the business relationship into which y'all want to import the new Outlook contacts.

After a last click on "Finish", Outlook starts the import process.

Importing contacts in Outlook on the web – how it works

You can besides import new contacts into your Outlook address book in Outlook on the web. To do this, log on to the web application and and so click the small people icon in the toolbar in the bottom left:

Outlook on the spider web is often withal known under the old name Outlook Web App (OWA).

In the next pace, get to the "Manage" button and select the "Import contacts" entry.

In the "People" card of Outlook on the spider web, you can not only import Outlook contacts, just as well create new contacts or complete user groups and set favorites.

Subsequently, the import bill of fare opens in which you lot should specify the source of the contacts. As an alternative to Outlook, Gmail, Yahoo Mail, and Windows Alive Mail are available equally starting points. And then if you want to import contact lists from one of these three e-mail service services, y'all have the chance to do so at this betoken. For the CSV file we utilize in this tutorial, we need the import selection "Outlook 2010, 2013 or 2016":

The import process works for both newer versions or if y'all're importing Outlook 2010 contacts.

At present click "Browse" and specify the location where the CSV file with the new contact information is located. And so start the import process via the "Upload" button.

Outlook on the spider web summarizes how to import contacts from Outlook in a short tutorial.

How to import contacts in Outlook 2010

Outlook 2010 also has a feature to import contacts. However, as the user interface of the Microsoft e-mail client has inverse over the years, the path to the import/export sorcerer differs slightly from how it works in the newer versions of Outlook. The following footstep-past-step guide shows you how to import contacts in the 2010 edition:

1. Select the "File" tab and click on "Open" there. Finally, use the "Import" push to start the import/consign wizard.
2. Look for the activeness "Import from other programs or files" in the list, click on it and confirm your selection with "Side by side."
3. Specify "Comma Separated Values (Windows)" as the file type to import, and and so the location where the CSV file is stored. As with imports in Outlook 2013 and 2016, yous tin can likewise specify in this menu whether indistinguishable address entries are to be allowed or not allowed.
4. Select the "Contacts" folder to which you desire to add the new address data and start the process past clicking on "End."

" id="c198545">

In gild to protect your privacy, the video volition not load until you click on information technology.

Related manufactures

Sharing an Outlook Calendar: How to share appointments with your colleagues

Appointments are easier to schedule if you lot already know your colleague or business concern partner'southward calendar. The groupware Microsoft Outlook offers the option to share calendar information with other people, or share the entire calendar to view. What information you cull to disclose is up to you. We but tell you how to do it.

Outlook: How to use emojis in Outlook

A picture says more than than a thousand words – this saying too explains the immense popularity of emojis. Smileys, in item, have long shaped digital communication and are a way for the sender to convey how they are feeling to the addressee. While they began their life in chat rooms and text messenger services, emojis have long since become a pop means of expression in Outlook and the...

How to create and manage distribution lists in Outlook

Do you lot regularly send letters to specific groups of recipients? If and so, you tin can brand due east-mailing easier by creating preconfigured distribution lists in Outlook. You tin can create contact groups and distribution lists in the online version too equally the desktop version of Microsoft Outlook. This illustrated step-by-pace guide will prove yous how.

How to display calendar weeks in Outlook

Calendar week numbering is deactivated in the Outlook calendar by default. Follow our illustrated, pace-by-step instructions for how to display the agenda calendar week in Outlook, and find out how to show calendar week numbers in monthly view. This allows you to see at a glance which week your appointments fall into.

Google: Import contacts into Gmail, Google Workspace and Co.

If you are using a Google business relationship privately or for work, you can easily manage all of your contact data such as e-mail addresses and telephone numbers in a single place. Non only tin you lot save individual contacts manually, but there is besides a useful function assuasive you lot to import them from a contact data file. We will bear witness you how to import your contacts into Google services such every bit Gmail or Google...

gosmanfeliter.blogspot.com

Source: https://www.ionos.com/digitalguide/e-mail/technical-matters/import-contacts-to-outlook/

Share this post