Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

How do I get "table view" working for CSV data in PyCharm?

I used to able to rely on the ability to edit CSV data in PyCharm (and other JetBrains IDEs) in a fully functional tabular view:

enter image description here

however I can't find this functionality anywhere in my current version (5.0.x).

How do I get this functionality back?


Note that it appears that I can right click on the selected text of the CSV and choose something called (incorrectly and misleadingly) "Edit as Table..."; but this can't be intended as a replacement for the missing functionality!

like image 551
orome Avatar asked Feb 08 '23 04:02

orome


2 Answers

According to the PyCharm Docs:

For the table editor and associated features to be available:

  • You should be using the Professional Edition of PyCharm. (The corresponding functionality is not available in the Community Edition.)
  • The Database Tools and SQL plugin must be enabled. (This plugin is bundled with the IDE and enabled by default.)
  • The file name extension must be associated with the text file type. See e.g. File Types.

I use Professional Edition, so im my case, the issues was in missing association of file type. I fix it next:

  1. Go to `File | Settings | Editor | File Types
  2. Find Text file type
  3. Add *.csv to the Text file type.
  4. Save end exit
like image 82
Alex Zveruk Avatar answered Feb 11 '23 19:02

Alex Zveruk


Please vote for DBE-1845 to be notified on any progress. As a temporary workaround you can try assigning a keyboard shortcut to "Edit as Table..." action as suggested in https://youtrack.jetbrains.com/issue/DBE-1845#comment=27-1193834

like image 35
lena Avatar answered Feb 11 '23 17:02

lena