{"id":286,"date":"2022-07-20T11:42:36","date_gmt":"2022-07-20T10:42:36","guid":{"rendered":"http:\/\/help.contactmodule.com\/?post_type=ht_kb&#038;p=286"},"modified":"2025-06-08T18:27:54","modified_gmt":"2025-06-08T17:27:54","slug":"selecties-importeren-met-kopieren-en-plakken","status":"publish","type":"ht_kb","link":"https:\/\/help.contactmodule.com\/en\/knowledgebase\/selecties-importeren-met-kopieren-en-plakken\/","title":{"rendered":"Importing selections from Excel"},"content":{"rendered":"<p><strong>Create a selection in the Contact module using a selection from Excel. You can do this by a simple operation with copy and paste<\/strong>.<\/p>\n\n\n\n<p>Go to the 'Selections' menu in the main 'Customers' menu.<\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"673\" height=\"392\" src=\"https:\/\/help.contactmodule.com\/wp-content\/uploads\/2025\/06\/Schermafbeelding-2025-06-13-105025.png\" alt=\"\" class=\"wp-image-2005\" srcset=\"https:\/\/help.contactmodule.com\/wp-content\/uploads\/2025\/06\/Schermafbeelding-2025-06-13-105025.png 655w, https:\/\/help.contactmodule.com\/wp-content\/uploads\/2025\/06\/Schermafbeelding-2025-06-13-105025-300x192.png 300w, https:\/\/help.contactmodule.com\/wp-content\/uploads\/2025\/06\/Schermafbeelding-2025-06-13-105025-50x32.png 50w, https:\/\/help.contactmodule.com\/wp-content\/uploads\/2025\/06\/Schermafbeelding-2025-06-13-105025-18x12.png 18w, https:\/\/help.contactmodule.com\/wp-content\/uploads\/2025\/06\/Schermafbeelding-2025-06-13-105025-60x38.png 60w, https:\/\/help.contactmodule.com\/wp-content\/uploads\/2025\/06\/Schermafbeelding-2025-06-13-105025-100x64.png 100w\" sizes=\"(max-width: 673px) 100vw, 673px\" \/><\/figure>\n\n\n\n<h2 class=\"wp-block-heading\">Step 1<\/h2>\n\n\n\n<p>Select button to paste Excel selections<\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"686\" height=\"186\" src=\"https:\/\/help.contactmodule.com\/wp-content\/uploads\/2025\/08\/plakken.png\" alt=\"\" class=\"wp-image-2031\" srcset=\"https:\/\/help.contactmodule.com\/wp-content\/uploads\/2025\/08\/plakken.png 637w, https:\/\/help.contactmodule.com\/wp-content\/uploads\/2025\/08\/plakken-300x91.png 300w, https:\/\/help.contactmodule.com\/wp-content\/uploads\/2025\/08\/plakken-50x15.png 50w, https:\/\/help.contactmodule.com\/wp-content\/uploads\/2025\/08\/plakken-18x5.png 18w, https:\/\/help.contactmodule.com\/wp-content\/uploads\/2025\/08\/plakken-60x18.png 60w, https:\/\/help.contactmodule.com\/wp-content\/uploads\/2025\/08\/plakken-100x30.png 100w\" sizes=\"(max-width: 686px) 100vw, 686px\" \/><\/figure>\n\n\n\n<h2 class=\"wp-block-heading\">Step 2<\/h2>\n\n\n\n<p>Copy the data from the Excel worksheet by selecting it and copying it (CTRL+C)<\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"560\" height=\"426\" src=\"https:\/\/help.contactmodule.com\/wp-content\/uploads\/2025\/08\/excel-2.png\" alt=\"\" class=\"wp-image-2032\" srcset=\"https:\/\/help.contactmodule.com\/wp-content\/uploads\/2025\/08\/excel-2.png 762w, https:\/\/help.contactmodule.com\/wp-content\/uploads\/2025\/08\/excel-2-300x98.png 300w, https:\/\/help.contactmodule.com\/wp-content\/uploads\/2025\/08\/excel-2-50x16.png 50w, https:\/\/help.contactmodule.com\/wp-content\/uploads\/2025\/08\/excel-2-18x6.png 18w, https:\/\/help.contactmodule.com\/wp-content\/uploads\/2025\/08\/excel-2-60x20.png 60w, https:\/\/help.contactmodule.com\/wp-content\/uploads\/2025\/08\/excel-2-100x33.png 100w\" sizes=\"(max-width: 560px) 100vw, 560px\" \/><\/figure>\n\n\n\n<h2 class=\"wp-block-heading\">Step 3<\/h2>\n\n\n\n<p>Perform the following actions in the screen<\/p>\n\n\n\n<ol>\n<li>Paste the data into the text box<\/li>\n\n\n\n<li>Name the selection<\/li>\n\n\n\n<li>If the first row is the column name, tick here<\/li>\n<\/ol>\n\n\n\n<p>Click on 'next'<\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"534\" src=\"https:\/\/help.contactmodule.com\/wp-content\/uploads\/2025\/08\/new-selec-1.png\" alt=\"\" class=\"wp-image-2033\" srcset=\"https:\/\/help.contactmodule.com\/wp-content\/uploads\/2025\/08\/new-selec-1.png 1555w, https:\/\/help.contactmodule.com\/wp-content\/uploads\/2025\/08\/new-selec-1-300x113.png 300w, https:\/\/help.contactmodule.com\/wp-content\/uploads\/2025\/08\/new-selec-1-1024x385.png 1024w, https:\/\/help.contactmodule.com\/wp-content\/uploads\/2025\/08\/new-selec-1-768x288.png 768w, https:\/\/help.contactmodule.com\/wp-content\/uploads\/2025\/08\/new-selec-1-50x19.png 50w, https:\/\/help.contactmodule.com\/wp-content\/uploads\/2025\/08\/new-selec-1-1536x577.png 1536w, https:\/\/help.contactmodule.com\/wp-content\/uploads\/2025\/08\/new-selec-1-18x7.png 18w, https:\/\/help.contactmodule.com\/wp-content\/uploads\/2025\/08\/new-selec-1-60x23.png 60w, https:\/\/help.contactmodule.com\/wp-content\/uploads\/2025\/08\/new-selec-1-100x38.png 100w\" sizes=\"(max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n\n\n\n<h2 class=\"wp-block-heading\">Step 4<\/h2>\n\n\n\n<p>In this step, you make known to the Contact module database which fields you have just pasted. <\/p>\n\n\n\n<ul>\n<li>Click on the field<\/li>\n\n\n\n<li>Select the name of the field<\/li>\n\n\n\n<li>If there is a field in the list that you do not want to import, leave - SKIP - blank<\/li>\n\n\n\n<li>Click on 'import data' for the next step<\/li>\n<\/ul>\n\n\n\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"547\" src=\"https:\/\/help.contactmodule.com\/wp-content\/uploads\/2025\/08\/import.png\" alt=\"\" class=\"wp-image-2035\" srcset=\"https:\/\/help.contactmodule.com\/wp-content\/uploads\/2025\/08\/import.png 1658w, https:\/\/help.contactmodule.com\/wp-content\/uploads\/2025\/08\/import-300x117.png 300w, https:\/\/help.contactmodule.com\/wp-content\/uploads\/2025\/08\/import-1024x401.png 1024w, https:\/\/help.contactmodule.com\/wp-content\/uploads\/2025\/08\/import-768x301.png 768w, https:\/\/help.contactmodule.com\/wp-content\/uploads\/2025\/08\/import-50x20.png 50w, https:\/\/help.contactmodule.com\/wp-content\/uploads\/2025\/08\/import-1536x601.png 1536w, https:\/\/help.contactmodule.com\/wp-content\/uploads\/2025\/08\/import-18x7.png 18w, https:\/\/help.contactmodule.com\/wp-content\/uploads\/2025\/08\/import-60x23.png 60w, https:\/\/help.contactmodule.com\/wp-content\/uploads\/2025\/08\/import-100x39.png 100w\" sizes=\"(max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n\n\n\n<h2 class=\"wp-block-heading\">Step 5<\/h2>\n\n\n\n<p>The selection is ready for use, e.g. for an e-mailing.<\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"269\" src=\"https:\/\/help.contactmodule.com\/wp-content\/uploads\/2025\/08\/selection-row.png\" alt=\"\" class=\"wp-image-2036\" srcset=\"https:\/\/help.contactmodule.com\/wp-content\/uploads\/2025\/08\/selection-row.png 2197w, https:\/\/help.contactmodule.com\/wp-content\/uploads\/2025\/08\/selection-row-300x44.png 300w, https:\/\/help.contactmodule.com\/wp-content\/uploads\/2025\/08\/selection-row-1024x149.png 1024w, https:\/\/help.contactmodule.com\/wp-content\/uploads\/2025\/08\/selection-row-768x112.png 768w, https:\/\/help.contactmodule.com\/wp-content\/uploads\/2025\/08\/selection-row-50x7.png 50w, https:\/\/help.contactmodule.com\/wp-content\/uploads\/2025\/08\/selection-row-1536x224.png 1536w, https:\/\/help.contactmodule.com\/wp-content\/uploads\/2025\/08\/selection-row-2048x298.png 2048w, https:\/\/help.contactmodule.com\/wp-content\/uploads\/2025\/08\/selection-row-18x3.png 18w, https:\/\/help.contactmodule.com\/wp-content\/uploads\/2025\/08\/selection-row-60x9.png 60w, https:\/\/help.contactmodule.com\/wp-content\/uploads\/2025\/08\/selection-row-100x15.png 100w\" sizes=\"(max-width: 1024px) 100vw, 1024px\" \/><\/figure>","protected":false},"excerpt":{"rendered":"<p>Create a selection in the Contact module using a selection from Excel. You can do this by a simple copy and paste operation. Go to the 'selections' menu in the main 'your relations' menu. Step 1 Select the button to paste Excel selections Step 2 Copy the datafrom the Excel...<\/p>","protected":false},"author":2,"comment_status":"open","ping_status":"closed","template":"","format":"standard","meta":{"footnotes":""},"ht-kb-category":[28],"ht-kb-tag":[],"_links":{"self":[{"href":"https:\/\/help.contactmodule.com\/en\/wp-json\/wp\/v2\/ht-kb\/286"}],"collection":[{"href":"https:\/\/help.contactmodule.com\/en\/wp-json\/wp\/v2\/ht-kb"}],"about":[{"href":"https:\/\/help.contactmodule.com\/en\/wp-json\/wp\/v2\/types\/ht_kb"}],"author":[{"embeddable":true,"href":"https:\/\/help.contactmodule.com\/en\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/help.contactmodule.com\/en\/wp-json\/wp\/v2\/comments?post=286"}],"version-history":[{"count":12,"href":"https:\/\/help.contactmodule.com\/en\/wp-json\/wp\/v2\/ht-kb\/286\/revisions"}],"predecessor-version":[{"id":2037,"href":"https:\/\/help.contactmodule.com\/en\/wp-json\/wp\/v2\/ht-kb\/286\/revisions\/2037"}],"wp:attachment":[{"href":"https:\/\/help.contactmodule.com\/en\/wp-json\/wp\/v2\/media?parent=286"}],"wp:term":[{"taxonomy":"ht_kb_category","embeddable":true,"href":"https:\/\/help.contactmodule.com\/en\/wp-json\/wp\/v2\/ht-kb-category?post=286"},{"taxonomy":"ht_kb_tag","embeddable":true,"href":"https:\/\/help.contactmodule.com\/en\/wp-json\/wp\/v2\/ht-kb-tag?post=286"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}