Dump Data to Clipboard with headers

Answered

I'm trying to export my data into EXCEL.

 

part of my data is in Simplified Chinese - which causes issues when exporting to CSV (CSV doesnt identify chinese caracters). 

excel export would fix the problem as well... which is not available.

Hence, The only way for me to export my data in readable form is to 'copy to clipboard' , and paste into excel, which is fine. The problem I have with this is that headers are excluded. Is there a setting somewhere where i can include column headers with 'copy to clipboard' finction?

 

Data Example: http://prntscr.com/ed3yvs

CSV export showing 'gibberish' example: http://prntscr.com/ed3z7p

Copy to clipboard->paste in excel example of missing headers: http://prntscr.com/ed3znr

4 comments
Comment actions Permalink

I'd like to see this too. Copying to clipboard with headers would be a lot faster than saving out a file and opening it up and deleting it after. Seems like an obvious feature.

0
Comment actions Permalink

You can set it as a global setting: follow instructions here:

https://www.jetbrains.com/help/datagrip/csv-formats-dialog.html

0

Please sign in to leave a comment.