Since version 11.1 (I'm on 18.104.22.16819) when exporting to Excel CSV the first row/column has quotes around the first entry.
Export row grids in Excel CSV is placing quotes around the first row.
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.
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.
Issue #1077: add UTF-8 BOM in Excel output only in file-mode, not in copy-mode. See https://www.heidisql.com/forum.php?t=37190
Please login to leave a reply, or register at first.