Export contacts from Outlook. What data is exported

Sometimes the user needs to change, supplement, transfer the list of contacts to the right person, transfer it to additional device. To make this convenient, Outlook has all the necessary tools.

How to transfer addresses from Outlook

How to export contacts

Data transfer methods vary depending on the version of the Outlook email client.

Export contacts from Outlook 2013

  1. To export data from Outlook 2013, open the program and in the “File” tab - “Open and Export” select “Import and Export”.
  2. The mail client will offer possible options. Click on the “Export to file” item.
  3. Select the folder you need to record information.

    Give the object you want to save a name and click the “Done” button.

You can test the new CSV file on your computer by opening it in Excel.

Export contacts from Outlook 2010

  1. Open Outlook 2010 and go to the File tab.

    Click File in the Control Panel at the top of the Outlook window

  2. The Outlook Options window will open. In the left horizontal menu click on “Advanced”.

    The “Export Wizard” will open, here select “Comma Separated Values ​​(Windows)”, this is another name for the CSV file. Click Next.

  3. Select the folder where the contact information will be stored.
  4. Wait until the information transfer process is completed.

When using the contents of transferred contacts in other email client products, you will need the “Outlook Data File (PST)” item.

Export contacts from Outlook 2007

  1. To transfer contacts from Outlook 2007, open the program and expand the File tab. In the list of functions, click "Import and Export".
  2. The “Import Wizard” will open, which will be needed to generate the document. Check "Export to file".
  3. In the window that opens, select “Comma Separated Values ​​(Windows).” Continue by clicking on the “Next” button.
  4. Designate a folder that will be the save location. Click on “Next”.
  5. Wait for the transfer process to complete.

How to transfer contacts from Outlook to Excel

No matter what version of Outlook, once you transfer the CSV file to your computer, you can open it in Excel.

Don't be alarmed if you see empty cells in your document. These are the positions that were not filled when the contact was still in Outlook. Not every person writes down all the information: o home phone, the name of the contact's organization or position.

After viewing the transferred file in Excel, do not save changes when closing. This may destroy the structure of the document and make it impossible to read.

How to Import Contacts in All Versions of Outlook

  1. The process of adding a CSV file to mail will be the same for everyone Outlook versions. This is done in the same way as exporting: “File” - “Open and Export” - “Import and Export”. In the Wizard, select Import from another program or file.

  2. After selecting an action, click Next. Wait for the transfer process to complete.

Import Internet addresses and mail into Outlook all versions

  1. To import contacts from Outlook, go to the Import and Export Wizard again. Select Import from another program or file.
  2. In the window that opens, click “Import Internet addresses and mail.”
  3. Choose from the two import options "Outlook Express 4.x, 5.x, 6.x or Windows mail».
  4. Click Next and wait while the contacts are imported.

Import from another program or file in any version of Outlook

  1. After selecting “Import from another program or file,” you can add contacts from the Lotus Organizer utility, as well as information from Access, Excel, or a simple text file. Select the program from which you plan to add contacts.
  2. A window will appear asking you to select parameters. If you want to create duplicates, click on the “Allow creation of duplicates” item.
  3. Select the folder where you want to get the information.
  4. Designate a location where the data will be stored.

Video: instructions for transferring contacts

Where is the address book located in Outlook?

All information about the address book, messages, calendars and notes is stored on the computer in archived form. If you need to find, copy or move it, it will be useful to know in which folders the required PST file is located:

  • drive:/Users/<имя пользователя>
  • drive:/Users/<имя пользователя>/Roaming/Local/Microsoft/Outlook;
  • drive:/Users/<имя пользователя>/Documents/Outlook Files;
  • drive:/Users/<имя пользователя>/My Documents/Outlook Files;
  • drive:/Documents and Settings/<имя пользователя>

If using IMAP, Microsoft Exchange or outlook.com, the place where your email information is saved is server space. Data is recorded in PAB format. In this case, you can find them here:

  • drive:/Users/<имя пользователя>/AppData/Local/Microsoft/Outlook;
  • drive:/Documents and Settings.

If you used an account Microsoft entry Exchange Server, then the “Offline Address Book” is located at the following addresses:

  • drive:/Users/<имя пользователя>/AppData/Local/Microsoft/Outlook;
  • drive:/Documents and Settings/<имя пользователя>/Local Settings/Application Data/Microsoft/Outlook.

Create an address book in Outlook

Once the address book has been created, you can add contacts to it.

How to add contacts in Outlook

Contacts store information about people. You can only enter an address email or fill in more information, such as phone numbers, person's photo, mailing address, work address.

After creating a systematized contacts folder, the program will find the one you need based on the first few letters and automatically fill in the email address.

Add a contact from an email message

First you need to open the received message, click right click mouse over the person's name and select "Add to Outlook Contacts". Fill in the required information according to the field names, then save.

Adding a contact from scratch

Video: instructions for adding contacts

How to create a mailing list in different versions of Outlook

To simultaneously send messages to several subscribers at once, we recommend using the Contact Group tool.

Create a distribution list in Outlook 2013


Create a distribution list in Outlook 2010

In the main menu work program select "Create a contact group". Fill in important information and save.

Select address book via “File” - “New” or use the command Ctrl+Shift+L

How many people you can send a message to at one time depends on the size of the name files. Approximately, the average number is 100 contacts.

Deleting contacts in Outlook

To prevent contacts from being duplicated, when importing them in the “Import Wizard”, do not forget to change the standard transfer settings “Allow the creation of duplicates” to another item that offers the option of replacing existing ones.

If the contacts have already doubled, then you can remove them in the “Contact List” by clicking on the “Phones” item. In the field that opens in front of you, you need to select duplicate contacts and then press DELETE.

If you uncheck the “automatically check for duplicate contacts” section in Contacts Options, Outlook will not track duplicate business cards when you select a person.

Main function Microsoft programs Outlook is an email service. In addition, it can perform the functions notebook and contact manager. After learning how to add, delete contacts, and create groups in your email Outlook client, the user can configure the program as it suits him, and with its help he will stay in touch with friends and colleagues.

Some operating room users Windows systems, or rather its official package Microsoft Office, ask one simple question. How to import contacts into Outlook? Typically, this is required when transferring data from computer to computer, or for example, when . Ours decided to write step by step instructions How to correctly import contacts in the Outlook email program.

This instruction is universal - after reading it to the end, you will see how simple it is. And you can transfer contacts in any version of the program - Outlook Express, 2003, 2007 and Outlook 2010. The main thing is to just read the article carefully.

In order to import contacts, you first need to export them. Exporting contacts from Outlook is a simple procedure, let's walk through it step by step. Actually, for this, you do not need to know where Outlook contacts are stored. Everything can be done through the program.

How to Export Contacts from Outlook

Let's learn how to copy contacts from outlook. Open Outlook and go:

File → Export and Import

Select export to file.

In the next menu item, you must select a file type, the values ​​of which are separated by commas. This is a CSV file. As you can see, here you can save data in another format, but we recommend sticking with the more common one.

Select a folder with recipients.

How to Import Contacts into Outlook

So, we have a file with data from the program. Let's import them. Again:

File → Export and Import

And select import from another program or file.

And since we saved our recipients in CSV format, we select the appropriate item when importing.

Specify the path where the file is located. And import contacts.

If you have already imported data before, then it most likely makes sense to check the “replace duplicates when importing” checkbox. Now you know how to copy and transfer contacts from Outlook. Read website!

This program allows you to quickly and easily import EML email message files into any mailboxes and Outlook and Exchange storage. All major Outlook account types are supported: POP3, IMAP, Exchange, Hotmail/Outlook.com (EAS), PST data files, and shared folders Exchange Server.

EML format is a popular way backup email, as well as transferring messages between different email clients and systems. For example, EML files can be obtained at Windows Live Mail, Mozilla Thunderbird, Mac Mail, Entourage, Eudora and most others mail programs. Since these programs do not support direct export of email messages to Outlook, the EML format is an excellent solution for migrating your data.

Our utility doesn't just import EML files into Outlook - it does it correctly, unlike other programs. When importing, all service headers of letters are saved, including “ bcc"(BCC). Moreover, the utility allows you to create Outlook existing folder structure with EML files on your disk. This will allow you to quickly and painlessly transfer all your mail from another email client or from backup copy while maintaining the entire folder structure.

