Remove quotes when converting CSV to Excel

[AlexMB]

Hi all,

I'm using the following technique to convert CSV data into Excel:

Convert CSV files to Excel workbooks - Office Scripts | Microsoft Docs

However, as some values in the CSV contain a comma, they are wrapped in quotes. Example:

Header1,Header2,Header3
A,"1,00",Foo
B,"2,00",Bar

The quotes are carried over to Excel, which is unintended.

Header1	Header2	Header3
A	"1,00"	Foo
B	"2,00"	Bar

Can I edit the script or otherwise remove the quotes from the final Excel somehow?

[DamoBird365 · Accepted solution]

Hi @AlexMB 

Assuming it is column B, just add the following to the end of your script:

selectedSheet.getRange("B:B").replaceAll("\"", "", {completeMatch: false, matchCase: false});

Please consider accepting my answer as a solution if it helps to solve your problem.

Cheers
Damien

Please take a look and subscribe to my YouTube Channel for more Power Platform ideas and concepts, or take a look at my website. Thanks