{"id":100,"date":"2018-05-04T07:20:39","date_gmt":"2018-05-04T12:50:39","guid":{"rendered":"http:\/\/www.office365import.com\/blog\/?p=100"},"modified":"2026-03-25T00:41:24","modified_gmt":"2026-03-25T06:11:24","slug":"export-exchange-global-address-book-outlook-2010","status":"publish","type":"post","link":"https:\/\/www.office365import.com\/blog\/export-exchange-global-address-book-outlook-2010\/","title":{"rendered":"Export Exchange Global Address Book – Get Best Tips"},"content":{"rendered":"

\"Export<\/p>\n

\n
\n

A user cannot export Exchange global address book directly via MS Outlook. However, these contacts can be added to contacts folder in batch. To separate the desired contacts from the personal contacts, a user can temporarily move the present contacts to a separate folder or filter the contacts at a later stage by the parameter created date or modified date. In this way, the Exchange Server contacts can be separated from personal contacts.<\/p>\n

To export global address list from Exchange server, a user can convert these contacts to CSV or XLS file format for further usage and then, using these contacts directly from contacts folder for a Mail Merge.<\/p>\n

If Access is installed on the system, then it can be used to directly import GAL (Global Address List) contacts into the Access database. This is also supported as a source of Mail Merge. Moreover, the data from Access can also be exported to a CSV or XLSX file.<\/p>\n

Techniques to Export Exchange Global Address Book to CSV<\/h2>\n

Method 1\u00a0<\/b><\/h3>\n

To export global address list from Exchange server, a user needs to follow these set of instructions:<\/p>\n

Step 1: Add Global Address List Contacts to Your Contacts Folder<\/b><\/p>\n

To add the contacts from GAL to a personal folder of contacts, follow these steps:<\/p>\n

    \n
  1. Launch your address book. The keyboard shortcut to do the same is Ctrl+Shift+B<\/li>\n
  2. Choose the Exchange address list which consists of the contacts<\/li>\n
  3. Choose all the contacts that are to be exported<\/li>\n
  4. Right-click on the selection made<\/li>\n
  5. Select the option of add to contacts<\/li>\n<\/ol>\n

    Warning:<\/b> This procedure is slow. So, if you select a large number of contacts then, Outlook cannot be accessed for a large duration of time. If it is needed to export the full list of GAL then, it is suggested to contact your user admin or Exchange. They will be able to produce that list quickly and will also require fewer resources.<\/p>\n

    Step 2: Filter and Export the Added Contacts to Export Global Address Book 2013\u00a0<\/b><\/p>\n

      \n
    1. If you have not moved your personal contacts to any separate folder, you can still differentiate between own contacts and the contacts added from Global Access List.<\/li>\n
    2. You have to change the sorting order or apply the filter to view your contacts. Also, you can simply use the feature of instant search. As these contacts are newly added, their created or modified date will be the same and they will be grouped together.<\/li>\n<\/ol>\n

      Tip:<\/b> While customizing your Contacts view, do not forget to choose a list view such as phone list.<\/p>\n

      Once the transferred emails are grouped together, it becomes easy to move the filtered list of contacts to any other folder. The folder can be exported with the help of export option provided in Outlook. Another option is to view the fields which are needed and directly copy them to Excel to export Exchange global address book Outlook 2010.<\/p>\n

      Note:<\/b> In Outlook 2007, a user can also temporarily alter the folder where to create contacts. To do this, a user has to launch the address book, then tools followed by options. Set an option of keeping personal addresses into newly generated contacts folder.<\/p><\/blockquote>\n

      Method 2<\/b><\/h3>\n

      It is the alternative approach to export Global Address List Outlook 2013. In this approach, a user has to import GAL contacts into Access. Follow the below mentioned steps:<\/p>\n

        \n
      1. Generate a new blank database<\/li>\n
      2. Choose a table to export GAL to Outlook 2013<\/li>\n
      3. Choose the option of External data tab<\/li>\n
      4. Based on versions, refer these steps:
        \n4.1. Access 2007, Access 2010 and Access 2013
        \nUnder the Import and link group, hit on More button and then, choose Outlook folder4.2. Access 2016Under the Import and link group hit on the new data source button and select from other sources followed by Outlook folder<\/li>\n
      5. The Get External Data- Outlook Folder window will open on the screen. This allows the user to select between actually importing data or establish an active link to MS Outlook to export contacts from Global Address Book Outlook 2010.
        \n(This option is convenient when you work on same data frequently and that keeps on changing frequently. If it is only required to take a snapshot of the current working directory, the regular import will be suitable.)<\/li>\n
      6. In the address books list, look for the options Offline Global Address Book<\/b>\u00a0and Global Address Book<\/b>.
        \nIf the Offline Global Address Book option is not available, there are chances that you are connected with the cached Exchange mode available or you have to enlarge the entry of All address list.<\/li>\n
      7. Once the items to be imported are selected, you can leave the default or fine-tune the columns. In the next screen, you can uniquely identify each record by addition of a primary key to the table.<\/li>\n<\/ol>\n

        Note:<\/strong><\/span> Using Office365Import tool user can easily import Outlook contacts to Office 365<\/strong><\/a> in few clicks without getting any issue.<\/em><\/p>\n

        The Bottom Line<\/h4>\n

        To export the contacts from the Exchange Server with the help of Outlook cannot be achieved directly. This can be done if Access is installed on the system. So, two different workaround techniques have been described to export Exchange Global Address Book Outlook 2016. A user can choose anyone depending on the needs.<\/p>\n

        Must Read:<\/strong> How Do I Create an Email Signature in Office 365<\/strong><\/a><\/p>\n<\/div>\n<\/div>\n","protected":false},"excerpt":{"rendered":"

        A user cannot export Exchange global address book directly via MS Outlook. However, these contacts can be added to contacts folder in batch. To separate the desired contacts from the personal contacts, a user can temporarily move the present contacts to a separate folder or filter the contacts at a later stage by the parameter […]<\/p>\n","protected":false},"author":2,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[13],"tags":[],"class_list":["post-100","post","type-post","status-publish","format-standard","hentry","category-exchange"],"yoast_head":"\nExport Exchange Global Address Book \/ List to CSV or Excel - Best Tips<\/title>\n<meta name=\"description\" content=\"Learn how to export global address list from Exchange 2010, 2013 step by step with complete solution. In this blog, you will find a perfect method or tips to export Exchange global address book immediately.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/www.office365import.com\/blog\/export-exchange-global-address-book-outlook-2010\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Export Exchange Global Address Book \/ List to CSV or Excel - Best Tips\" \/>\n<meta property=\"og:description\" content=\"Learn how to export global address list from Exchange 2010, 2013 step by step with complete solution. In this blog, you will find a perfect method or tips to export Exchange global address book immediately.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.office365import.com\/blog\/export-exchange-global-address-book-outlook-2010\/\" \/>\n<meta property=\"og:site_name\" content=\"All About Cloud Information\" \/>\n<meta property=\"article:published_time\" content=\"2018-05-04T12:50:39+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2026-03-25T06:11:24+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.office365import.com\/blog\/wp-content\/uploads\/2018\/05\/export-exchange-global-address-book-.png\" \/>\n\t<meta property=\"og:image:width\" content=\"1400\" \/>\n\t<meta property=\"og:image:height\" content=\"425\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/png\" \/>\n<meta name=\"author\" content=\"Robin Morgan\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Robin Morgan\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"4 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\\\/\\\/www.office365import.com\\\/blog\\\/export-exchange-global-address-book-outlook-2010\\\/#article\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.office365import.com\\\/blog\\\/export-exchange-global-address-book-outlook-2010\\\/\"},\"author\":{\"name\":\"Robin Morgan\",\"@id\":\"https:\\\/\\\/www.office365import.com\\\/blog\\\/#\\\/schema\\\/person\\\/77fda7914696fa9bcd1db54716313886\"},\"headline\":\"Export Exchange Global Address Book – Get Best Tips\",\"datePublished\":\"2018-05-04T12:50:39+00:00\",\"dateModified\":\"2026-03-25T06:11:24+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/www.office365import.com\\\/blog\\\/export-exchange-global-address-book-outlook-2010\\\/\"},\"wordCount\":876,\"commentCount\":0,\"image\":{\"@id\":\"https:\\\/\\\/www.office365import.com\\\/blog\\\/export-exchange-global-address-book-outlook-2010\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/www.office365import.com\\\/blog\\\/wp-content\\\/uploads\\\/2018\\\/05\\\/export-exchange-global-address-book--1024x311.png\",\"articleSection\":[\"Exchange\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\\\/\\\/www.office365import.com\\\/blog\\\/export-exchange-global-address-book-outlook-2010\\\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/www.office365import.com\\\/blog\\\/export-exchange-global-address-book-outlook-2010\\\/\",\"url\":\"https:\\\/\\\/www.office365import.com\\\/blog\\\/export-exchange-global-address-book-outlook-2010\\\/\",\"name\":\"Export Exchange Global Address Book \\\/ List to CSV or Excel - Best Tips\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.office365import.com\\\/blog\\\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\\\/\\\/www.office365import.com\\\/blog\\\/export-exchange-global-address-book-outlook-2010\\\/#primaryimage\"},\"image\":{\"@id\":\"https:\\\/\\\/www.office365import.com\\\/blog\\\/export-exchange-global-address-book-outlook-2010\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/www.office365import.com\\\/blog\\\/wp-content\\\/uploads\\\/2018\\\/05\\\/export-exchange-global-address-book--1024x311.png\",\"datePublished\":\"2018-05-04T12:50:39+00:00\",\"dateModified\":\"2026-03-25T06:11:24+00:00\",\"author\":{\"@id\":\"https:\\\/\\\/www.office365import.com\\\/blog\\\/#\\\/schema\\\/person\\\/77fda7914696fa9bcd1db54716313886\"},\"description\":\"Learn how to export global address list from Exchange 2010, 2013 step by step with complete solution. In this blog, you will find a perfect method or tips to export Exchange global address book immediately.\",\"breadcrumb\":{\"@id\":\"https:\\\/\\\/www.office365import.com\\\/blog\\\/export-exchange-global-address-book-outlook-2010\\\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/www.office365import.com\\\/blog\\\/export-exchange-global-address-book-outlook-2010\\\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/www.office365import.com\\\/blog\\\/export-exchange-global-address-book-outlook-2010\\\/#primaryimage\",\"url\":\"https:\\\/\\\/www.office365import.com\\\/blog\\\/wp-content\\\/uploads\\\/2018\\\/05\\\/export-exchange-global-address-book-.png\",\"contentUrl\":\"https:\\\/\\\/www.office365import.com\\\/blog\\\/wp-content\\\/uploads\\\/2018\\\/05\\\/export-exchange-global-address-book-.png\",\"width\":1400,\"height\":425,\"caption\":\"Export Exchange Global Address Book\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/www.office365import.com\\\/blog\\\/export-exchange-global-address-book-outlook-2010\\\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\\\/\\\/www.office365import.com\\\/blog\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Export Exchange Global Address Book – Get Best Tips\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/www.office365import.com\\\/blog\\\/#website\",\"url\":\"https:\\\/\\\/www.office365import.com\\\/blog\\\/\",\"name\":\"All About Cloud Information\",\"description\":\"\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\\\/\\\/www.office365import.com\\\/blog\\\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Person\",\"@id\":\"https:\\\/\\\/www.office365import.com\\\/blog\\\/#\\\/schema\\\/person\\\/77fda7914696fa9bcd1db54716313886\",\"name\":\"Robin Morgan\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/b159cab6b9b99203fb81db33c87b620024f7fc498e05817c3a98d966a59c2a14?s=96&d=mm&r=g\",\"url\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/b159cab6b9b99203fb81db33c87b620024f7fc498e05817c3a98d966a59c2a14?s=96&d=mm&r=g\",\"contentUrl\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/b159cab6b9b99203fb81db33c87b620024f7fc498e05817c3a98d966a59c2a14?s=96&d=mm&r=g\",\"caption\":\"Robin Morgan\"},\"description\":\"Robin Morgan is a Master in Technology with over 7+ years of experience in Office 365, Google Workspace, and cloud migration solutions. Specializing in email data formats and secure migration processes, Robin helps users seamlessly move their data while ensuring accuracy, reliability, and complete data integrity.\",\"url\":\"https:\\\/\\\/www.office365import.com\\\/blog\\\/author\\\/robin\\\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Export Exchange Global Address Book \/ List to CSV or Excel - Best Tips","description":"Learn how to export global address list from Exchange 2010, 2013 step by step with complete solution. In this blog, you will find a perfect method or tips to export Exchange global address book immediately.","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/www.office365import.com\/blog\/export-exchange-global-address-book-outlook-2010\/","og_locale":"en_US","og_type":"article","og_title":"Export Exchange Global Address Book \/ List to CSV or Excel - Best Tips","og_description":"Learn how to export global address list from Exchange 2010, 2013 step by step with complete solution. In this blog, you will find a perfect method or tips to export Exchange global address book immediately.","og_url":"https:\/\/www.office365import.com\/blog\/export-exchange-global-address-book-outlook-2010\/","og_site_name":"All About Cloud Information","article_published_time":"2018-05-04T12:50:39+00:00","article_modified_time":"2026-03-25T06:11:24+00:00","og_image":[{"width":1400,"height":425,"url":"https:\/\/www.office365import.com\/blog\/wp-content\/uploads\/2018\/05\/export-exchange-global-address-book-.png","type":"image\/png"}],"author":"Robin Morgan","twitter_card":"summary_large_image","twitter_misc":{"Written by":"Robin Morgan","Est. reading time":"4 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.office365import.com\/blog\/export-exchange-global-address-book-outlook-2010\/#article","isPartOf":{"@id":"https:\/\/www.office365import.com\/blog\/export-exchange-global-address-book-outlook-2010\/"},"author":{"name":"Robin Morgan","@id":"https:\/\/www.office365import.com\/blog\/#\/schema\/person\/77fda7914696fa9bcd1db54716313886"},"headline":"Export Exchange Global Address Book – Get Best Tips","datePublished":"2018-05-04T12:50:39+00:00","dateModified":"2026-03-25T06:11:24+00:00","mainEntityOfPage":{"@id":"https:\/\/www.office365import.com\/blog\/export-exchange-global-address-book-outlook-2010\/"},"wordCount":876,"commentCount":0,"image":{"@id":"https:\/\/www.office365import.com\/blog\/export-exchange-global-address-book-outlook-2010\/#primaryimage"},"thumbnailUrl":"https:\/\/www.office365import.com\/blog\/wp-content\/uploads\/2018\/05\/export-exchange-global-address-book--1024x311.png","articleSection":["Exchange"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/www.office365import.com\/blog\/export-exchange-global-address-book-outlook-2010\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/www.office365import.com\/blog\/export-exchange-global-address-book-outlook-2010\/","url":"https:\/\/www.office365import.com\/blog\/export-exchange-global-address-book-outlook-2010\/","name":"Export Exchange Global Address Book \/ List to CSV or Excel - Best Tips","isPartOf":{"@id":"https:\/\/www.office365import.com\/blog\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.office365import.com\/blog\/export-exchange-global-address-book-outlook-2010\/#primaryimage"},"image":{"@id":"https:\/\/www.office365import.com\/blog\/export-exchange-global-address-book-outlook-2010\/#primaryimage"},"thumbnailUrl":"https:\/\/www.office365import.com\/blog\/wp-content\/uploads\/2018\/05\/export-exchange-global-address-book--1024x311.png","datePublished":"2018-05-04T12:50:39+00:00","dateModified":"2026-03-25T06:11:24+00:00","author":{"@id":"https:\/\/www.office365import.com\/blog\/#\/schema\/person\/77fda7914696fa9bcd1db54716313886"},"description":"Learn how to export global address list from Exchange 2010, 2013 step by step with complete solution. In this blog, you will find a perfect method or tips to export Exchange global address book immediately.","breadcrumb":{"@id":"https:\/\/www.office365import.com\/blog\/export-exchange-global-address-book-outlook-2010\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.office365import.com\/blog\/export-exchange-global-address-book-outlook-2010\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.office365import.com\/blog\/export-exchange-global-address-book-outlook-2010\/#primaryimage","url":"https:\/\/www.office365import.com\/blog\/wp-content\/uploads\/2018\/05\/export-exchange-global-address-book-.png","contentUrl":"https:\/\/www.office365import.com\/blog\/wp-content\/uploads\/2018\/05\/export-exchange-global-address-book-.png","width":1400,"height":425,"caption":"Export Exchange Global Address Book"},{"@type":"BreadcrumbList","@id":"https:\/\/www.office365import.com\/blog\/export-exchange-global-address-book-outlook-2010\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.office365import.com\/blog\/"},{"@type":"ListItem","position":2,"name":"Export Exchange Global Address Book – Get Best Tips"}]},{"@type":"WebSite","@id":"https:\/\/www.office365import.com\/blog\/#website","url":"https:\/\/www.office365import.com\/blog\/","name":"All About Cloud Information","description":"","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.office365import.com\/blog\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Person","@id":"https:\/\/www.office365import.com\/blog\/#\/schema\/person\/77fda7914696fa9bcd1db54716313886","name":"Robin Morgan","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/secure.gravatar.com\/avatar\/b159cab6b9b99203fb81db33c87b620024f7fc498e05817c3a98d966a59c2a14?s=96&d=mm&r=g","url":"https:\/\/secure.gravatar.com\/avatar\/b159cab6b9b99203fb81db33c87b620024f7fc498e05817c3a98d966a59c2a14?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/b159cab6b9b99203fb81db33c87b620024f7fc498e05817c3a98d966a59c2a14?s=96&d=mm&r=g","caption":"Robin Morgan"},"description":"Robin Morgan is a Master in Technology with over 7+ years of experience in Office 365, Google Workspace, and cloud migration solutions. Specializing in email data formats and secure migration processes, Robin helps users seamlessly move their data while ensuring accuracy, reliability, and complete data integrity.","url":"https:\/\/www.office365import.com\/blog\/author\/robin\/"}]}},"_links":{"self":[{"href":"https:\/\/www.office365import.com\/blog\/wp-json\/wp\/v2\/posts\/100","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.office365import.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.office365import.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.office365import.com\/blog\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/www.office365import.com\/blog\/wp-json\/wp\/v2\/comments?post=100"}],"version-history":[{"count":15,"href":"https:\/\/www.office365import.com\/blog\/wp-json\/wp\/v2\/posts\/100\/revisions"}],"predecessor-version":[{"id":281,"href":"https:\/\/www.office365import.com\/blog\/wp-json\/wp\/v2\/posts\/100\/revisions\/281"}],"wp:attachment":[{"href":"https:\/\/www.office365import.com\/blog\/wp-json\/wp\/v2\/media?parent=100"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.office365import.com\/blog\/wp-json\/wp\/v2\/categories?post=100"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.office365import.com\/blog\/wp-json\/wp\/v2\/tags?post=100"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}