Datagrip Clipboard to Excel

When I copy Datagrip contents to my clipboard and paste to excel, all values get pasted to one column with comma separation.  Is there a way to format clipboard contents so they go into individual columns?  Otherwise I have to do text to columns in excel every time.

Also, tangentially related-- I am unable to export contents to csv in utf-8.  I export Japanese characters often and seemingly the only way to get utf representation is through copying to clipboard.

1 comment

Hello Andrew,

You can configure different separator for the extractor when copying content to the clipboard in Configure CVS Formats... dialog.

About encoding issue: please check Encoding Settings https://www.jetbrains.com/dbe/help/file-encodings.html for the project. The project encoding set there should work.

0

Please sign in to leave a comment.