Copy table to clipboard, Excel-ready

[expired user #3694]'s profile image [expired user #3694] posted 14 years ago in Import/Export Permalink
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's profile image ansgar posted 14 years ago Permalink
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's profile image ansgar posted 14 years ago Permalink
Ah, forgot to mention the most important thing :)
In the end, just right click any data or query grid > Copy data > Copy as CSV
[expired user #3694]'s profile image [expired user #3694] posted 14 years ago Permalink
Oh, excellent!! Thank you!! Made my day!!

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