Excel Not Saving CSV with Commas: 7 Possible Methods

Method 1 – Changing Separator When Saving CSV

Steps:

  • Select the File tab from the ribbon.

  • Go to Options.

Changing Separator When Saving CSV

  • A dialog box titled Excel Options will appear.
  • Select the Advanced option.

Changing Separator When Saving CSV

  • Under the Editing Options, uncheck the Use system separator to edit. Set the Decimal separator as the Dot (.) and the Thousand separator as the Comma (,).
  • Check the Use system separator to prevent further change and click OK.

Changing Separator When Saving CSV

  • Select File > Save As.
  • Choose a suitable location to save your file and write down a name for it. In the file format option, choose CSV(comma-delimited) (*.csv) and click Save.

Changing Separator When Saving CSV

  • Close the file and right-click on your mouse on the file, and choose Open with > Notepad.

  • The file will open in Notepad and you will get all the text separated with commas.

Changing Separator When Saving CSV

The process worked perfectly, and we were able to fix the issue of Excel not saving CSV with commas.


Method 2 – Open CSV in a Text Editor

You have to open a CSV file with a Text Editor to see the content inside of it. Use the Notepad text editor. When you open the file here, you can manually make any kind of modification in this file. If your dataset contains a vast amount of data, don’t make any changes here. It may manipulate your dataset, and your original data may get lost.


Method 3 – Save Your Excel File as ‘CSV UTF-8 (Comma Delimited)’

Steps:

  • Select the File on the left side of the Home tab.

Save Your Excel File as ‘CSV UTF-8 (Comma Delimited)’ to Excel not saving CSV with commas

  • Select the Save As option.
  • After that, define your file with a suitable name, and choose your desired location to save the file. In the file format box, select the file extension CSV UTF-8 (Comma Delimited) (*csv).
  • Click Save to complete the process.

Save Your Excel File as ‘CSV UTF-8 (Comma Delimited)’ to Excel not saving CSV with commas

  • Close the Excel file and right-click on your mouse on the file, and choose Open with > Notepad.

  • The file will open in Notepad and you will get all the text separated with commas.

Save Your Excel File as ‘CSV UTF-8 (Comma Delimited)’ to Excel not saving CSV with commas


Method 4 – Indicate Your Separator Directly

Steps:

  • Open the Notepad app and write down the following text.
  • Declare the separator as ‘sep=,’.

Indicate Your Separator Directly to Excel not saving CSV with commas

  • The file with a name according to your desire with the file extension .txt. Keep the Encoding as UTF-8. We set Data as our file name. Click the Save button and close the text file.

  • Launch Microsoft Excel on your computer and select File > Open.

  • Or press the ‘Ctrl+O’ keyboard shortcut to open a file with Excel.

Indicate Your Separator Directly to Excel not saving CSV with commas

  • Select the text file.
  • Excel might give you a warning; ignore it and click Yes.

  • See all the data sets in the worksheet pretty nicely.

Indicate Your Separator Directly to Excel not saving CSV with commas

  • Save the file with the file format CSV(Comma delimited) (*.csv) and click Save.

Indicate Your Separator Directly to Excel not saving CSV with commas

  • Open the new file with Notepad, you will see that our dataset is saved in the CSV format.

Indicate Your Separator Directly to Excel not saving CSV with commas


Method 5 – Choose Delimiter from Text Import Wizard

Steps:

  • In the recent version of Excel, the Text Import Wizard is not available in the ribbon of Excel. You have to enable it from the Options.
  • To enable Text Import Wizard, select File > Options.

Changing Separator When Saving CSV to Excel not saving CSV with commas

  • The Excel Options dialog box will appear.
  • In this box, select Data.
  • Under Show legacy data import wizards, check From Text (Legacy) and click OK.

Choose Delimiter from Text Import Wizard to Excel not saving CSV with commas

  • Press ‘Ctrl+O’ on your keyboard to open a file.

  • Select the file titled Text.txt and click Open.
  • A dialog box called Text Import Wizard will appear. Choose the Delimited and click Next.

Choose Delimiter from Text Import Wizard to Excel not saving CSV with commas

  • In the second step, select the Delimiters as Semicolon and again click Next.

Choose Delimiter from Text Import Wizard to Excel not saving CSV with commas

  • Keep the Column data format in General and finally click Finish.

Choose Delimiter from Text Import Wizard to Excel not saving CSV with commas

  • A new Excel file titled Text will open.
  • Select File > Save As.
  • Choose the suitable location to save your file and write down a name for your file, In the file format option, choose CSV(Comma delimited) (*.csv) and click Save.

Choose Delimiter from Text Import Wizard to Excel not saving CSV with commas

  • Close the Excel file and right-click on your mouse on the file, and choose Open with > Notepad.
  • See all the text separated with commas, and the file is saved in CSV format.

Choose Delimiter from Text Import Wizard to Excel not saving CSV with commas


Method 6 – Using Power Query

Steps:

  • In the Data tab, select Get Data > From File.
  • Choose the From Text/CSV option.

Using Power Query to Excel not saving CSV with commas

  • A dialog box called Import Data will appear.
  • Select the file titled Text and click Import.

  • Another dialog box entitled Text.txt will appear.
  • Keep the Delimiter as Semicolon and click Load.

Using Power Query to Excel not saving CSV with commas

  • A new sheet titled Text will be created automatically, and the data will be imported as a table.

Using Power Query to Excel not saving CSV with commas

  • Select File > Save As.
  • Choose the suitable location to save your file and write down a name for your file, In the file format option, choose CSV(Comma delimited) (*.csv) and click Save.

  • Close the Excel file and right-click on your mouse on the file, and choose Open with > Notepad.
  • See all the text separated with commas, and the file is saved in CSV format.

Using Power Query to Excel not saving CSV with commas

 


Method 7 – Modifying Regional List Separator

Steps:

  • Select the Start menu of your computer.
  • Write down Control Panel in the Search bar and select the Control Panel app.

Modifying Regional List Separator

  • Select the Change date, time, or number format from the Clock and Region option.

  • A new dialog box will appear, entitled Region.
  • Select the Additional settings option.

Modifying Regional List Separator

  • Another dialog box called Customize Format will appear.
  • Change the List separator to comma (,) and click OK.

Modifying Regional List Separator

  • Click OK to close the Region dialog box.
  • Click the Close button on the right corner of the Control Panel.
  • In the Excel worksheet, go to File > Save As.

  • Write down a suitable name for your file; in the file format option, choose CSV(Comma delimited) (*.csv) and click Save.

Modifying Regional List Separator

  • Close the file, and right-click on your mouse on the file, and choose Open with > Notepad.

  • The file will open in Notepad and you will get all the text separated with commas.

Changing Separator When Saving CSV


Download Practice Workbook


Related Articles

<< Go Back to Export Excel to CSV | Export Data from Excel | Learn Excel

Get FREE Advanced Excel Exercises with Solutions!
Soumik Dutta
Soumik Dutta

Soumik Dutta, having earned a BSc in Naval Architecture & Engineering from Bangladesh University of Engineering and Technology, plays a key role as an Excel & VBA Content Developer at ExcelDemy. Driven by a profound passion for research and innovation, he actively immerses himself in Excel. In his role, Soumik not only skillfully addresses complex challenges but also demonstrates enthusiasm and expertise in gracefully navigating tough situations, underscoring his unwavering commitment to consistently deliver exceptional, high-quality content that... Read Full Bio

We will be happy to hear your thoughts

Leave a reply

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo