{"id":6255,"date":"2022-03-29T16:31:29","date_gmt":"2022-03-29T14:31:29","guid":{"rendered":"https:\/\/aivie.ch\/faq\/how-do-i-import-contacts-into-segments\/"},"modified":"2026-01-11T14:41:15","modified_gmt":"2026-01-11T12:41:15","slug":"how-do-i-import-contacts-into-segments","status":"publish","type":"faq","link":"https:\/\/aivie.ch\/en\/faq\/how-do-i-import-contacts-into-segments\/","title":{"rendered":"How do I upload contacts from an Excel table into a segment?"},"content":{"rendered":"\n<p>For each <a href=\"https:\/\/aivie.ch\/fi\/faq\/miten-voin-tuoda-yhteystietoja-mauticiin-tai-aivieen\/\">contact import process<\/a>, a segment can be specified for all contacts in the Excel table (or Google Sheets; it just needs to be a CSV). This allows you to quickly and easily assign many contacts to a segment. <\/p>\n\n<!--more-->\n\n<p>If the contacts already exist in Aivie and you only want to assign them to a segment, it is sufficient to simply use an Excel file with a column for the email addresses during the import process. <\/p>\n\n<p>Since the contacts already exist, they are merged based on the email addresses and only assigned to the specified segment \u2013 without being uploaded as new contacts.<\/p>\n\n<p>You can find out how to import contacts in the article: <a href=\"https:\/\/aivie.ch\/fi\/faq\/miten-voin-tuoda-yhteystietoja-mauticiin-tai-aivieen\/\">How do I import contacts into Mautic or Aivie?<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"<p>For each contact import process, a segment can be specified for all contacts in the Excel table (or Google Sheets; it just needs to be a CSV). This allows you to quickly and easily assign many contacts to a segment.<\/p>\n","protected":false},"featured_media":0,"template":"","categories":[],"tags":[],"FaqCategories":[273],"FaqTags":[287,277],"class_list":["post-6255","faq","type-faq","status-publish","hentry","FaqCategories-contact-management","FaqTags-segments","FaqTags-starter-en"],"acf":[],"featured_image_urls_v2":{"full":"","thumbnail":"","medium":"","medium_large":"","large":"","post-thumbnail":"","aiv_480w":"","woocommerce_thumbnail":"","woocommerce_single":"","woocommerce_gallery_thumbnail":""},"post_excerpt_stackable_v2":"<p>For each contact import process, a segment can be specified for all contacts in the Excel table (or Google Sheets; it just needs to be a CSV). This allows you to quickly and easily assign many contacts to a segment. If the contacts already exist in Aivie and you only want to assign them to a segment, it is sufficient to simply use an Excel file with a column for the email addresses during the import process. Since the contacts already exist, they are merged based on the email addresses and only assigned to the specified segment \u2013 without being&hellip;<\/p>\n","category_list_v2":"Uncategorized","author_info_v2":{"name":"","url":""},"comments_num_v2":"0 comments","_links":{"self":[{"href":"https:\/\/aivie.ch\/en\/wp-json\/wp\/v2\/faq\/6255","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/aivie.ch\/en\/wp-json\/wp\/v2\/faq"}],"about":[{"href":"https:\/\/aivie.ch\/en\/wp-json\/wp\/v2\/types\/faq"}],"version-history":[{"count":2,"href":"https:\/\/aivie.ch\/en\/wp-json\/wp\/v2\/faq\/6255\/revisions"}],"predecessor-version":[{"id":27022,"href":"https:\/\/aivie.ch\/en\/wp-json\/wp\/v2\/faq\/6255\/revisions\/27022"}],"wp:attachment":[{"href":"https:\/\/aivie.ch\/en\/wp-json\/wp\/v2\/media?parent=6255"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/aivie.ch\/en\/wp-json\/wp\/v2\/categories?post=6255"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/aivie.ch\/en\/wp-json\/wp\/v2\/tags?post=6255"},{"taxonomy":"FaqCategories","embeddable":true,"href":"https:\/\/aivie.ch\/en\/wp-json\/wp\/v2\/FaqCategories?post=6255"},{"taxonomy":"FaqTags","embeddable":true,"href":"https:\/\/aivie.ch\/en\/wp-json\/wp\/v2\/FaqTags?post=6255"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}