MySQL Bugs: #87156: Add "Copy Row (with names, tab separated)" to MySQL Workbench Results Grid

Bug #87156	Add "Copy Row (with names, tab separated)" to MySQL Workbench Results Grid
Submitted:	21 Jul 2017 12:11	Modified:	2 Feb 2018 13:12
Reporter:	Richard Sargent	Email Updates:
Status:	Verified	Impact on me:	None
Category:	MySQL Workbench: SQL Editor	Severity:	S4 (Feature request)
Version:	6.3.9, 6.3.10	OS:	Windows (Windows 10)
Assigned to:		CPU Architecture:	Any

Description:
It would be very helpful to be able to copy rows, including the headers, from the results grid and paste them into a spreadsheet. Workbench has the ability to copy tab separated rows, but there is no way to copy tab separated rows and headers.

Please Add "Copy Row (with names, tab separated)" to the right click menu in the Results Grid. 

How to repeat:
Run any query that generates results in the Results Grid.
Select all the results in the Results Grid
Right Click on one of the fields.
User should be able to select "Copy Row (with names, tab separated)"

Suggested fix:
Add "Copy Row (with names, tab separated)" to the right click menu in the Results Grid.

Hello Richard Sargent,

Thank you for the feature request!

Thanks,
Umesh

Please implement this.  The tab separated is the easiest way to paste to excel.  But this lack of feature means you won't get column headings when you do it that way.  I paste the column headings to a file, change the commas to tabs, then paste into a new row in excel.  Waste of time!

In SSMS (Microsoft), ctrl+shift+c does this automatically.  It's literally 100 times as fast to get data into excel from an ad-hoc query.

I created a pull request here:

https://github.com/mysql/mysql-workbench/pull/19

Took 1 minute to code, 4 hour to get workbench to build.

I'd really like this too! Copy/Paste to Excel is painful otherwise (need to use Text Import Wizard).