Save as CSV file (UTF-8) with double quotes - how?

[Peter Snabe]

Hi

I often need to save data as a CSV file (UTF-8) where all cells are surrounded by double quotes. I cannot find any way to do that in Excel - can it be true? Any idea how to do that?

[#2]

Use the PowerShell option , it is the only way I found that works @winston_dowling 

[#3]

This is the way

[#4]

Use this online https://tableconvert.com/csv-to-csv

@Peter Snabe 

[#5]

This was the only solution that worked with my file. One problem though: if you have a number entered in the cell, even if the cell is formatted as [text] and special format is applied, the Double Quotation Character ["] will not be added.
To go around this problem I had to add Single Quotation Character ['] in front of the number that made excel to treat it as text and after exporting into csv format deleted all single quotation signs using Notepad.
If anyone has a better idea, please let me know.