Save Excel as CSV with Double Quotes (3 Simplest Methods)

Saving CSV files with double quotes is necessary to avoid any misrepresentation. For example, consider the row of data USD,25,000,Model1. Here, the comma delimiter is a little confusing. Instead, USD,“25,000”,Model1 is easier to decipher. We’ll save the Excel file with values in double quotes so it can be ported to different applications easier.

Save Excel as CSV with Double Quotes: 3 Quickest Ways

Method 1 – Use the Custom Format to Save Excel File as CSV with Double Quotes

Consider the following dataset. You want to save it as a CSV file with cell values wrapped in double-quotes.

Steps

• Select the entire range (A1:B6) of the dataset.
• Press Ctrl + 1 to open the Format Cells window.
• Select the Custom format from the Number tab.
• Enter \“#\”;\“@\” in the Type field.
• Press OK.

• Select File and choose Save As. Browse the desired location to save the file.
• Enter a file name.
• Choose CSV (Comma delimited) (*.csv) as the file type using the dropdown arrow.
• Click on the Save button.

• Go to the file’s location and open the CSV file with a text editor (such as Notepad).

• You will see the following result containing some extra double-quotes.

• Press Ctrl + H to open the Replace window.
• Enter a double quote in the Find what field without any space in between them.
• Keep the Replace with field empty and select Replace All.
• You will get the desired result as follows.

Read More: How to Save Excel File as CSV with Commas

Method 2 – Use Windows PowerShell

Steps

• Go to the worksheet that you want to save as a CSV file.
• Select File and choose Save As.
• Save the file with CSV (Comma delimited) (*.csv) as the file type using the dropdown arrow.
• Click on the Save button.

• You will get the following result.

• Hold the Shift key and right-click on any blank space in the location of the CSV file without double-quotes.
• Click on Open PowerShell window here.

• Copy the following command. You need to change the file names (Sales1.csv and Sales2.csv) based on your files.

• Paste the copied code into the PowerShell window and press Enter.

• You will get the desired result as shown in the picture below.

Read More: Set Comma Instead of Semicolon as Delimiter in Excel CSV

Method 3 – Apply VBA Code for a CSV File with Double Quotes

Steps

• Press Alt + F11 to open the VBA window.
• Select Insert and pick Module from the ribbon. This will create a new module.

• Copy the code below:

Sub ExcelToCSV()
Dim rng, row, cell As Range
Dim dqt, dlim, text As String
Dim file As Variant
On Error Resume Next
If ActiveWindow.RangeSelection.Count > 1 Then
text = ActiveWindow.RangeSelection.AddressLocal
Else
text = ActiveSheet.UsedRange.AddressLocal
End If
Set rng = Application.InputBox("Please select the data range:", "ExcelDemy.Com", text, , , , , 8)
If rng Is Nothing Then Exit Sub
file = Application.GetSaveAsFilename("", "CSV File (*.csv), *.csv")
dlim = Application.International(xlListSeparator)
Open file For Output As #1
For Each row In rng.rows
dqt = ""
For Each cell In row.Cells
dqt = dqt & """" & cell.Value & """" & dlim
Next
While Right(dqt, 1) = dlim
dqt = Left(dqt, Len(dqt) - 1)
Wend
Print #1, dqt
Next
Close #1
If Err = 0 Then MsgBox "The CSV file has been saved to: " & file, vbInformation, "ExcelDemy.Com"
End Sub

• Paste the copied code onto the module.

• Press F5 to run the code.
• This will ask for your desired range. Toggle back to the worksheet and select the range.
• Press OK. This will take you directly to the Save As window.

• Browse the location for the file and enter a name. Click on Save.

• Excel will show the following message. Press OK.

• You can check the file.

Explanation of the VBA Code

Read More: How to Convert Multiple Excel Files to CSV

Things to Remember

• You need to give the proper file path in the PowerShell command in case you open it from other locations.
• You need to change the file names based on your files.

Download Practice Workbook

Related Articles

• How to Create CSV File from Excel
• How to Convert Excel File to Text File with Comma Delimited
• Convert Excel to Comma Delimited CSV File
• How to Make a CSV File in Excel for Contacts
• How to Convert Excel Files to CSV Automatically
• How to Convert Excel to CSV without Opening
• [Fixed!] Excel Not Saving CSV with Commas

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