{"id":2010,"date":"2013-12-10T09:22:38","date_gmt":"2013-12-10T08:22:38","guid":{"rendered":"https:\/\/badgemaker.info\/?page_id=2010"},"modified":"2016-07-15T11:43:19","modified_gmt":"2016-07-15T09:43:19","slug":"import-excel-csv-data","status":"publish","type":"page","link":"https:\/\/badgemaker.info\/en\/userguide2\/badgemaker-identity\/import-data\/import-excel-csv-data\/","title":{"rendered":"A. Import Excel or CSV data"},"content":{"rendered":"<h5>A. Import Excel or CSV data<\/h5>\n<h5 class=\"small\">BadgeMaker Identity<\/h5>\n<p><strong>1. Datasource<br \/>\n<a href=\"https:\/\/badgemaker.info\/wp-content\/uploads\/2016\/04\/bm_identity_import_datasource.png\"><img decoding=\"async\" class=\"alignnone size-full wp-image-3909\" src=\"https:\/\/badgemaker.info\/wp-content\/uploads\/2016\/04\/bm_identity_import_datasource.png\" alt=\"bm_identity_import_datasource\" width=\"80%\" srcset=\"https:\/\/badgemaker.info\/wp-content\/uploads\/2016\/04\/bm_identity_import_datasource.png 695w, https:\/\/badgemaker.info\/wp-content\/uploads\/2016\/04\/bm_identity_import_datasource-300x263.png 300w\" sizes=\"(max-width: 695px) 100vw, 695px\" \/><\/a><br \/>\n<\/strong><em>Fig. Example of the import data popup window.<\/em><\/p>\n<p><span style=\"color: #00a0de;\">A.<\/span>\u00a0Click on this button and select the Excel\/CSV file you want to import..<br \/>\n<span style=\"color: #00a0de;\">B.<\/span>\u00a0Select the worksheet you want to use from the drop down menu.<br \/>\n<span style=\"color: #00a0de;\">C.<\/span> Select the row that contains the column names.<br \/>\n<span style=\"color: #00a0de;\">D. <\/span>Select the column that connects with the unique photo names (for example: ID number or index)<br \/>\n<span style=\"color: #00a0de;\">E.<\/span> Select the folder that contains the card holders photos.<br \/>\n<span style=\"color: #00a0de;\">F.<\/span> Select the column that connects with the unique photo names (for example: ID number or index)<br \/>\n<span style=\"color: #00a0de;\">G.<\/span> Select the folder that contains the card holders photos<br \/>\n<span style=\"color: #00a0de;\">H. <\/span>Click on the \u201c<span style=\"color: #00a0de;\">Next step<\/span>\u201d button to continue to second step.<\/p>\n<p>&nbsp;<\/p>\n<p><strong>2. Configuration<br \/>\n<\/strong><a href=\"https:\/\/badgemaker.info\/wp-content\/uploads\/2016\/04\/ef.png\"><img decoding=\"async\" class=\"alignnone size-full wp-image-3910\" src=\"https:\/\/badgemaker.info\/wp-content\/uploads\/2016\/04\/ef.png\" alt=\"ef\" width=\"80%\" srcset=\"https:\/\/badgemaker.info\/wp-content\/uploads\/2016\/04\/ef.png 458w, https:\/\/badgemaker.info\/wp-content\/uploads\/2016\/04\/ef-300x263.png 300w\" sizes=\"(max-width: 458px) 100vw, 458px\" \/><\/a><br \/>\n<em>Fig. Example of the import Excel\/CVS data popup window.<\/em><\/p>\n<p><span style=\"color: #00a0de;\">A. <\/span>Check this box to only import new records, existing records will not be overwritten.<br \/>\n<span style=\"color: #00a0de;\">B.<\/span> Select what happens when encountering a conversion error.<br \/>\n<span style=\"color: #00a0de;\">C.\u00a0<\/span>Select one of the fields of the excel data which uniquely identifies data in the data source.<br \/>\n<span style=\"color: #00a0de;\">D.\u00a0<\/span>Connect the source columns with the destination columns, BadgeMaker has already connects the columns with similar names.<br \/>\n<span style=\"color: #00a0de;\">E.\u00a0<\/span>Click on the \u201c<span style=\"color: #00a0de;\">Next step<\/span>\u201d button to continue to import the data.<\/p>\n<p><strong>3.\u00a0Import data<br \/>\n<a href=\"https:\/\/badgemaker.info\/wp-content\/uploads\/2016\/04\/bm_identity_Import_Excel_import_data.png\"><img decoding=\"async\" class=\"alignnone size-full wp-image-3912\" src=\"https:\/\/badgemaker.info\/wp-content\/uploads\/2016\/04\/bm_identity_Import_Excel_import_data.png\" alt=\"bm_identity_Import_Excel_import_data\" width=\"80%\" srcset=\"https:\/\/badgemaker.info\/wp-content\/uploads\/2016\/04\/bm_identity_Import_Excel_import_data.png 695w, https:\/\/badgemaker.info\/wp-content\/uploads\/2016\/04\/bm_identity_Import_Excel_import_data-300x263.png 300w\" sizes=\"(max-width: 695px) 100vw, 695px\" \/><br \/>\n<\/a><\/strong><em>Fig. Example of step 3. Import data<\/em><\/p>\n<p>Step 3. is processing the import of the Data. <span style=\"color: #00a0de;\">A. <\/span>Click on the \u201c<span style=\"color: #00a0de;\">Import data<\/span>\u201d button to start working with the imported data from your Excel file. <span style=\"color: #00a0de;\">B. <\/span>Click on the \u201c<span style=\"color: #00a0de;\">Previous step<\/span>\u201d button to make any changes before creating the project.","protected":false},"excerpt":{"rendered":"<p>A. Import Excel or CSV data BadgeMaker Identity 1. Datasource Fig. Example of the import data popup window. A.\u00a0Click on this button and select the Excel\/CSV file you want to import.. B.\u00a0Select the worksheet you want to use from the drop down menu. C. Select the row that contains the<\/p>\n","protected":false},"author":5,"featured_media":0,"parent":2007,"menu_order":0,"comment_status":"closed","ping_status":"closed","template":"page-user-guide.php","meta":{"footnotes":"","_links_to":"","_links_to_target":""},"class_list":["post-2010","page","type-page","status-publish","hentry"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v27.3 - https:\/\/yoast.com\/product\/yoast-seo-wordpress\/ -->\n<title>A. Import Excel or CSV data - BadgeMaker<\/title>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/badgemaker.info\/userguide2\/badgemaker-identity\/import-data\/import-excel-csv-data\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"A. Import Excel or CSV data - BadgeMaker\" \/>\n<meta property=\"og:description\" content=\"A. Import Excel or CSV data BadgeMaker Identity 1. Datasource Fig. Example of the import data popup window. A.\u00a0Click on this button and select the Excel\/CSV file you want to import.. B.\u00a0Select the worksheet you want to use from the drop down menu. C. Select the row that contains the\" \/>\n<meta property=\"og:url\" content=\"https:\/\/badgemaker.info\/userguide2\/badgemaker-identity\/import-data\/import-excel-csv-data\/\" \/>\n<meta property=\"og:site_name\" content=\"BadgeMaker\" \/>\n<meta property=\"article:publisher\" content=\"https:\/\/www.facebook.com\/BadgeMakersoftware\/\" \/>\n<meta property=\"article:modified_time\" content=\"2016-07-15T09:43:19+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/badgemaker.info\/wp-content\/uploads\/2016\/04\/bm_identity_import_datasource.png\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:site\" content=\"@BadgeMaker_\" \/>\n<meta name=\"twitter:label1\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data1\" content=\"3 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/badgemaker.info\\\/userguide2\\\/badgemaker-identity\\\/import-data\\\/import-excel-csv-data\\\/\",\"url\":\"https:\\\/\\\/badgemaker.info\\\/userguide2\\\/badgemaker-identity\\\/import-data\\\/import-excel-csv-data\\\/\",\"name\":\"A. Import Excel or CSV data - BadgeMaker\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/badgemaker.info\\\/en\\\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\\\/\\\/badgemaker.info\\\/userguide2\\\/badgemaker-identity\\\/import-data\\\/import-excel-csv-data\\\/#primaryimage\"},\"image\":{\"@id\":\"https:\\\/\\\/badgemaker.info\\\/userguide2\\\/badgemaker-identity\\\/import-data\\\/import-excel-csv-data\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/badgemaker.info\\\/wp-content\\\/uploads\\\/2016\\\/04\\\/bm_identity_import_datasource.png\",\"datePublished\":\"2013-12-10T08:22:38+00:00\",\"dateModified\":\"2016-07-15T09:43:19+00:00\",\"breadcrumb\":{\"@id\":\"https:\\\/\\\/badgemaker.info\\\/userguide2\\\/badgemaker-identity\\\/import-data\\\/import-excel-csv-data\\\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/badgemaker.info\\\/userguide2\\\/badgemaker-identity\\\/import-data\\\/import-excel-csv-data\\\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/badgemaker.info\\\/userguide2\\\/badgemaker-identity\\\/import-data\\\/import-excel-csv-data\\\/#primaryimage\",\"url\":\"https:\\\/\\\/badgemaker.info\\\/wp-content\\\/uploads\\\/2016\\\/04\\\/bm_identity_import_datasource.png\",\"contentUrl\":\"https:\\\/\\\/badgemaker.info\\\/wp-content\\\/uploads\\\/2016\\\/04\\\/bm_identity_import_datasource.png\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/badgemaker.info\\\/userguide2\\\/badgemaker-identity\\\/import-data\\\/import-excel-csv-data\\\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\\\/\\\/badgemaker.info\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"BadgeMaker User Guide\",\"item\":\"https:\\\/\\\/badgemaker.info\\\/wp-content\\\/uploads\\\/2025\\\/09\\\/BadgeMaker-UserGuide-V2.11.18-September-2025.pdf\"},{\"@type\":\"ListItem\",\"position\":3,\"name\":\"BadgeMaker Identity\",\"item\":\"https:\\\/\\\/badgemaker.info\\\/userguide2\\\/badgemaker-identity\\\/\"},{\"@type\":\"ListItem\",\"position\":4,\"name\":\"Import Data\",\"item\":\"https:\\\/\\\/badgemaker.info\\\/userguide2\\\/badgemaker-identity\\\/import-data\\\/\"},{\"@type\":\"ListItem\",\"position\":5,\"name\":\"A. Import Excel or CSV data\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/badgemaker.info\\\/en\\\/#website\",\"url\":\"https:\\\/\\\/badgemaker.info\\\/en\\\/\",\"name\":\"BadgeMaker\",\"description\":\"ScreenCheck presents BadgeMaker ID software\",\"publisher\":{\"@id\":\"https:\\\/\\\/badgemaker.info\\\/en\\\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\\\/\\\/badgemaker.info\\\/en\\\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"https:\\\/\\\/badgemaker.info\\\/en\\\/#organization\",\"name\":\"ScreenCheck\",\"url\":\"https:\\\/\\\/badgemaker.info\\\/en\\\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/badgemaker.info\\\/en\\\/#\\\/schema\\\/logo\\\/image\\\/\",\"url\":\"\",\"contentUrl\":\"\",\"caption\":\"ScreenCheck\"},\"image\":{\"@id\":\"https:\\\/\\\/badgemaker.info\\\/en\\\/#\\\/schema\\\/logo\\\/image\\\/\"},\"sameAs\":[\"https:\\\/\\\/www.facebook.com\\\/BadgeMakersoftware\\\/\",\"https:\\\/\\\/x.com\\\/BadgeMaker_\",\"https:\\\/\\\/www.linkedin.com\\\/showcase\\\/9493265\\\/\",\"https:\\\/\\\/www.youtube.com\\\/channel\\\/UCL1iI8MU-A2RbWyYGzpVRow\"]}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"A. Import Excel or CSV data - BadgeMaker","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:\/\/badgemaker.info\/userguide2\/badgemaker-identity\/import-data\/import-excel-csv-data\/","og_locale":"en_US","og_type":"article","og_title":"A. Import Excel or CSV data - BadgeMaker","og_description":"A. Import Excel or CSV data BadgeMaker Identity 1. Datasource Fig. Example of the import data popup window. A.\u00a0Click on this button and select the Excel\/CSV file you want to import.. B.\u00a0Select the worksheet you want to use from the drop down menu. C. Select the row that contains the","og_url":"https:\/\/badgemaker.info\/userguide2\/badgemaker-identity\/import-data\/import-excel-csv-data\/","og_site_name":"BadgeMaker","article_publisher":"https:\/\/www.facebook.com\/BadgeMakersoftware\/","article_modified_time":"2016-07-15T09:43:19+00:00","og_image":[{"url":"https:\/\/badgemaker.info\/wp-content\/uploads\/2016\/04\/bm_identity_import_datasource.png","type":"","width":"","height":""}],"twitter_card":"summary_large_image","twitter_site":"@BadgeMaker_","twitter_misc":{"Est. reading time":"3 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/badgemaker.info\/userguide2\/badgemaker-identity\/import-data\/import-excel-csv-data\/","url":"https:\/\/badgemaker.info\/userguide2\/badgemaker-identity\/import-data\/import-excel-csv-data\/","name":"A. Import Excel or CSV data - BadgeMaker","isPartOf":{"@id":"https:\/\/badgemaker.info\/en\/#website"},"primaryImageOfPage":{"@id":"https:\/\/badgemaker.info\/userguide2\/badgemaker-identity\/import-data\/import-excel-csv-data\/#primaryimage"},"image":{"@id":"https:\/\/badgemaker.info\/userguide2\/badgemaker-identity\/import-data\/import-excel-csv-data\/#primaryimage"},"thumbnailUrl":"https:\/\/badgemaker.info\/wp-content\/uploads\/2016\/04\/bm_identity_import_datasource.png","datePublished":"2013-12-10T08:22:38+00:00","dateModified":"2016-07-15T09:43:19+00:00","breadcrumb":{"@id":"https:\/\/badgemaker.info\/userguide2\/badgemaker-identity\/import-data\/import-excel-csv-data\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/badgemaker.info\/userguide2\/badgemaker-identity\/import-data\/import-excel-csv-data\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/badgemaker.info\/userguide2\/badgemaker-identity\/import-data\/import-excel-csv-data\/#primaryimage","url":"https:\/\/badgemaker.info\/wp-content\/uploads\/2016\/04\/bm_identity_import_datasource.png","contentUrl":"https:\/\/badgemaker.info\/wp-content\/uploads\/2016\/04\/bm_identity_import_datasource.png"},{"@type":"BreadcrumbList","@id":"https:\/\/badgemaker.info\/userguide2\/badgemaker-identity\/import-data\/import-excel-csv-data\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/badgemaker.info\/"},{"@type":"ListItem","position":2,"name":"BadgeMaker User Guide","item":"https:\/\/badgemaker.info\/wp-content\/uploads\/2025\/09\/BadgeMaker-UserGuide-V2.11.18-September-2025.pdf"},{"@type":"ListItem","position":3,"name":"BadgeMaker Identity","item":"https:\/\/badgemaker.info\/userguide2\/badgemaker-identity\/"},{"@type":"ListItem","position":4,"name":"Import Data","item":"https:\/\/badgemaker.info\/userguide2\/badgemaker-identity\/import-data\/"},{"@type":"ListItem","position":5,"name":"A. Import Excel or CSV data"}]},{"@type":"WebSite","@id":"https:\/\/badgemaker.info\/en\/#website","url":"https:\/\/badgemaker.info\/en\/","name":"BadgeMaker","description":"ScreenCheck presents BadgeMaker ID software","publisher":{"@id":"https:\/\/badgemaker.info\/en\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/badgemaker.info\/en\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/badgemaker.info\/en\/#organization","name":"ScreenCheck","url":"https:\/\/badgemaker.info\/en\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/badgemaker.info\/en\/#\/schema\/logo\/image\/","url":"","contentUrl":"","caption":"ScreenCheck"},"image":{"@id":"https:\/\/badgemaker.info\/en\/#\/schema\/logo\/image\/"},"sameAs":["https:\/\/www.facebook.com\/BadgeMakersoftware\/","https:\/\/x.com\/BadgeMaker_","https:\/\/www.linkedin.com\/showcase\/9493265\/","https:\/\/www.youtube.com\/channel\/UCL1iI8MU-A2RbWyYGzpVRow"]}]}},"_links":{"self":[{"href":"https:\/\/badgemaker.info\/en\/wp-json\/wp\/v2\/pages\/2010","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/badgemaker.info\/en\/wp-json\/wp\/v2\/pages"}],"about":[{"href":"https:\/\/badgemaker.info\/en\/wp-json\/wp\/v2\/types\/page"}],"author":[{"embeddable":true,"href":"https:\/\/badgemaker.info\/en\/wp-json\/wp\/v2\/users\/5"}],"replies":[{"embeddable":true,"href":"https:\/\/badgemaker.info\/en\/wp-json\/wp\/v2\/comments?post=2010"}],"version-history":[{"count":18,"href":"https:\/\/badgemaker.info\/en\/wp-json\/wp\/v2\/pages\/2010\/revisions"}],"predecessor-version":[{"id":4116,"href":"https:\/\/badgemaker.info\/en\/wp-json\/wp\/v2\/pages\/2010\/revisions\/4116"}],"up":[{"embeddable":true,"href":"https:\/\/badgemaker.info\/en\/wp-json\/wp\/v2\/pages\/2007"}],"wp:attachment":[{"href":"https:\/\/badgemaker.info\/en\/wp-json\/wp\/v2\/media?parent=2010"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}