{"id":34229,"date":"2024-01-24T04:48:27","date_gmt":"2024-01-24T03:48:27","guid":{"rendered":"https:\/\/www.myexcelonline.com\/?p=34229"},"modified":"2024-04-05T19:34:11","modified_gmt":"2024-04-05T17:34:11","slug":"how-to-change-excel-csv-separator","status":"publish","type":"post","link":"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/how-to-change-excel-csv-separator\/","title":{"rendered":"How to Change Excel CSV separator"},"content":{"rendered":"<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2024\/01\/Excel-CSV-Separator.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-34284 size-large\" title=\"Excel CSV Separator\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2024\/01\/Excel-CSV-Separator-1024x576.png\" alt=\"Excel CSV Separator\" width=\"1024\" height=\"576\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2024\/01\/Excel-CSV-Separator-1024x576.png 1024w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2024\/01\/Excel-CSV-Separator-300x169.png 300w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2024\/01\/Excel-CSV-Separator-768x432.png 768w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2024\/01\/Excel-CSV-Separator.png 1280w\" sizes=\"(max-width: 1024px) 100vw, 1024px\" \/><\/a><\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/free-microsoft-excel-online-course\/\" target=\"_blank\" rel=\"noopener\"><strong>Microsoft Excel<\/strong><\/a> is a powerful spreadsheet application widely used for data analysis and manipulation. When working with <a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/combine-csv-files\/\" target=\"_blank\" rel=\"noopener\"><strong>CSV<\/strong><\/a> (Comma-Separated Values) files, you may encounter situations where you need to<strong> change the Excel CSV separator from comma to semi-colon<\/strong>.<\/p>\n<p>Let us look at each of these points in detail.<\/p>\n<h4>Download the Excel Workbook below to follow along and understand How to Change Excel CSV Separator \u2013 <a class=\"IRPP_minimalist icon-download\" href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2024\/01\/Excel-CSV-Separator.csv\" target=\"_blank\" rel=\"noopener\"><span class=\"ctaText px-3 text-capitalize\"><strong>download excel\u00a0<\/strong><strong>workbook<\/strong><\/span><span class=\"postTitle px-3\">Excel-CSV-Separator.csv<\/span><\/a><\/h4>\n<p>&nbsp;<\/p>\n<div id=\"ez-toc-container\" class=\"ez-toc-v2_0_57_1 counter-flat ez-toc-counter ez-toc-transparent ez-toc-container-direction\">\n<div class=\"ez-toc-title-container\">\n<p class=\"ez-toc-title \" >Table of Contents<\/p>\n<span class=\"ez-toc-title-toggle\"><\/span><\/div>\n<nav><ul class='ez-toc-list ez-toc-list-level-1 ' ><li><a href=\"#\" class=\"scroll-to-download\">Free Practice Workbook<\/a><\/li><li class='ez-toc-page-1'><a class=\"ez-toc-link ez-toc-heading-1\" href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/how-to-change-excel-csv-separator\/#Understand_Default_Excel_CSV_separator\" title=\"Understand Default Excel CSV separator\">Understand Default Excel CSV separator<\/a><\/li><li class='ez-toc-page-1'><a class=\"ez-toc-link ez-toc-heading-2\" href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/how-to-change-excel-csv-separator\/#Change_Separator_in_Excel_Setting\" title=\"Change Separator in Excel Setting\">Change Separator in Excel Setting<\/a><\/li><li class='ez-toc-page-1'><a class=\"ez-toc-link ez-toc-heading-3\" href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/how-to-change-excel-csv-separator\/#Indicate_Separator_in_CSV_file\" title=\"Indicate Separator in CSV file\">Indicate Separator in CSV file<\/a><\/li><li class='ez-toc-page-1'><a class=\"ez-toc-link ez-toc-heading-4\" href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/how-to-change-excel-csv-separator\/#Choose_Delimiter_in_Text_Import_Wizard\" title=\"Choose Delimiter in Text Import Wizard\">Choose Delimiter in Text Import Wizard<\/a><\/li><li class='ez-toc-page-1'><a class=\"ez-toc-link ez-toc-heading-5\" href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/how-to-change-excel-csv-separator\/#Change_Separator_in_Window_Setting\" title=\"Change Separator in Window Setting\">Change Separator in Window Setting<\/a><\/li><li class='ez-toc-page-1'><a class=\"ez-toc-link ez-toc-heading-6\" href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/how-to-change-excel-csv-separator\/#Conclusion\" title=\"Conclusion\">Conclusion<\/a><\/li><\/ul><\/nav><\/div>\n<h2><span class=\"ez-toc-section\" id=\"Understand_Default_Excel_CSV_separator\"><\/span><strong><span id=\"5\" style=\"color: #ff0000;\">Understand Default Excel CSV separator<\/span><\/strong><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>Before we delve into the different methods to change the Excel CSV separator, let us first understand <strong>what delimiter Excel uses for CSV files<\/strong>.<\/p>\n<p>In the <strong>USA, UK, and other English-speaking countries<\/strong>, a<strong> comma(,) is used as a thousand separator, and a dot(.) is used for decimal points<\/strong>. In <strong>European<\/strong> countries, a <strong>dot(.) is used as a thousand separator and a comma(,) is used for decimal points<\/strong>.<\/p>\n<p>For example &#8211;<\/p>\n<p><strong>USA and UK:<\/strong> 123,456,789.00<\/p>\n<p><strong>Europe:<\/strong> 123.456.789,00<\/p>\n<p>The delimiter CSV uses as a separator should be different from<strong>\u00a0the <a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/add-custom-symbols-with-your-numbers-in-excel\/\" target=\"_blank\" rel=\"noopener\">symbol<\/a> used to separate thousands<\/strong>. So, in European countries, the list separator is set to a semicolon and you may need to change it to a comma.<\/p>\n<p>This article will\u00a0 further guide you through the different methods for changing the CSV delimiter in Excel &#8211;<\/p>\n<h3><\/h3>\n<h2><span class=\"ez-toc-section\" id=\"Change_Separator_in_Excel_Setting\"><\/span><strong><span id=\"1\" style=\"color: #ff0000;\">Change Separator in Excel Setting<\/span><\/strong><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>To change the Excel CSV separator to a comma, follow the steps below &#8211;<\/p>\n<p><strong><span style=\"color: #ff0000;\">STEP 1:<\/span><\/strong> Go to the <strong>File<\/strong> &gt; <strong>Options<\/strong>.<\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2024\/01\/Excel-CSV-Separator-7.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone wp-image-34261\" title=\"Excel CSV Separator\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2024\/01\/Excel-CSV-Separator-7.png\" alt=\"Excel CSV Separator\" width=\"671\" height=\"640\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2024\/01\/Excel-CSV-Separator-7.png 1057w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2024\/01\/Excel-CSV-Separator-7-300x286.png 300w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2024\/01\/Excel-CSV-Separator-7-1024x977.png 1024w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2024\/01\/Excel-CSV-Separator-7-768x732.png 768w\" sizes=\"(max-width: 671px) 100vw, 671px\" \/><\/a><\/p>\n<p><strong><span style=\"color: #ff0000;\">STEP 2:<\/span><\/strong> In the Excel Options dialog box, select <strong>Advanced<\/strong>.<\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2024\/01\/Excel-CSV-Separator-8.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone wp-image-34258\" title=\"Excel CSV Separator\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2024\/01\/Excel-CSV-Separator-8.png\" alt=\"Excel CSV Separator\" width=\"672\" height=\"548\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2024\/01\/Excel-CSV-Separator-8.png 1032w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2024\/01\/Excel-CSV-Separator-8-300x245.png 300w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2024\/01\/Excel-CSV-Separator-8-1024x835.png 1024w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2024\/01\/Excel-CSV-Separator-8-768x627.png 768w\" sizes=\"(max-width: 672px) 100vw, 672px\" \/><\/a><\/p>\n<p><strong><span style=\"color: #ff0000;\">STEP 3: <\/span><\/strong>Under Editing Options, uncheck the <strong>Use system separators<\/strong> check box.<\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2024\/01\/Excel-CSV-Separator-9.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone wp-image-34259\" title=\"Excel CSV Separator\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2024\/01\/Excel-CSV-Separator-9.png\" alt=\"Excel CSV Separator\" width=\"676\" height=\"553\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2024\/01\/Excel-CSV-Separator-9.png 1033w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2024\/01\/Excel-CSV-Separator-9-300x245.png 300w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2024\/01\/Excel-CSV-Separator-9-1024x838.png 1024w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2024\/01\/Excel-CSV-Separator-9-768x628.png 768w\" sizes=\"(max-width: 676px) 100vw, 676px\" \/><\/a><\/p>\n<p><strong><span style=\"color: #ff0000;\">STEP 4: <\/span><\/strong>Set the <strong>Decimal separator to dot(.)<\/strong> and the <strong>Thousand separator to comma(,)<\/strong>.<\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2024\/01\/Excel-CSV-Separator-10.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone wp-image-34260\" title=\"Excel CSV Separator\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2024\/01\/Excel-CSV-Separator-10.png\" alt=\"Excel CSV Separator\" width=\"692\" height=\"565\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2024\/01\/Excel-CSV-Separator-10.png 1032w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2024\/01\/Excel-CSV-Separator-10-300x245.png 300w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2024\/01\/Excel-CSV-Separator-10-1024x835.png 1024w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2024\/01\/Excel-CSV-Separator-10-768x627.png 768w\" sizes=\"(max-width: 692px) 100vw, 692px\" \/><\/a><\/p>\n<p>This configuration ensures that the Excel file is saved as CSV with a comma <a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/split-string-in-excel\/\" target=\"_blank\" rel=\"noopener\"><strong>delimiter<\/strong><\/a>, as the decimal separator is set to a dot (.).<\/p>\n<p>&nbsp;<\/p>\n<h2><span class=\"ez-toc-section\" id=\"Indicate_Separator_in_CSV_file\"><\/span><strong><span id=\"2\" style=\"color: #ff0000;\">Indicate Separator in CSV file<\/span><\/strong><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>To specify the separator directly in the <a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/combine-csv-files\/\" target=\"_blank\" rel=\"noopener\">CSV file<\/a>, follow the steps below &#8211;<\/p>\n<p><strong><span style=\"color: #ff0000;\">STEP 1:<\/span><\/strong> Right-click on the file and select <strong>Open With<\/strong> &gt; <strong>Notepad<\/strong>.<\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2024\/01\/Excel-CSV-Separator-5.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone wp-image-34255 size-full\" title=\"Excel CSV Separator\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2024\/01\/Excel-CSV-Separator-5.png\" alt=\"Excel CSV Separator\" width=\"871\" height=\"551\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2024\/01\/Excel-CSV-Separator-5.png 871w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2024\/01\/Excel-CSV-Separator-5-300x190.png 300w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2024\/01\/Excel-CSV-Separator-5-768x486.png 768w\" sizes=\"(max-width: 871px) 100vw, 871px\" \/><\/a><\/p>\n<p><strong><span style=\"color: #ff0000;\">STEP 2: <\/span><\/strong>Type this text at the beginning: <strong>sep=,<\/strong><\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2024\/01\/Excel-CSV-Separator-6.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone wp-image-34256 size-full\" title=\"Excel CSV Separator\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2024\/01\/Excel-CSV-Separator-6.png\" alt=\"Excel CSV Separator\" width=\"1413\" height=\"673\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2024\/01\/Excel-CSV-Separator-6.png 1413w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2024\/01\/Excel-CSV-Separator-6-300x143.png 300w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2024\/01\/Excel-CSV-Separator-6-1024x488.png 1024w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2024\/01\/Excel-CSV-Separator-6-768x366.png 768w\" sizes=\"(max-width: 1413px) 100vw, 1413px\" \/><\/a><\/p>\n<p><strong><span style=\"color: #ff0000;\">STEP 3: <\/span><\/strong>Press Ctrl + S to <strong>save <\/strong>the file.<\/p>\n<p>By explicitly indicating the separator (in this case, a comma), Excel will recognize and adhere to it upon opening the CSV file. Users can replace the comma with their desired separator, such as a semi-colon, dot, etc.<\/p>\n<p>&nbsp;<\/p>\n<h2><span class=\"ez-toc-section\" id=\"Choose_Delimiter_in_Text_Import_Wizard\"><\/span><strong><span id=\"3\" style=\"color: #ff0000;\">Choose Delimiter in Text Import Wizard<\/span><\/strong><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>An alternative method for managing a CSV file that uses a custom delimiter is to<a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/use-external-data-source-create-new-pivot-table\/\" target=\"_blank\" rel=\"noopener\"><strong> import the file<\/strong><\/a> instead of simply opening it. Follow the steps below to change the Excel CSV separator &#8211;<\/p>\n<p><strong><span style=\"color: #ff0000;\">STEP 1:<\/span><\/strong> <strong>Change the extension<\/strong> of the file from<strong> .csv to .txt<\/strong><\/p>\n<p><strong><span style=\"color: #ff0000;\">STEP 2:<\/span><\/strong> Go to the <strong>Data<\/strong> &gt; <strong>From Text\/CSV<\/strong>.<\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2024\/01\/Excel-CSV-Separator-1.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone wp-image-34250 size-full\" title=\"Excel CSV Separator\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2024\/01\/Excel-CSV-Separator-1.png\" alt=\"Excel CSV Separator\" width=\"1543\" height=\"167\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2024\/01\/Excel-CSV-Separator-1.png 1543w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2024\/01\/Excel-CSV-Separator-1-300x32.png 300w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2024\/01\/Excel-CSV-Separator-1-1024x111.png 1024w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2024\/01\/Excel-CSV-Separator-1-768x83.png 768w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2024\/01\/Excel-CSV-Separator-1-1536x166.png 1536w\" sizes=\"(max-width: 1543px) 100vw, 1543px\" \/><\/a><\/p>\n<p><strong><span style=\"color: #ff0000;\">STEP 3:<\/span><\/strong> Select the .txt file and click on <strong>Import<\/strong>.<\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2024\/01\/Excel-CSV-Separator-2.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone wp-image-34251 size-full\" title=\"Excel CSV Separator\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2024\/01\/Excel-CSV-Separator-2.png\" alt=\"Excel CSV Separator\" width=\"937\" height=\"583\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2024\/01\/Excel-CSV-Separator-2.png 937w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2024\/01\/Excel-CSV-Separator-2-300x187.png 300w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2024\/01\/Excel-CSV-Separator-2-768x478.png 768w\" sizes=\"(max-width: 937px) 100vw, 937px\" \/><\/a><\/p>\n<p><strong><span style=\"color: #ff0000;\">STEP 4:<\/span><\/strong> Select the <strong>semicolon<\/strong> as the delimiter and click on <strong>Load<\/strong>.<\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2024\/01\/Excel-CSV-Separator-3.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone wp-image-34252 size-full\" title=\"Excel CSV Separator\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2024\/01\/Excel-CSV-Separator-3.png\" alt=\"Excel CSV Separator\" width=\"1080\" height=\"812\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2024\/01\/Excel-CSV-Separator-3.png 1080w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2024\/01\/Excel-CSV-Separator-3-300x226.png 300w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2024\/01\/Excel-CSV-Separator-3-1024x770.png 1024w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2024\/01\/Excel-CSV-Separator-3-768x577.png 768w\" sizes=\"(max-width: 1080px) 100vw, 1080px\" \/><\/a><\/p>\n<p>This method seamlessly imports the data into Excel with the specified delimiter.<\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2024\/01\/Excel-CSV-Separator-4.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone wp-image-34253 size-full\" title=\"Excel CSV Separator\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2024\/01\/Excel-CSV-Separator-4.png\" alt=\"Excel CSV Separator\" width=\"426\" height=\"435\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2024\/01\/Excel-CSV-Separator-4.png 426w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2024\/01\/Excel-CSV-Separator-4-294x300.png 294w\" sizes=\"(max-width: 426px) 100vw, 426px\" \/><\/a><\/p>\n<p>&nbsp;<\/p>\n<h2><span class=\"ez-toc-section\" id=\"Change_Separator_in_Window_Setting\"><\/span><strong><span id=\"4\" style=\"color: #ff0000;\">Change Separator in Window Setting<\/span><\/strong><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>To <strong>change the Excel CSV separator for all programs<\/strong> in your computer instead of just Excel files, follow the steps below &#8211;<\/p>\n<p><strong><span style=\"color: #ff0000;\">STEP 1:<\/span><\/strong> Open the <strong>Control Panel<\/strong> on your computer.<\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2024\/01\/Excel-CSV-Separator-105.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone wp-image-34249 size-full\" title=\"Excel CSV Separator\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2024\/01\/Excel-CSV-Separator-105.png\" alt=\"Excel CSV Separator\" width=\"393\" height=\"883\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2024\/01\/Excel-CSV-Separator-105.png 393w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2024\/01\/Excel-CSV-Separator-105-134x300.png 134w\" sizes=\"(max-width: 393px) 100vw, 393px\" \/><\/a><\/p>\n<p><strong><span style=\"color: #ff0000;\">STEP 2:<\/span><\/strong> Go to <strong>Clock and Region<\/strong>.<\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2024\/01\/Excel-CSV-Separator-103.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone wp-image-34248 size-full\" title=\"Excel CSV Separator\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2024\/01\/Excel-CSV-Separator-103.png\" alt=\"Excel CSV Separator\" width=\"1400\" height=\"734\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2024\/01\/Excel-CSV-Separator-103.png 1400w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2024\/01\/Excel-CSV-Separator-103-300x157.png 300w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2024\/01\/Excel-CSV-Separator-103-1024x537.png 1024w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2024\/01\/Excel-CSV-Separator-103-768x403.png 768w\" sizes=\"(max-width: 1400px) 100vw, 1400px\" \/><\/a><\/p>\n<p><strong><span style=\"color: #ff0000;\">STEP 3:<\/span><\/strong> Select <strong>Region<\/strong>.<\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2024\/01\/Excel-CSV-Separator-102.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone wp-image-34247 size-full\" title=\"Excel CSV Separator\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2024\/01\/Excel-CSV-Separator-102.png\" alt=\"Excel CSV Separator\" width=\"1397\" height=\"729\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2024\/01\/Excel-CSV-Separator-102.png 1397w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2024\/01\/Excel-CSV-Separator-102-300x157.png 300w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2024\/01\/Excel-CSV-Separator-102-1024x534.png 1024w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2024\/01\/Excel-CSV-Separator-102-768x401.png 768w\" sizes=\"(max-width: 1397px) 100vw, 1397px\" \/><\/a><\/p>\n<p><strong><span style=\"color: #ff0000;\">STEP 4:<\/span><\/strong> In the dialog box, under the <strong>Formats<\/strong> tab click on <strong>Additional Setting<\/strong>.<\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2024\/01\/Excel-CSV-Separator-101.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone wp-image-34246 size-full\" title=\"Excel CSV Separator\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2024\/01\/Excel-CSV-Separator-101.png\" alt=\"Excel CSV Separator\" width=\"553\" height=\"701\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2024\/01\/Excel-CSV-Separator-101.png 553w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2024\/01\/Excel-CSV-Separator-101-237x300.png 237w\" sizes=\"(max-width: 553px) 100vw, 553px\" \/><\/a><\/p>\n<p><strong><span style=\"color: #ff0000;\">STEP 5:<\/span><\/strong> In the Numbers tab, <strong>modify the List separator<\/strong> field.<\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2024\/01\/Excel-CSV-Separator-100.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone wp-image-34245 size-full\" title=\"Excel CSV Separator\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2024\/01\/Excel-CSV-Separator-100.png\" alt=\"Excel CSV Separator\" width=\"521\" height=\"755\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2024\/01\/Excel-CSV-Separator-100.png 521w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2024\/01\/Excel-CSV-Separator-100-207x300.png 207w\" sizes=\"(max-width: 521px) 100vw, 521px\" \/><\/a><\/p>\n<p>By making this adjustment at the system level, Excel will interpret separators based on the modified settings.<\/p>\n<p>&nbsp;<\/p>\n<h2><span class=\"ez-toc-section\" id=\"Conclusion\"><\/span><span style=\"color: #ff0000;\"><b>Conclusion<\/b><\/span><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>Whether you prefer changing settings in <a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/excel-interview-questions\/\" target=\"_blank\" rel=\"noopener\"><strong>Excel<\/strong><\/a>, indicating the separator in the <a href=\"https:\/\/support.microsoft.com\/en-au\/office\/import-or-export-text-txt-or-csv-files-5250ac4c-663c-47ce-937b-339e391393ba#:~:text=When%20you%20save%20a%20workbook,character%20using%20Windows%20Region%20settings.\" target=\"_blank\" rel=\"nofollow noopener\"><strong>CSV<\/strong><\/a> file, utilizing the <a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/import-data-from-text-using-power-query-or-get-transform\/\" target=\"_blank\" rel=\"noopener\"><strong>Text Import<\/strong><\/a> Wizard, or adjusting Windows settings, these methods provide flexibility for handling CSV delimiters based on your specific needs. Mastering these techniques ensures efficient data manipulation and analysis in Excel.<\/p>\n<p><span style=\"font-weight: 400;\">Learn more about Formulas with our <\/span><span style=\"font-weight: 400;\"><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/top-excel-formulas-function-examples-to-get-better-at-microsoft-excel\/\" target=\"_blank\" rel=\"noopener\"><strong>101 Advanced Excel Formulas &amp; Functions Examples<\/strong><\/a>.<\/span><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Microsoft Excel is a powerful spreadsheet application widely used for data analysis and manipulation. When working with CSV (Comma-Separated Values) files, you may encounter situations where you need to change the Excel CSV separator from comma to semi-colon. Let us look at each of these points in detail. Download the Excel Workbook below to follow [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":34284,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"cos_headline_score":0,"cos_seo_score":0,"cos_headline_text":"How to Change Excel CSV separator","cos_headline_has_been_analyzed":false,"cos_last_analyzed_headline":[],"om_disable_all_campaigns":false},"categories":[10],"tags":[1567,1566,1565],"acf":[],"_links":{"self":[{"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/posts\/34229"}],"collection":[{"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/comments?post=34229"}],"version-history":[{"count":0,"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/posts\/34229\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/media\/34284"}],"wp:attachment":[{"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/media?parent=34229"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/categories?post=34229"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/tags?post=34229"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}