{"id":35675,"date":"2019-10-16T19:07:59","date_gmt":"2019-10-16T19:07:59","guid":{"rendered":"https:\/\/123formbuilder.polarbuildingcleaning.net\/docs\/?p=35675"},"modified":"2023-11-24T11:09:54","modified_gmt":"2023-11-24T11:09:54","slug":"how-to-import-submissions-on-your-form","status":"publish","type":"post","link":"https:\/\/123formbuilder.polarbuildingcleaning.net\/docs\/how-to-import-submissions-on-your-form\/","title":{"rendered":"How to import submissions on your 123FormBuilder form"},"content":{"rendered":"\n<p>Your form submissions are stored on our <a href=\"\/\">form builder<\/a> servers and are available to you in the <strong>Submissions<\/strong> section. You are able to import submissions on your form from an external CSV file or use the CSV file exported from another form.<\/p>\n\n\n\n<p>Before starting, it is important that the columns of your CSV file are named the same as your form fields. Also, the field types from your file (e.g numeric, alpha, alphanumeric) that you choose should be the same as your form fields. Matching different types of fields will not import the data.<\/p>\n\n\n\n<p><\/p>\n\n\n\n<p>In order to do this, click on <strong>Results<\/strong> and navigate to <strong>Submissions <\/strong>tab. <\/p>\n\n\n\n<p><\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><a href=\"https:\/\/cdn.marketing123.123formbuilder.com\/wp-content\/uploads\/sites\/3\/2023\/11\/image-290.png\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"261\" src=\"https:\/\/cdn.marketing123.123formbuilder.com\/wp-content\/uploads\/sites\/3\/2023\/11\/image-290-1024x261.png\" alt=\"Results\" class=\"wp-image-47987\" srcset=\"https:\/\/cdn.marketing123.123formbuilder.com\/wp-content\/uploads\/sites\/3\/2023\/11\/image-290-1024x261.png 1024w, https:\/\/cdn.marketing123.123formbuilder.com\/wp-content\/uploads\/sites\/3\/2023\/11\/image-290-300x76.png 300w, https:\/\/cdn.marketing123.123formbuilder.com\/wp-content\/uploads\/sites\/3\/2023\/11\/image-290-768x196.png 768w, https:\/\/cdn.marketing123.123formbuilder.com\/wp-content\/uploads\/sites\/3\/2023\/11\/image-290-1536x391.png 1536w, https:\/\/cdn.marketing123.123formbuilder.com\/wp-content\/uploads\/sites\/3\/2023\/11\/image-290.png 1899w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><\/a><\/figure>\n\n\n\n<p><\/p>\n\n\n\n<p>In order to import submissions on your form, click on <strong>Import<\/strong> button. <\/p>\n\n\n\n<p><\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><a href=\"https:\/\/cdn.marketing123.123formbuilder.com\/wp-content\/uploads\/sites\/3\/2023\/11\/Screenshot-2023-11-24-at-13.09.29.png\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"261\" src=\"https:\/\/cdn.marketing123.123formbuilder.com\/wp-content\/uploads\/sites\/3\/2023\/11\/Screenshot-2023-11-24-at-13.09.29-1024x261.png\" alt=\"Import button\" class=\"wp-image-47988\" srcset=\"https:\/\/cdn.marketing123.123formbuilder.com\/wp-content\/uploads\/sites\/3\/2023\/11\/Screenshot-2023-11-24-at-13.09.29-1024x261.png 1024w, https:\/\/cdn.marketing123.123formbuilder.com\/wp-content\/uploads\/sites\/3\/2023\/11\/Screenshot-2023-11-24-at-13.09.29-300x76.png 300w, https:\/\/cdn.marketing123.123formbuilder.com\/wp-content\/uploads\/sites\/3\/2023\/11\/Screenshot-2023-11-24-at-13.09.29-768x196.png 768w, https:\/\/cdn.marketing123.123formbuilder.com\/wp-content\/uploads\/sites\/3\/2023\/11\/Screenshot-2023-11-24-at-13.09.29-1536x391.png 1536w, https:\/\/cdn.marketing123.123formbuilder.com\/wp-content\/uploads\/sites\/3\/2023\/11\/Screenshot-2023-11-24-at-13.09.29.png 1899w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><\/a><\/figure>\n\n\n\n<p><\/p>\n\n\n\n<p><\/p>\n\n\n\n<p>In the lightbox that appears, click on <strong>Choose File <\/strong>and select a CSV file to upload data for the form. Hit <strong>Import<\/strong>.<\/p>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-full\"><a href=\"https:\/\/cdn.marketing123.123formbuilder.com\/wp-content\/uploads\/sites\/3\/2022\/11\/image-13.png\"><img loading=\"lazy\" decoding=\"async\" width=\"443\" height=\"300\" src=\"https:\/\/cdn.marketing123.123formbuilder.com\/wp-content\/uploads\/sites\/3\/2022\/11\/image-13.png\" alt=\"Import CSV\" class=\"wp-image-45167\" srcset=\"https:\/\/cdn.marketing123.123formbuilder.com\/wp-content\/uploads\/sites\/3\/2022\/11\/image-13.png 443w, https:\/\/cdn.marketing123.123formbuilder.com\/wp-content\/uploads\/sites\/3\/2022\/11\/image-13-300x203.png 300w\" sizes=\"auto, (max-width: 443px) 100vw, 443px\" \/><\/a><\/figure>\n<\/div>\n\n\n<p>Map the form fields on the right side with your CSV fields on the left side. Once you finished mapping them click <strong>Ready<\/strong> and you&#8217;re done.<\/p>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-full\"><a href=\"https:\/\/cdn.marketing123.123formbuilder.com\/wp-content\/uploads\/sites\/3\/2022\/11\/image-14.png\"><img loading=\"lazy\" decoding=\"async\" width=\"436\" height=\"304\" src=\"https:\/\/cdn.marketing123.123formbuilder.com\/wp-content\/uploads\/sites\/3\/2022\/11\/image-14.png\" alt=\"Map fields CSV\" class=\"wp-image-45168\" srcset=\"https:\/\/cdn.marketing123.123formbuilder.com\/wp-content\/uploads\/sites\/3\/2022\/11\/image-14.png 436w, https:\/\/cdn.marketing123.123formbuilder.com\/wp-content\/uploads\/sites\/3\/2022\/11\/image-14-300x209.png 300w\" sizes=\"auto, (max-width: 436px) 100vw, 436px\" \/><\/a><\/figure>\n<\/div>\n\n\n<p>Importing form submission will disorganize the Entry ID numeration. To keep track of your submissions, enable the<a href=\"https:\/\/123formbuilder.polarbuildingcleaning.net\/docs\/how-to-include-timestamps-in-email-notifications\/\"> Reference ID<\/a> option.<\/p>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-full\"><a href=\"https:\/\/cdn.marketing123.123formbuilder.com\/wp-content\/uploads\/sites\/3\/2022\/11\/image-15.png\"><img loading=\"lazy\" decoding=\"async\" width=\"138\" height=\"352\" src=\"https:\/\/cdn.marketing123.123formbuilder.com\/wp-content\/uploads\/sites\/3\/2022\/11\/image-15.png\" alt=\"Entry ID\" class=\"wp-image-45169\" srcset=\"https:\/\/cdn.marketing123.123formbuilder.com\/wp-content\/uploads\/sites\/3\/2022\/11\/image-15.png 138w, https:\/\/cdn.marketing123.123formbuilder.com\/wp-content\/uploads\/sites\/3\/2022\/11\/image-15-118x300.png 118w\" sizes=\"auto, (max-width: 138px) 100vw, 138px\" \/><\/a><\/figure>\n<\/div>\n\n\n<p><\/p>\n\n\n\n<p><strong>Related articles<\/strong><\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li><a href=\"https:\/\/123formbuilder.polarbuildingcleaning.net\/docs\/how-to-export-to-excel-web-form-submissions\/\">How to export form submissions to excel?<\/a><\/li>\n\n\n\n<li><a href=\"https:\/\/123formbuilder.polarbuildingcleaning.net\/docs\/how-to-export-all-of-my-submissions-to-csv\/\">How to export all of my submissions to CSV?<\/a><\/li>\n\n\n\n<li><a href=\"https:\/\/123formbuilder.polarbuildingcleaning.net\/docs\/fixing-csv-export-in-microsoft-excel\/\">Fixing CSV export in Microsoft Excel<\/a><\/li>\n<\/ul>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\" \/>\n","protected":false},"excerpt":{"rendered":"<p>Your form submissions are stored on our form builder servers and are available to you in the Submissions section. You are able to import submissions on your form from an external CSV file or use the CSV file exported from another form. Before starting, it is important that the columns of your CSV file are [&hellip;]<\/p>\n","protected":false},"author":49,"featured_media":-1,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"inline_featured_image":false,"footnotes":""},"categories":[38],"tags":[1058],"class_list":["post-35675","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-submissions","tag-import-submissions"],"yoast_head":"<!-- This site is optimized with the Yoast SEO Premium plugin v24.2 (Yoast SEO v27.2) - https:\/\/yoast.com\/product\/yoast-seo-premium-wordpress\/ -->\n<title>How to import submissions on your form | 123FormBuilder Docs<\/title>\n<meta name=\"description\" content=\"Learn how to import submissions on your 123FormBuilder forms using a CSV file. Follow these step-by-step instructions and start importing your CSV files.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/123formbuilder.polarbuildingcleaning.net\/docs\/how-to-import-submissions-on-your-form\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"How to import submissions on your 123FormBuilder form\" \/>\n<meta property=\"og:description\" content=\"Learn how to import submissions on your 123FormBuilder forms using a CSV file. Follow these step-by-step instructions and start importing your CSV files.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/123formbuilder.polarbuildingcleaning.net\/docs\/how-to-import-submissions-on-your-form\/\" \/>\n<meta property=\"og:site_name\" content=\"123FormBuilder Knowledge Base\" \/>\n<meta property=\"article:published_time\" content=\"2019-10-16T19:07:59+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2023-11-24T11:09:54+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/cdn.marketing123.123formbuilder.com\/wp-content\/uploads\/sites\/3\/2023\/11\/image-290-1024x261.png\" \/>\n<meta name=\"author\" content=\"Julia\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Julia\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"2 minutes\" \/>\n<!-- \/ Yoast SEO Premium plugin. -->","yoast_head_json":{"title":"How to import submissions on your form | 123FormBuilder Docs","description":"Learn how to import submissions on your 123FormBuilder forms using a CSV file. Follow these step-by-step instructions and start importing your CSV files.","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:\/\/123formbuilder.polarbuildingcleaning.net\/docs\/how-to-import-submissions-on-your-form\/","og_locale":"en_US","og_type":"article","og_title":"How to import submissions on your 123FormBuilder form","og_description":"Learn how to import submissions on your 123FormBuilder forms using a CSV file. Follow these step-by-step instructions and start importing your CSV files.","og_url":"https:\/\/123formbuilder.polarbuildingcleaning.net\/docs\/how-to-import-submissions-on-your-form\/","og_site_name":"123FormBuilder Knowledge Base","article_published_time":"2019-10-16T19:07:59+00:00","article_modified_time":"2023-11-24T11:09:54+00:00","og_image":[{"url":"https:\/\/cdn.marketing123.123formbuilder.com\/wp-content\/uploads\/sites\/3\/2023\/11\/image-290-1024x261.png","type":"","width":"","height":""}],"author":"Julia","twitter_card":"summary_large_image","twitter_misc":{"Written by":"Julia","Est. reading time":"2 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/123formbuilder.polarbuildingcleaning.net\/docs\/how-to-import-submissions-on-your-form\/#article","isPartOf":{"@id":"https:\/\/123formbuilder.polarbuildingcleaning.net\/docs\/how-to-import-submissions-on-your-form\/"},"author":{"name":"Julia","@id":"https:\/\/123formbuilder.polarbuildingcleaning.net\/docs\/#\/schema\/person\/cc469207f9fad9e280a743a5dc96a843"},"headline":"How to import submissions on your 123FormBuilder form","datePublished":"2019-10-16T19:07:59+00:00","dateModified":"2023-11-24T11:09:54+00:00","mainEntityOfPage":{"@id":"https:\/\/123formbuilder.polarbuildingcleaning.net\/docs\/how-to-import-submissions-on-your-form\/"},"wordCount":221,"commentCount":0,"image":{"@id":"https:\/\/123formbuilder.polarbuildingcleaning.net\/docs\/how-to-import-submissions-on-your-form\/#primaryimage"},"thumbnailUrl":"https:\/\/cdn.marketing123.123formbuilder.com\/wp-content\/uploads\/sites\/3\/2023\/11\/image-290-1024x261.png","keywords":["import submissions"],"articleSection":["Submissions"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/123formbuilder.polarbuildingcleaning.net\/docs\/how-to-import-submissions-on-your-form\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/123formbuilder.polarbuildingcleaning.net\/docs\/how-to-import-submissions-on-your-form\/","url":"https:\/\/123formbuilder.polarbuildingcleaning.net\/docs\/how-to-import-submissions-on-your-form\/","name":"How to import submissions on your form | 123FormBuilder Docs","isPartOf":{"@id":"https:\/\/123formbuilder.polarbuildingcleaning.net\/docs\/#website"},"primaryImageOfPage":{"@id":"https:\/\/123formbuilder.polarbuildingcleaning.net\/docs\/how-to-import-submissions-on-your-form\/#primaryimage"},"image":{"@id":"https:\/\/123formbuilder.polarbuildingcleaning.net\/docs\/how-to-import-submissions-on-your-form\/#primaryimage"},"thumbnailUrl":"https:\/\/cdn.marketing123.123formbuilder.com\/wp-content\/uploads\/sites\/3\/2023\/11\/image-290-1024x261.png","datePublished":"2019-10-16T19:07:59+00:00","dateModified":"2023-11-24T11:09:54+00:00","author":{"@id":"https:\/\/123formbuilder.polarbuildingcleaning.net\/docs\/#\/schema\/person\/cc469207f9fad9e280a743a5dc96a843"},"description":"Learn how to import submissions on your 123FormBuilder forms using a CSV file. Follow these step-by-step instructions and start importing your CSV files.","breadcrumb":{"@id":"https:\/\/123formbuilder.polarbuildingcleaning.net\/docs\/how-to-import-submissions-on-your-form\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/123formbuilder.polarbuildingcleaning.net\/docs\/how-to-import-submissions-on-your-form\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/123formbuilder.polarbuildingcleaning.net\/docs\/how-to-import-submissions-on-your-form\/#primaryimage","url":"https:\/\/cdn.marketing123.123formbuilder.com\/wp-content\/uploads\/sites\/3\/2023\/11\/image-290-1024x261.png","contentUrl":"https:\/\/cdn.marketing123.123formbuilder.com\/wp-content\/uploads\/sites\/3\/2023\/11\/image-290-1024x261.png"},{"@type":"BreadcrumbList","@id":"https:\/\/123formbuilder.polarbuildingcleaning.net\/docs\/how-to-import-submissions-on-your-form\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/123formbuilder.polarbuildingcleaning.net\/docs\/"},{"@type":"ListItem","position":2,"name":"How to import submissions on your 123FormBuilder form"}]},{"@type":"WebSite","@id":"https:\/\/123formbuilder.polarbuildingcleaning.net\/docs\/#website","url":"https:\/\/123formbuilder.polarbuildingcleaning.net\/docs\/","name":"123FormBuilder Knowledge Base","description":"Search our documentation platform for answers, service specifications and 3rd-party integrations.","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/123formbuilder.polarbuildingcleaning.net\/docs\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Person","@id":"https:\/\/123formbuilder.polarbuildingcleaning.net\/docs\/#\/schema\/person\/cc469207f9fad9e280a743a5dc96a843","name":"Julia","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/secure.gravatar.com\/avatar\/1b07bbd30c86170f8eb191468f69aaeab7b6cfddcd35ceaf4099ab76a5dccb06?s=96&d=https%3A%2F%2Fui-avatars.com%2Fapi%2FJulia%2F96%2Ff3f3f3%2Faaa%2F1%2F0.5%2Ffalse%2Ftrue&r=g","url":"https:\/\/secure.gravatar.com\/avatar\/1b07bbd30c86170f8eb191468f69aaeab7b6cfddcd35ceaf4099ab76a5dccb06?s=96&d=https%3A%2F%2Fui-avatars.com%2Fapi%2FJulia%2F96%2Ff3f3f3%2Faaa%2F1%2F0.5%2Ffalse%2Ftrue&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/1b07bbd30c86170f8eb191468f69aaeab7b6cfddcd35ceaf4099ab76a5dccb06?s=96&d=https%3A%2F%2Fui-avatars.com%2Fapi%2FJulia%2F96%2Ff3f3f3%2Faaa%2F1%2F0.5%2Ffalse%2Ftrue&r=g","caption":"Julia"},"url":"https:\/\/123formbuilder.polarbuildingcleaning.net\/docs\/author\/julia-unguras123formbuilder-com\/"}]}},"_links":{"self":[{"href":"https:\/\/123formbuilder.polarbuildingcleaning.net\/docs\/wp-json\/wp\/v2\/posts\/35675","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/123formbuilder.polarbuildingcleaning.net\/docs\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/123formbuilder.polarbuildingcleaning.net\/docs\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/123formbuilder.polarbuildingcleaning.net\/docs\/wp-json\/wp\/v2\/users\/49"}],"replies":[{"embeddable":true,"href":"https:\/\/123formbuilder.polarbuildingcleaning.net\/docs\/wp-json\/wp\/v2\/comments?post=35675"}],"version-history":[{"count":15,"href":"https:\/\/123formbuilder.polarbuildingcleaning.net\/docs\/wp-json\/wp\/v2\/posts\/35675\/revisions"}],"predecessor-version":[{"id":47989,"href":"https:\/\/123formbuilder.polarbuildingcleaning.net\/docs\/wp-json\/wp\/v2\/posts\/35675\/revisions\/47989"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/123formbuilder.polarbuildingcleaning.net\/docs\/wp-json\/"}],"wp:attachment":[{"href":"https:\/\/123formbuilder.polarbuildingcleaning.net\/docs\/wp-json\/wp\/v2\/media?parent=35675"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/123formbuilder.polarbuildingcleaning.net\/docs\/wp-json\/wp\/v2\/categories?post=35675"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/123formbuilder.polarbuildingcleaning.net\/docs\/wp-json\/wp\/v2\/tags?post=35675"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}