Export row grids in Excel CSV is placing quotes around the first row.

Since version 11.1 (I'm on 11.1.0.6119) when exporting to Excel CSV the first row/column has quotes around the first entry.

You may need to select ANSI encoding for your version of Excel.

I'm copying to clipboard and this happens on both Excel and Google Sheets. This also happened after the last upgrade.

Did you follow my encoding hint?

I have the same problem. I made sure that the standard encoding of Excel is set to "Westeurope (Windows)", but this did not solve the issue. The value in most upper-left cell always appears in quotation marks when inserting results from the clipboard that have previously put into the clipboard by Heidi`s "export as Excel CVS" function. This is not the first time I come across this issue. However, in the past I could heal this behaviour by deinstalling and reinstalling HeidiSQL. This time however that method does not work either.

What about my hint for selecting ANSI encoding in HeidiSQL's export dialog?

Thanks for your quick reply.

Yes, the export dialog shows "Encoding: ANSI" (please refer to attached screenshot).

Actually I cannot even change that setting while "Copy to clipboard" is selected.

Oh, got it - I overread you were referring to the Copy to clipboard option, not the file option. So we have a new issue here, broken for solving issue #1077. I was adding a UTF8 BOM for both the file and the copy option, but it should only be added in file mode. I am going to fix that.

Should be fixed in the next build.

Dear Ansgar.

I can confirm that with build 6128 the issue is fixed (at least on my system). Thank you very much for solving this so quickly!