How to Convert Excel to CSV without Opening (4 Easy Methods)

Method 1 – Using the ‘Save As’ Command to Convert Excel to CSV

Steps:

Go to the File tab.

Select Save As and click on CSV(Comma delimited).
Click on the Save button. The CSV file will be saved in the folder where the previous xlsx file is saved. To save the new CSV format file in another location, click on the Browse option and specify a folder where you want to save it.

The CSV file is in the following picture.

You will be able to convert Excel to CSV. To open the file, right-click on it and select the Open with option. Select Notepad.

You have converted the Excel file into a CSV file.

Method 2 – Converting Excel to CSV as ‘CSV UTF-8’ Format

Steps:

Go to the File tab.

Select Save As and click on CSV UTF-8 (Comma delimited).
Click on the Save button. The CSV file will be saved in the folder where the previous xlsx file is saved. To save the new CSV format file in another location, click on the Browse option and specify a folder where you want to save it.

The CSV file is in the following picture.

You will be able to convert Excel to CSV. To open the file, right-click on it and select Open with. Select Notepad.

You have converted the Excel file into a CSV file.

Method 3 – Embedding VBA Code to Convert Excel to CSV

Steps:

Press Alt+F11 to open the VBA editor.
Select Insert > Module.

Enter the following code:

Sub convert_Excel_to_csv()
Dim ws1 As Worksheet
Dim path_1 As String
Application.ScreenUpdating = False
path_1 = ActiveWorkbook.path & "" & Left(ActiveWorkbook.Name, InStr(ActiveWorkbook.Name, ".") - 1)
For Each ws1 In Worksheets
ws1.Copy
ActiveWorkbook.SaveAs Filename:=path_1 & "" & ws1.Name & ".csv", FileFormat:=xlCSV, CreateBackup:=False
ActiveWorkbook.Close False
Next
 Application.ScreenUpdating = True
End Sub

Close the Visual Basic window.
Press ALT+F8.
When the Macro dialogue box opens, select convert_Excel_to_csv in the Macro name. Click on Run.