Outlook Export: 2013 & 2016, 2010, Office 365

Outlook Export: 2013 & 2016, 2010, Office 365

Outlook 2013 & Outlook 2016

  1. Open Outlook and click File.

    File Tab
  2. Click Open & Export > Import/Export.

  3. Select "Export to a file".
  4. Click Next.

    Export to a file Option and Next Button
  5. Select "Comma Separated Values".
  6. Click Next.

    Comma Separated Values Option and Next Button
  7. Select Contacts option under Personal Folders. 
  8. Click Next.

    Contacts Option and Next Button
  9. Click Browse and choose both a name and location for the exported file.
  10. Click Next.

    Browse Button and Next Button
  11. Click Finish.

    Finish Button



Outlook 2010

To export contacts from Outlook into a file:

  1. Open Outlook 2010 and click File Options.
  2. Click the Advanced tab and then click Export.
  3. Click the "Export to a File" option from the list and then click Next.
  4. Choose the "Comma Separated Values (Windows)" option from the list and then click Next.
  5. Choose the folder you’d like to export. To export all contacts click on the "Contacts" folder. Then click Next.
  6. Click Browse and then choose where this file should be saved on your computer. Enter a file name and then click OK.
  7. Click Next.
  8. Click Finish.

If your email addresses are stored in Groups or Distribution lists rather than stored as contacts, copying them from Outlook 2010 and pasting them into a spreadsheet is the best process to extract them.

  1. Open Outlook.
  2. Click Contacts on the left-hand menu.
  3. In the "Current View" window, click the List option.
  4. Select the contacts you want to copy. Use CTRL+click to select multiple contacts or CTRL+shift to select a range.
  5. Copy the selected contacts (CTRL+C).
  6. Paste the contacts into an Excel spreadsheet (CTRL+V).
  7. Save the file as XLS or CSV format.


Outlook 365

  1. Open Outlook 365 and click the Applications icon.
  2. Click People.

    Applications Icon and People Option
  3. Click Manage > Export contacts.

    Manage Drop-down Menu and Export contacts Option
  4. Select "All contacts" or select a folder of specific contacts.
  5. Click Export.

    Contacts from this folder Drop-down Menu and Export Button

      6.  Depending on your browser you'll be asked to either Open or Save the file.

Additional support:  Export contacts from Outlook

Data Disclaimers:

  1. Do not send data files via email.
  2. The cleanliness of data uploaded depends on the cleanliness of the source data.
  3. If data is in all caps, we will convert to proper case. Please know names such as "MCDONALD" will convert to "Mcdonald".
  4. Data should include first names, last names, account/client names, email addresses, phone numbers, and entity types. 
    1. Email addresses are extremely important.  This is how you will send your invites to Liscio.  Please include as many as possible!
  5. Mobile numbers must be classified as such in order to go under the Mobile Phone category.
  6. If no entity types (i.e. S-Corp, Partnership, Trust, etc.) are listed, accounts/clients will default to Individual or Organization. 
  7. Contacts cannot share an email address.
  8. Phone numbers without area codes cannot be imported.
  9. Duplicate Account Names and Contact Names can occur if they exist in source data.
  10. Certain fields, such as Bank Account, Notes, or Birthdates, cannot be imported.

    Contact Us

       Email:  support@liscio.me 
       Call Us: (765) 566-7127
       Hours: Monday - Friday | 8 AM - 8 PM EST
        Subscribe to our YouTube channel Liscio CX

      • Related Articles

      • Office Tools Workspace Export

        Click Contacts in top tab. Select Import/Export Contacts. Select Excel Import/Export. Select Export to Excel Spreadsheet. In Common Info select Company Name, First Name, Last Name, Email Address, Address1, Address 2, City, State, Zip, and Account ...
      • Gmail Export Instructions

        Open Gmail Contacts. Select Google apps, then choose Contacts. In the left panel, select More to display additional options. Select Export. To export an entire address book, select Contacts. Select the drop-down arrow to choose a Google Contacts ...
      • Liscio for Outlook

        Liscio integrates with Outlook! ​ With Liscio for Outlook, you can save time by: Responding to emails via Liscio. Turning an email into a task for your client, yourself, or your team. Sending a Zoom meeting invite from an email. Creating an internal ...
      • How to Create an Alias in Outlook

        Note: You must be a Firm Admin to create an alias.   In the admin center, go to the Users > Active users page. On the Active Users page, select the user > Manage email aliases. (This option will not appear if the person doesn't have a license ...
      • Out of Office Away Status

        The Away Status allows firm users to notify others when they are out of the office. When turned on, this global setting is made visible across the Liscio platform. Additionally, if clients or team members send messages, upload files, respond to ...