Copy table to clipboard, Excel-ready

Dave posted 4 years ago in Import/Export
Would it be possible now or in a future release to copy tables or query results to the clipboard so that all one would have to do is paste directly into an Excel spreadsheet, and rows and columns would conform properly?

Perhaps I've missed this feature and it is already here.

Thanks very much!smile
ansgar posted 4 years ago
This is already a feature in HeidiSQL - you just need to set the control characters which Excel expects in Tools > Preferences > Export:
Field separator: \t (Tab)
Field encloser seems not to be important for Excel
Line separator: \r\n (Microsoft linefeed)
Additionally, you should check "Use local number format..." on the same page.
ansgar posted 4 years ago
Ah, forgot to mention the most important thing :)
In the end, just right click any data or query grid > Copy data > Copy as CSV
Dave posted 4 years ago
Oh, excellent!! Thank you!! Made my day!!

Please login to leave a reply, or register at first.