{"id":4705,"date":"2013-09-27T13:56:52","date_gmt":"2013-09-27T13:56:52","guid":{"rendered":"https:\/\/123formbuilder.polarbuildingcleaning.net\/docs\/?p=4705"},"modified":"2022-11-01T10:25:40","modified_gmt":"2022-11-01T10:25:40","slug":"fixing-csv-export-in-microsoft-excel","status":"publish","type":"post","link":"https:\/\/123formbuilder.polarbuildingcleaning.net\/docs\/fixing-csv-export-in-microsoft-excel\/","title":{"rendered":"Fixing Form Submissions CSV Export in Microsoft Excel"},"content":{"rendered":"\n<p>There have been some problems reported when trying to open exported CSV files in Microsoft Excel. The submissions wouldn&#8217;t appear as tabular textual data. This is due to the fact that Excel sometimes can&#8217;t directly transform all data accordingly from the exported file. Follow the steps below on how to open a CSV file in Microsoft Excel:<\/p>\n\n\n\n<p>1. In Excel click on <b>New<\/b> and create a <b>Blank workbook<\/b>.<br>2. Next, go to <b>Data \u2192 Get External Data \u2192 From text.<\/b><br>3. Import the CSV file from your computer.<br>4. Check <b>Delimited<\/b> and, at <b>File Origin<\/b>, select <b>65001:Unicode (UTF-8)<\/b> from the dropdown list.<\/p>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-full is-resized\"><a href=\"https:\/\/cdn.marketing123.123formbuilder.com\/wp-content\/uploads\/sites\/3\/2021\/09\/fileoriginexcel.png\"><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/cdn.marketing123.123formbuilder.com\/wp-content\/uploads\/sites\/3\/2021\/09\/fileoriginexcel.png\" alt=\"Excel file origin\" class=\"wp-image-40434\" width=\"733\" height=\"393\" srcset=\"https:\/\/cdn.marketing123.123formbuilder.com\/wp-content\/uploads\/sites\/3\/2021\/09\/fileoriginexcel.png 802w, https:\/\/cdn.marketing123.123formbuilder.com\/wp-content\/uploads\/sites\/3\/2021\/09\/fileoriginexcel-300x161.png 300w, https:\/\/cdn.marketing123.123formbuilder.com\/wp-content\/uploads\/sites\/3\/2021\/09\/fileoriginexcel-768x412.png 768w\" sizes=\"auto, (max-width: 733px) 100vw, 733px\" \/><\/a><\/figure>\n<\/div>\n\n\n<p>5. Click <b>Next<\/b> and, at <b>Delimiters<\/b>, choose the delimiter (field separator), be it space or comma. You\u2019ll see the changes in the window below, within the wizard panel. The delimiter that you choose should be the same as the one you selected when exporting the CSV file from your 123FormBuilder account (Data Separator).<\/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\/2021\/09\/dataseperator123.png\"><img loading=\"lazy\" decoding=\"async\" width=\"690\" height=\"247\" src=\"https:\/\/cdn.marketing123.123formbuilder.com\/wp-content\/uploads\/sites\/3\/2021\/09\/dataseperator123.png\" alt=\"csv file separator\" class=\"wp-image-40435\" srcset=\"https:\/\/cdn.marketing123.123formbuilder.com\/wp-content\/uploads\/sites\/3\/2021\/09\/dataseperator123.png 690w, https:\/\/cdn.marketing123.123formbuilder.com\/wp-content\/uploads\/sites\/3\/2021\/09\/dataseperator123-300x107.png 300w\" sizes=\"auto, (max-width: 690px) 100vw, 690px\" \/><\/a><\/figure>\n<\/div>\n\n\n<p>6. In the same panel choose the enclosure of the fields in <b>Text qualifier<\/b>. The qualifier that you choose should be the same as the one you selected when exporting the CSV file from your 123FormBuilder account. Hit <b>Next<\/b>, then <b>Finish.<\/b><\/p>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-full is-resized\"><a href=\"https:\/\/cdn.marketing123.123formbuilder.com\/wp-content\/uploads\/sites\/3\/2021\/09\/txtqualifierexcel.png\"><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/cdn.marketing123.123formbuilder.com\/wp-content\/uploads\/sites\/3\/2021\/09\/txtqualifierexcel.png\" alt=\"Text qualifier\" class=\"wp-image-40436\" width=\"698\" height=\"248\" srcset=\"https:\/\/cdn.marketing123.123formbuilder.com\/wp-content\/uploads\/sites\/3\/2021\/09\/txtqualifierexcel.png 698w, https:\/\/cdn.marketing123.123formbuilder.com\/wp-content\/uploads\/sites\/3\/2021\/09\/txtqualifierexcel-300x107.png 300w\" sizes=\"auto, (max-width: 698px) 100vw, 698px\" \/><\/a><\/figure>\n<\/div>\n\n\n<p>7. Hit <b>Ok<\/b> and you\u2019re done. Your submissions should now be organized within a table with well-structured columns in your Excel window. <\/p>\n\n\n\n<p>If this doesn\u2019t work, select <b>New worksheet<\/b> before pressing <b>Ok<\/b>, instead of leaving it on <b>Existing worksheet<\/b>. Don&#8217;t forget to save your workbook.<\/p>\n\n\n\n<hr class=\"wp-block-separator has-css-opacity is-style-wide\" \/>\n\n\n\n<p><b>Related articles<\/b><\/p>\n\n\n\n<ul class=\"wp-block-list\"><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><li><a href=\"https:\/\/123formbuilder.polarbuildingcleaning.net\/docs\/i-get-an-error-when-i-open-the-csv-file-why\/\">I get an error when I open the CSV file. Why?<\/a><\/li><\/ul>\n\n\n\n<p><\/p>\n","protected":false},"excerpt":{"rendered":"<p>There have been some problems reported when trying to open exported CSV files in Microsoft Excel. The submissions wouldn&#8217;t appear as tabular textual data. This is due to the fact that Excel sometimes can&#8217;t directly transform all data accordingly from the exported file. Follow the steps below on how to open a CSV file in [&hellip;]<\/p>\n","protected":false},"author":13,"featured_media":-1,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"inline_featured_image":false,"footnotes":""},"categories":[38],"tags":[53,1062],"class_list":["post-4705","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-submissions","tag-aaa_submissions","tag-export-submissions-in-excel"],"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 open CSV file in Microsoft Excel? | 123FormBuilder<\/title>\n<meta name=\"description\" content=\"Follow this documentation on how to open CSV file in Microsoft Excel so that all submission data is correctly displayed as in your Submissions section.\" \/>\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\/fixing-csv-export-in-microsoft-excel\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Fixing Form Submissions CSV Export in Microsoft Excel\" \/>\n<meta property=\"og:description\" content=\"Follow this documentation on how to open CSV file in Microsoft Excel so that all submission data is correctly displayed as in your Submissions section.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/123formbuilder.polarbuildingcleaning.net\/docs\/fixing-csv-export-in-microsoft-excel\/\" \/>\n<meta property=\"og:site_name\" content=\"123FormBuilder Knowledge Base\" \/>\n<meta property=\"article:published_time\" content=\"2013-09-27T13:56:52+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2022-11-01T10:25:40+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/cdn.marketing123.123formbuilder.com\/wp-content\/uploads\/sites\/3\/2021\/09\/fileoriginexcel.png\" \/>\n<meta name=\"author\" content=\"admin\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"admin\" \/>\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 open CSV file in Microsoft Excel? | 123FormBuilder","description":"Follow this documentation on how to open CSV file in Microsoft Excel so that all submission data is correctly displayed as in your Submissions section.","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\/fixing-csv-export-in-microsoft-excel\/","og_locale":"en_US","og_type":"article","og_title":"Fixing Form Submissions CSV Export in Microsoft Excel","og_description":"Follow this documentation on how to open CSV file in Microsoft Excel so that all submission data is correctly displayed as in your Submissions section.","og_url":"https:\/\/123formbuilder.polarbuildingcleaning.net\/docs\/fixing-csv-export-in-microsoft-excel\/","og_site_name":"123FormBuilder Knowledge Base","article_published_time":"2013-09-27T13:56:52+00:00","article_modified_time":"2022-11-01T10:25:40+00:00","og_image":[{"url":"https:\/\/cdn.marketing123.123formbuilder.com\/wp-content\/uploads\/sites\/3\/2021\/09\/fileoriginexcel.png","type":"","width":"","height":""}],"author":"admin","twitter_card":"summary_large_image","twitter_misc":{"Written by":"admin","Est. reading time":"2 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/123formbuilder.polarbuildingcleaning.net\/docs\/fixing-csv-export-in-microsoft-excel\/#article","isPartOf":{"@id":"https:\/\/123formbuilder.polarbuildingcleaning.net\/docs\/fixing-csv-export-in-microsoft-excel\/"},"author":{"name":"admin","@id":"https:\/\/123formbuilder.polarbuildingcleaning.net\/docs\/#\/schema\/person\/ac765b93d6689ec0f4ee6f6e040d66ea"},"headline":"Fixing Form Submissions CSV Export in Microsoft Excel","datePublished":"2013-09-27T13:56:52+00:00","dateModified":"2022-11-01T10:25:40+00:00","mainEntityOfPage":{"@id":"https:\/\/123formbuilder.polarbuildingcleaning.net\/docs\/fixing-csv-export-in-microsoft-excel\/"},"wordCount":266,"commentCount":1,"image":{"@id":"https:\/\/123formbuilder.polarbuildingcleaning.net\/docs\/fixing-csv-export-in-microsoft-excel\/#primaryimage"},"thumbnailUrl":"https:\/\/cdn.marketing123.123formbuilder.com\/wp-content\/uploads\/sites\/3\/2021\/09\/fileoriginexcel.png","keywords":["aaa_submissions","export submissions in excel"],"articleSection":["Submissions"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/123formbuilder.polarbuildingcleaning.net\/docs\/fixing-csv-export-in-microsoft-excel\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/123formbuilder.polarbuildingcleaning.net\/docs\/fixing-csv-export-in-microsoft-excel\/","url":"https:\/\/123formbuilder.polarbuildingcleaning.net\/docs\/fixing-csv-export-in-microsoft-excel\/","name":"How to open CSV file in Microsoft Excel? | 123FormBuilder","isPartOf":{"@id":"https:\/\/123formbuilder.polarbuildingcleaning.net\/docs\/#website"},"primaryImageOfPage":{"@id":"https:\/\/123formbuilder.polarbuildingcleaning.net\/docs\/fixing-csv-export-in-microsoft-excel\/#primaryimage"},"image":{"@id":"https:\/\/123formbuilder.polarbuildingcleaning.net\/docs\/fixing-csv-export-in-microsoft-excel\/#primaryimage"},"thumbnailUrl":"https:\/\/cdn.marketing123.123formbuilder.com\/wp-content\/uploads\/sites\/3\/2021\/09\/fileoriginexcel.png","datePublished":"2013-09-27T13:56:52+00:00","dateModified":"2022-11-01T10:25:40+00:00","author":{"@id":"https:\/\/123formbuilder.polarbuildingcleaning.net\/docs\/#\/schema\/person\/ac765b93d6689ec0f4ee6f6e040d66ea"},"description":"Follow this documentation on how to open CSV file in Microsoft Excel so that all submission data is correctly displayed as in your Submissions section.","breadcrumb":{"@id":"https:\/\/123formbuilder.polarbuildingcleaning.net\/docs\/fixing-csv-export-in-microsoft-excel\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/123formbuilder.polarbuildingcleaning.net\/docs\/fixing-csv-export-in-microsoft-excel\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/123formbuilder.polarbuildingcleaning.net\/docs\/fixing-csv-export-in-microsoft-excel\/#primaryimage","url":"https:\/\/cdn.marketing123.123formbuilder.com\/wp-content\/uploads\/sites\/3\/2021\/09\/fileoriginexcel.png","contentUrl":"https:\/\/cdn.marketing123.123formbuilder.com\/wp-content\/uploads\/sites\/3\/2021\/09\/fileoriginexcel.png"},{"@type":"BreadcrumbList","@id":"https:\/\/123formbuilder.polarbuildingcleaning.net\/docs\/fixing-csv-export-in-microsoft-excel\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/123formbuilder.polarbuildingcleaning.net\/docs\/"},{"@type":"ListItem","position":2,"name":"Fixing Form Submissions CSV Export in Microsoft Excel"}]},{"@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\/ac765b93d6689ec0f4ee6f6e040d66ea","name":"admin","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/secure.gravatar.com\/avatar\/41383a571ede8f1257b128aa53a410cc1ea4c1901ac8cea3776cba5438d24843?s=96&d=https%3A%2F%2Fui-avatars.com%2Fapi%2Fadmin%2F96%2Ff3f3f3%2Faaa%2F1%2F0.5%2Ffalse%2Ftrue&r=g","url":"https:\/\/secure.gravatar.com\/avatar\/41383a571ede8f1257b128aa53a410cc1ea4c1901ac8cea3776cba5438d24843?s=96&d=https%3A%2F%2Fui-avatars.com%2Fapi%2Fadmin%2F96%2Ff3f3f3%2Faaa%2F1%2F0.5%2Ffalse%2Ftrue&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/41383a571ede8f1257b128aa53a410cc1ea4c1901ac8cea3776cba5438d24843?s=96&d=https%3A%2F%2Fui-avatars.com%2Fapi%2Fadmin%2F96%2Ff3f3f3%2Faaa%2F1%2F0.5%2Ffalse%2Ftrue&r=g","caption":"admin"},"url":"https:\/\/123formbuilder.polarbuildingcleaning.net\/docs\/author\/admin\/"}]}},"_links":{"self":[{"href":"https:\/\/123formbuilder.polarbuildingcleaning.net\/docs\/wp-json\/wp\/v2\/posts\/4705","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\/13"}],"replies":[{"embeddable":true,"href":"https:\/\/123formbuilder.polarbuildingcleaning.net\/docs\/wp-json\/wp\/v2\/comments?post=4705"}],"version-history":[{"count":43,"href":"https:\/\/123formbuilder.polarbuildingcleaning.net\/docs\/wp-json\/wp\/v2\/posts\/4705\/revisions"}],"predecessor-version":[{"id":45176,"href":"https:\/\/123formbuilder.polarbuildingcleaning.net\/docs\/wp-json\/wp\/v2\/posts\/4705\/revisions\/45176"}],"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=4705"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/123formbuilder.polarbuildingcleaning.net\/docs\/wp-json\/wp\/v2\/categories?post=4705"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/123formbuilder.polarbuildingcleaning.net\/docs\/wp-json\/wp\/v2\/tags?post=4705"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}