{"id":64633,"date":"2025-03-11T15:48:23","date_gmt":"2025-03-11T15:48:23","guid":{"rendered":"https:\/\/www.sogolytics.com\/help\/?page_id=64633"},"modified":"2026-04-24T16:23:10","modified_gmt":"2026-04-24T16:23:10","slug":"how-to-build-a-directory-using-a-file","status":"publish","type":"page","link":"https:\/\/www.sogolytics.com\/help\/how-to-build-a-directory-using-a-file\/","title":{"rendered":"Build Directory Using A File"},"content":{"rendered":"

Ready to get started with a new Directory? Staring with an Excel or CSV file makes it simple. To build a Directory using a File as the source, follow the steps below.<\/p>\n

    \n
  1. In the top left corner of your screen, click on Directories<\/strong>\u00a0and select Create a Directory<\/strong>. <\/li>\n
  2. Add the desired title and description for the Directory. Next, click Create<\/strong>. <\/li>\n
  3. Select the source to import the Contacts From File<\/strong>. This option allows you to import records using an Excel<\/strong> or CSV<\/strong> file.<\/li>\n
  4. Download the sample file provided and format your data accordingly in Excel or CSV format. <\/li>\n
  5. Upload the formatted file by clicking Choose File<\/strong>. You can also hover over the relevant icons to Preview<\/strong> or Delete<\/strong> the uploaded file. Ready to move on? Click Continue<\/strong>.<\/li>\n
    <\/i><\/p>\n

    Your uploaded file must include an email or SMS number field.<\/p>\n<\/div>\n

  6. Within the Map Fields<\/strong> section, you can specify the type for each field being added to the Directory. The system may automatically identify some of the field types being imported. You can import any remaining values as custom fields, along with their appropriate field types. Available field types include:
    \n<\/p>\n
      \n
    1. String<\/strong> \u2013 This field type is used for text-based information, allowing the entry of any combination of letters, numbers, and symbols.<\/li>\n
    2. Email<\/strong> \u2013 This field type is used for storing any email address.<\/li>\n
    3. Number<\/strong> \u2013 The field type is used for storing an integer value.<\/li>\n
    4. Date<\/strong> \u2013 This field type is used for saving the date in one of the following formats: MM\/DD\/YYYY, DD\/MM\/YYYY, YYYY-MM-DD<\/li>\n
    5. Time<\/strong> \u2013 This field type is used for saving the time as: hh:mm or hh:mm:ss<\/li>\n
    6. Date-Time<\/strong> \u2013 This field type is used for saving date and time in the following formats:\n
        \n
      • MM\/DD\/YYYY hh:mm<\/li>\n
      • DD\/MM\/YYYY hh:mm<\/li>\n
      • YYYY\/MM\/DD hh:mm<\/li>\n
      • MM\/DD\/YYYY hh:mm:ss<\/li>\n
      • DD\/MM\/YYYY hh:mm:ss<\/li>\n
      • YYYY\/MM\/DD hh:mm:ss<\/li>\n<\/ul>\n<\/li>\n
      • Boolean<\/strong> \u2013 This field type is used for saving any Boolean values such as 1|0, Yes|No, Y|N, True|False. Any value pair used for this will be normalized to True and False after importing.<\/li>\n
      • Phone<\/strong> \u2013 This field type is used for saving phone numbers. You can also specify the country code for the saved phone numbers by clicking on the gear icon available next to the Field Type Column.<\/li>\n
      • URL<\/strong> – This field type is used for saving URLs.<\/li>\n<\/ol>\n
        <\/i><\/p>\n

        Each Contact must have an associated email address or phone number. Map these with the appropriate system-defined email or phone fields in the Attributes column.<\/p>\n<\/div>\n<\/li>\n

      • Once you have completed field mapping click Continue<\/strong>.<\/li>\n
      • Next, fields will be evaluated based on their defined field types. If there are no exceptions, the Directory set-up will be complete.<\/li>\n
      • If any exceptions are encountered, all the exception details will be displayed in the Review Data<\/strong> wizard. You can download the exception file here for a detailed clarification of the fields that have not synced as expected using Download all X Contacts with exceptions for review<\/strong>. You can then either proceed to import the valid Contacts on this page or re-upload the corrected file using the Click Here<\/strong> option.<\/li>\n
      • Once you confirm that fields have been mapped properly, click Continue. The valid records will be imported and the Directory set-up is complete. <\/li>\n<\/ol>\n<\/li>\n","protected":false},"excerpt":{"rendered":"

        Ready to get started with a new Directory? Staring with an Excel or CSV file makes it simple. To build a Directory using a File as the source, follow the steps below. In the top left corner of your screen, click on Directories\u00a0and select Create a Directory. Add the desired title and description for the Directory. Next, click Create. Select the source to import the Contacts From File. This option allows you to import records using an Excel or CSV file. Download the sample file provided and format your data accordingly in Excel or CSV format. Upload the formatted file by clicking Choose File. You can also hover over the relevant icons to Preview or Delete the uploaded file. Ready to move on? Click Continue. Your uploaded file must include an email or SMS number field. Within the Map Fields section, you can specify the type for each field being added to the Directory. The system may automatically identify some of the field types being imported. You can import any remaining values as custom fields, along with their appropriate field types. Available field types include: String \u2013 This field type is used for text-based information, allowing the entry of any combination of letters, numbers, and symbols. Email \u2013 This field type is used for storing any email address. Number \u2013 The field type is used for storing an integer value. Date \u2013 This field type is used for saving the date in one of the following formats: MM\/DD\/YYYY, DD\/MM\/YYYY, YYYY-MM-DD […]<\/p>\n","protected":false},"author":30,"featured_media":0,"parent":0,"menu_order":65,"comment_status":"closed","ping_status":"closed","template":"sogo_new_design.php","meta":{"footnotes":""},"categories":[455],"tags":[465,463],"yoast_head":"\nBuild a Directory Using a File | Sogolytics<\/title>\n<meta name=\"description\" content=\"Ready to get started with a new Directory? Staring with an Excel or CSV file makes it simple. To build a Directory using a File as the source, follow the steps below.\" \/>\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.sogolytics.com\/help\/how-to-build-a-directory-using-a-file\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Build a Directory Using a File | Sogolytics\" \/>\n<meta property=\"og:description\" content=\"Ready to get started with a new Directory? Staring with an Excel or CSV file makes it simple. To build a Directory using a File as the source, follow the steps below.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.sogolytics.com\/help\/how-to-build-a-directory-using-a-file\/\" \/>\n<meta property=\"og:site_name\" content=\"Sogolytics\" \/>\n<meta property=\"article:modified_time\" content=\"2026-04-24T16:23:10+00:00\" \/>\n<meta name=\"twitter:card\" content=\"summary\" \/>\n<meta name=\"twitter:label1\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data1\" content=\"1 minute\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.sogolytics.com\/help\/how-to-build-a-directory-using-a-file\/\",\"url\":\"https:\/\/www.sogolytics.com\/help\/how-to-build-a-directory-using-a-file\/\",\"name\":\"Build a Directory Using a File | Sogolytics\",\"isPartOf\":{\"@id\":\"https:\/\/www.sogolytics.com\/help\/#website\"},\"datePublished\":\"2025-03-11T15:48:23+00:00\",\"dateModified\":\"2026-04-24T16:23:10+00:00\",\"description\":\"Ready to get started with a new Directory? Staring with an Excel or CSV file makes it simple. To build a Directory using a File as the source, follow the steps below.\",\"breadcrumb\":{\"@id\":\"https:\/\/www.sogolytics.com\/help\/how-to-build-a-directory-using-a-file\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.sogolytics.com\/help\/how-to-build-a-directory-using-a-file\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.sogolytics.com\/help\/how-to-build-a-directory-using-a-file\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/www.sogolytics.com\/help\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Build Directory Using A File\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/www.sogolytics.com\/help\/#website\",\"url\":\"https:\/\/www.sogolytics.com\/help\/\",\"name\":\"Sogolytics\",\"description\":\"Sogolytics - Online Survey Tool\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/www.sogolytics.com\/help\/?s={search_term_string}\"},\"query-input\":\"required name=search_term_string\"}],\"inLanguage\":\"en-US\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Build a Directory Using a File | Sogolytics","description":"Ready to get started with a new Directory? Staring with an Excel or CSV file makes it simple. To build a Directory using a File as the source, follow the steps below.","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.sogolytics.com\/help\/how-to-build-a-directory-using-a-file\/","og_locale":"en_US","og_type":"article","og_title":"Build a Directory Using a File | Sogolytics","og_description":"Ready to get started with a new Directory? Staring with an Excel or CSV file makes it simple. To build a Directory using a File as the source, follow the steps below.","og_url":"https:\/\/www.sogolytics.com\/help\/how-to-build-a-directory-using-a-file\/","og_site_name":"Sogolytics","article_modified_time":"2026-04-24T16:23:10+00:00","twitter_card":"summary","twitter_misc":{"Est. reading time":"1 minute"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/www.sogolytics.com\/help\/how-to-build-a-directory-using-a-file\/","url":"https:\/\/www.sogolytics.com\/help\/how-to-build-a-directory-using-a-file\/","name":"Build a Directory Using a File | Sogolytics","isPartOf":{"@id":"https:\/\/www.sogolytics.com\/help\/#website"},"datePublished":"2025-03-11T15:48:23+00:00","dateModified":"2026-04-24T16:23:10+00:00","description":"Ready to get started with a new Directory? Staring with an Excel or CSV file makes it simple. To build a Directory using a File as the source, follow the steps below.","breadcrumb":{"@id":"https:\/\/www.sogolytics.com\/help\/how-to-build-a-directory-using-a-file\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.sogolytics.com\/help\/how-to-build-a-directory-using-a-file\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/www.sogolytics.com\/help\/how-to-build-a-directory-using-a-file\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.sogolytics.com\/help\/"},{"@type":"ListItem","position":2,"name":"Build Directory Using A File"}]},{"@type":"WebSite","@id":"https:\/\/www.sogolytics.com\/help\/#website","url":"https:\/\/www.sogolytics.com\/help\/","name":"Sogolytics","description":"Sogolytics - Online Survey Tool","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.sogolytics.com\/help\/?s={search_term_string}"},"query-input":"required name=search_term_string"}],"inLanguage":"en-US"}]}},"seo_meta_info":{"yoast_noindex":"","rankmath_noindex":"","yoast_title":"Build a Directory Using a File | Sogolytics","yoast_desc":"Ready to get started with a new Directory? Staring with an Excel or CSV file makes it simple. To build a Directory using a File as the source, follow the steps below.","rankmath_title":"Build Directory Using A File","rankmath_desc":"Ready to get started with a new Directory? Staring with an Excel or CSV file makes it simple. To build a Directory using a File…"},"_links":{"self":[{"href":"https:\/\/www.sogolytics.com\/help\/wp-json\/wp\/v2\/pages\/64633"}],"collection":[{"href":"https:\/\/www.sogolytics.com\/help\/wp-json\/wp\/v2\/pages"}],"about":[{"href":"https:\/\/www.sogolytics.com\/help\/wp-json\/wp\/v2\/types\/page"}],"author":[{"embeddable":true,"href":"https:\/\/www.sogolytics.com\/help\/wp-json\/wp\/v2\/users\/30"}],"replies":[{"embeddable":true,"href":"https:\/\/www.sogolytics.com\/help\/wp-json\/wp\/v2\/comments?post=64633"}],"version-history":[{"count":3,"href":"https:\/\/www.sogolytics.com\/help\/wp-json\/wp\/v2\/pages\/64633\/revisions"}],"predecessor-version":[{"id":66312,"href":"https:\/\/www.sogolytics.com\/help\/wp-json\/wp\/v2\/pages\/64633\/revisions\/66312"}],"wp:attachment":[{"href":"https:\/\/www.sogolytics.com\/help\/wp-json\/wp\/v2\/media?parent=64633"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.sogolytics.com\/help\/wp-json\/wp\/v2\/categories?post=64633"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.sogolytics.com\/help\/wp-json\/wp\/v2\/tags?post=64633"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}