Additional settings will allow you to import EML files selectively. For example, only containing (or not containing) attachments or limiting the size of imported files.

To save (export) messages in EML format, use our other utility. We also have utilities for importing and exporting messages using the MSG format (native to Outlook). If your task is to transfer messages between multiple Outlook instances, the priority is the MSG format or using the Export Outlook Folders to PST utility.

* This utility is intended for non-commercial home use only. It does not work in a domain environment. Some of the described functions and support for the domain environment are available only in the extended version of the utility.


Over the past couple of years, people have already begun to forget what Outlook Express is. But after the New Year, as part of the project to merge companies, 19 more branches came under our service (“what a stroke of luck”). During the integration process, it became clear that people have whatever they want; there are no policies, regulations or other instructions. One of these programs was Outlook Express (of course, there are also Thunderbolts and other email clients, but we haven’t gotten to that yet). Accordingly, a problem arose when transferring mail to Outlook 2010.

The algorithm that we decided to use is not the fastest, but without any problems:

We install Outlook 2010 on the same computer where Outlook Express is installed.

In Outlook 2010, open the tab File, press the button Open, and then - Import.

Will open Import and Export Wizard.

Select an item Import from another program or file and press the button Next.

A list will appear Select the file type to import:. Which option should you choose?

If you are using Outlook Express or Windows Mail, select Outlook Express 4.x5.x6.xorWindows mail and press the button Next.

In the window that opens, you are prompted to select mail client, from which the import will be performed. The application has already been selected previously. Does that mean you have to press a button? Next?

Yes. The window may indicate otherwise software, however, you must first select Microsoft Outlook Express or Mail Microsoft Windows , and only then press the button Next.

From this point on, you will need to check that the information you are importing from your account is specified correctly in the wizard. In this case, you must confirm the name that is used as the sender name. It is indicated in the field display name. If it is correct, you can press the button Next. If you need to change the name, do so and click Next.

After that, check your email address.

Check your mail server details.

Check your login information.

Check your account connection method.

This completes checking the settings.

After pressing the button Ready Another dialog box opens.

This means the import of your account settings is complete. After this, email messages and contacts are imported. If you press the button Yes, their import will begin.

This completes the setup itself.

Good job everyone!!!

You can use the same contacts in Google Gmail and Microsoft Outlook without manually adding them in both locations.

In this article

Import contacts from Google Gmail to Outlook

Export contacts from Outlook to Google Gmail

Before you export contacts from Outlook, it's helpful to differentiate between Outlook Address Book and Outlook contacts. Both are part of Outlook. However, the address book is a compilation from lists different addresses that can be stored in Outlook, such as Internet LDAP directories, Global Address List (GAL), or other third-party address books. Contacts is just one of the lists of addresses included in the address book. You can only export contacts directly from Outlook to Google Gmail.

    Open the tab File.

    Select an item Options.

    Select an item Additionally.

    In the section Export click the button Export.

    In the window Import and Export Wizard select Export to file and press the button Next.

    Select Comma separated value (DOS) and press the button Next.

    In the list of folders, select the contacts folder you want to export and click Next.

    Select a folder to temporarily save the file on your computer.

    Note: This file can be deleted after importing contacts into Google Gmail.

    Enter the name of the exported file and click the button Next.

    To add or remove fields to determine how contact information is saved in the new imported file, click Field Matching.

    Note: When you try to import data from another program or file, the button Field Matching in the dialog box Export to file may not be available. In the dialog box the following actions will be performed check the box Export, and then the button Field Matching available.

    More help custom field mapping

    1. In the field from drag the field you want to convert the shape to the Outlook field specified in the field To whom.

      • To view additional entries in the " from", press the button Back or Next.

        To remove all mappings, click the button Clear.

        To restore the original mappings, click Default.

    2. To display additional fields in field, click the plus sign (+) next to the field. For example, to display fields Street And City of business, click the plus sign (+) next to Work address.

    Click the button Ready.

    Sign in with your Google Gmail account.

    In the left column, select Contacts.

    On the right side of the screen, click the button Import.

    In the dialog box Importing contacts click the button Review.

    Select the file exported in step 10 and click Open.

    Click the button Import.

Share